Counting issues in each transition status

Questions & Answers
1

I would like to count number of issue in each transition status.
The below code is not working properly. It is not only counting sub-task while I am looking for parent tasks but also counting in each status is wrong.

Count(
Filter(
DescendantsSet([Issue].CurrentHierarchyMember,[Issue].[Issue]),
[Measures].[Transitions to status]>0
OR
[Measures].[Issues history]>0
)
)

2

Hi @Behzad_Nazarbakhsh

You can use the Predefined “Sprint issues at closing” measure together with the Transition Status dimension:

sprintissues-at-closing
sprintissues-at-closing1698Ă—868 72.4 KB

This will show you how many issues were in each Status at the moment of Sprint closing.

​Best regards,
​Nauris

1 Like