how is the average velocity calculated on the Kanban Velocity gadget

[Bill Sheboy]

Greetings!

Would you please clarify in the documentation: how is the average velocity calculated? Based upon the documentation below, I would expect that…

• when the interval is set (e.g. one week)
• and the number of intervals for “Display the chart for the last” is equal to the number of intervals for “Calculate average velocity based on last”
• that the average line would be horizonal (zero-slope)

https://bitbucket.org/StonikByte/great-gadgets-add-on/wiki/Home#!kanban-velocity-gadget

However the average line displays as if other values are being used for the average. Are those included values to the left of the first displayed value of the chart? Thus this is always a “running average” rather than the “average”.

Thanks!

[Danut M [StonikByte]]

Hi Bill,

Yes. The “average” is actually a “rolling average” calculated based on the last X previous intervals (according to “Calculate average velocity based on last”), which includes also the current interval.

In your example, you have:

• “Display the chart for the last” = 6 intervals
• “Calculate average velocity based on last” = 6 intervals

The velocity of the 6th (last) interval, which is also displayed as “Current Average Velocity”, is the average of Completed from the 6 displayed intervals.

The velocity of the 5th interval is the average of Completed in the first 5 displayed intervals + the interval before the first one displayed (which is not covered in the chart, but it is displayed in data tab).

The velocity of the first interval displayed in chart is calculated as the average of Completed from the first interval and the 5 intervals before it, which are not displayed in chart.

This is for showing also the average velocity trend, not only a flat line with the current velocity.

Danut.

‌

[Bill Sheboy]

Thanks, Danut. In that case, I suggest changing the language of the documentation page to reflect this is a “rolling average”.

[Danut M [StonikByte]]

The documentation was updated some time ago. Closing ticket.