I'd like to chart how our (iteration) velocity averaged over 2 and 4 iterations has evolved over the last x weeks. This chart would show a moving average.
I can calculate an average velocity over the last 2 or 4 iterations (using an average query, grouping by iteration and restricting the iterations considered using a (4 Iterations Ago) project variable. For example.
I can chart the number of cards/points completed in a given iteration (using a property such as "Completed In").
However, I'm trying to combine the two. Any ideas?