I’m struggling to create a calculated measure to identidfy the average number of sprints all the completed issues have gone through.
First, I created this measure:
But, I don’t know how to calculate this for the entire project. I’ve tried to understand the documentation, but this is not very clear.
Can anyone help me?
The measure you have created would return the count of sprints for an issue, yes. The next step is to use the Avg(…) function to specify over what set you wish to get the average on higher levels. Please try the following:
[Measures].[Issue Sprints] <> "(no sprint)" AND
[Measures].[Issues created] > 0
Lauma / email@example.com
Thanks for your help. This was exactly what I was looking for.