I need to calculate a 5 sprint average of one of the metrics

Questions & Answers
1

Basically, I need a new column (calculated measure) which is the average of the previous 5 sprints.

I have tried unsuccessfully, as this is related to the position in the table:

Screenshot 2024-07-30 125829

How can I do it?

Thank you,

2

Hi @guillolb,

Have you tried the predefined calculated measure “Running Story Points velocity for 5 closed sprints”? It calculates the average of resolved Story Points for the current sprint and 4 previous closed sprints of the same board.

Best,
Roberts // support@eazybi.com

3

Hello,

Thanks for your response.

I have used it, but it’s not what i need.

I want the average over 5 sprints of the resolved percentage. (Resolved/committed)

Thank you,

4

Does anyone know the answer?

5

Hi @guillolb,

In that case, use the same formula in a new calculated measure, and in the Avg() function numeric expression part, divide the measure “Sprint Story Points completed” with “Sprint Story Points committed”.

Best,
Roberts // support@eazybi.com

6

Sorry, i just saw your message.

But how do I tell the AVG function to do it for the past 5 sprints?

7

FYI, After lots of search and trying, I found the solution:

Avg(
LastPeriods(5, [Sprint].CurrentHierarchyMember),
[Measures].[Velocity - % Completed]
)