Hello,
I’m building report for ‘Done’ issues in completed sprints and calculating the number of working days since the first transition to the resolved date.
However, since I’m filtering based on sprints - the date returned for ‘Transition from status first timestamp’ is of the First transition since the related sprint start date - and this is the problem!
If the work started in previous sprints, it seem that the transition related measures returns data only within the selected sprint dates.
Any idea how to get the real date of the first transition and not be limited by the related sprint dates?
Any measure, including the “Transition from status first timestamp” will follow the context of the report. If you’re filtering by a specific sprint, the measure will return the first timestamp during that sprint.
You can, however, use a tuple in the formula to adjust the scope of the measure.
In this case, instead of using simply this:
[Measures].[Transition from status first timestamp]
Use this instead:
(
[Measures].[Transition from status first timestamp],
[Sprint].CurrentHierarchy.DefaultMember
)
This will override the current Sprint context in the report and use the DefaultMember (the “All Sprints”) member together with this measure.
This should allow you to capture the timestamp of the first transition across all sprints for this issue.
Let me know if this fits your use case or if you have any additional questions on this!
Best regards,
Nauris