Measure that shows the solved StoryPoints of the last 90d

Questions & Answers
1

Hello everybody,
I would like to create a measure that shows me the sum of all StoryPoints solved within the last 90d.

This measure should work for every day independently. E.g. at the 1st of January 2022 I would like to see the sum of all StoryPoints solved within the last 90d beginning from the 1st of January.

“Solved” means for me, that the Storys are in the status closed (not cancelled).

Thank you in advance & Greetings from Germany,
Volker

2

@Volker

Try creating a new calculated measure using this formula:

Sum(
{
[Time].CurrentMember.Lag(89):
[Time].CurrentMember
},
[Measures].[Sprint Story points completed]
)

It will calculate the sprint story points completed sum for the period of the last 90 time members for each day/month/year.

You can read more about sprint scope measures here: Jira Software custom fields

Martins / eazyBI

1 Like
3

Thanks Martins,
this works quite well for StoryPoints that are solved within a completed Sprint. Is there also a possibility to measure all solved StoryPoints even when they are in a current active Sprint?

Best Regards,
Volker

4

Managed to do it on my own…with the help of Martins :slight_smile:

Sum(
{
[Time].CurrentMember.Lag(89):
[Time].CurrentMember
},
[Measures].[Story Points resolved]
)

Thank you very much Martins

1 Like