Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

calculate 3-sprint rolling average for throughput

Hi there!   May I know how I can get a 3-sprint rolling average of througput from table structure below? Throughput = sum of user story and bug per sprint Example: Sprint 10 = 3TP (2US + 1B) Sp...
Need Help
Tips and Tricks
Tutorial Requests
  • daxer-almighty's avatar
    daxer-almighty
    5 years ago

    First of all, you have to have a column that numbers your sprints consecutively in order to be able to move among them. Then it's rather easy:

     

    [3-Sprint Avg] =
var AverageOverCount = 3
var MaxSprintNo = MAX( Sprints[SprintNo] )
var SprintNoStart = MaxSprintNo - AverageOverCount
var Result =
    calculate(
        countrows( Sprints ) / AverageOverCount,
        SprintNoStart <= Sprints[SprintNo],
        Sprints[SprintNo] < MaxSprintNo,
        REMOVEFILTERS( Sprints[Sprint Name] )
    )
return
    Result

     

daxer-almighty's avatar
daxer-almighty
Icon for Solution Sage rankSolution Sage
5 years ago

First of all, you have to have a column that numbers your sprints consecutively in order to be able to move among them. Then it's rather easy:

 

[3-Sprint Avg] =
var AverageOverCount = 3
var MaxSprintNo = MAX( Sprints[SprintNo] )
var SprintNoStart = MaxSprintNo - AverageOverCount
var Result =
    calculate(
        countrows( Sprints ) / AverageOverCount,
        SprintNoStart <= Sprints[SprintNo],
        Sprints[SprintNo] < MaxSprintNo,
        REMOVEFILTERS( Sprints[Sprint Name] )
    )
return
    Result

 

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Thank you for this!