I want to aggregate the results for several sprints, but i am getting the wrong number. I am getting 70 while the number i want to get is (12+10+19+15)
From what i understand, if an issue was committed for in several sprints, the result will take the Story Points committed on each of those sprints. What i am expecting it to do, is to take the committed only in the sprint where the issue was completed.
Can you suggest how can i adjust the measure to achieve that?
The current formula may not give you the expected results because it’s summing committed story points for completed issues. When you look at the sprint’s indivudally - some of the issues might have been skipped, because they were not completed in the particular sprint.
Instead of using a custom calculation, I’d recommend using the built-in measure Sprint Story Points completed of committed. This measure specifically tracks story points from issues that were:
Committed when the sprint started
Completed when the sprint closed
This will give you a more accurate count of story points actually completed within each sprint.
The measure is designed to handle cases where issues roll over between sprints, only counting the points in the sprint where they were both committed and completed.