Dear community,
I need to create the Velocity chart for Sprints. I started with default one, using Sprint as Pages and Rows and default measures: Sprint Story Points committed, Sprint Story Points completed, Sprint Story Points completed of committed . It works perfect, but I have a bit more complicated request.
I need to improve this Velocity chart to be able to see:
Story points of issues in status Planned, that were added before the start of the Sprint
Story points of Issues that were Done during the sprint and were in status Planned in the begging
Story points of all issues, that were Done during the sprint
I’ve created my own measures:
Planned, before spring start
(
[Measures].[Story Points added],
[Transition Field].[Sprint status],
[Sprint Status].[Active],
-- An issue was in a sprint at a sprint start time
[Issue Sprint Status Change].[Future => Active],
[Transition Status].[Planned]
)
The second one return the same result as a first one. I think it is because I don’t have information about the Status change and [Measures].[Planned] just return me issues in Planned status.
As a second solution I tried to create the custom field: “Planned before sprint started”. I think to filter my custom measures, based on the isEmpty of this field will be the best option for me, but I’m failing in the implementation.
Could you please help me to resolve my problem? Thanks in advance for any help!!!
We have already solved this issue in support emails, here is a summary.
Story points of issues in status Planned, that were added before the start of the Sprint
You already have got the calculation. I would write it shorter, but the calculation is correct both ways.
([Measures].[Sprint Story Points committed],
[Transition Status].[Planned])
Story points of Issues that were Done during the sprint and were in status Planned at the begging
Measure “Sprint Story Points completed” shows story points from all sprint issues in Done status at the sprint closing, e.g., we can use this measure to detect sprint Done issues.
You need to apply two conditions to the issue: status at the sprint start (measure “Sprint Story Points committed” with transition status Planned) and status at the sprint end (measure “Sprint Story Points completed”). To do that, you need to iterate through issues and check both conditions on an issue level, and then sum them up. In the following formula, I check whether the issue was committed as Planned, and then, from committed Planned, I count completed issues:
Sum(
Filter(
Descendants([Issue].CurrentMember, [Issue].[Issue]),
([Measures].[Sprint Story Points committed],
[Transition Status].[Planned])>0),
[Measures].[Sprint Story Points completed]
)
Story points of all issues, that were Done during the sprint
Measure “Sprint Story Points completed” would show all issues in Done status at the sprint closing.
To exclude points from issues that were Done already at the sprint commitment, you may detect issues (story points) in status Done at the commitment moment and then do a subtraction:
[Measures].[Sprint Story Points completed]
-
Sum(
Filter(
Descendants([Issue].CurrentMember, [Issue].[Issue]),
([Measures].[Sprint Story Points committed],
[Transition Status.Category].[Done])>0),
[Measures].[Sprint Story Points completed]
)