New Measure related to Story Points


I need to compute the following formula, for each sprint:
(# story points created - # story points closed) / (average velocity)
average velocity = average # story points closed per sprint


Hi @diarra2339,

Calculations on average velocity usually require to specify a set of data (Sprints in your case) over which to calculate that average velocity. I would recommend starting with “Sample Sprint velocity chart” in your eazyBI (if you have imported sample reports) or with Velocity reports in eazyBI Demo account:

Both reports use the same calculated measure Running velocity for 5 closed sprints that calculates the average velocity for the last five closed sprints before a selected sprint. You may use this calculation as a frame for your average velocity measure and adjust the criteria for filtering the sprints or the count of sprints that should be considered for calculation.

Zane /