Transition to Status in Sprint

[Tina_McCoy]

Hello!

I am trying to create a bar graph that will show how many times an issue was transitioned between certain statuses during a sprint. I’ve built the report, however, the data is not correct. Out of the 26 transitions in the Peer Review to In Progress transition, only 12 of those happened during the sprint shown (the others happened in previous sprints). In addition, the Code Review to In Progress transition has only happened 1 time during the sprint.

What should I update to get the report to show only those transitions that happened during the sprint? I thought using the Sprint dimension would accomplish this but it appears that is not working as I expected.

[Tina_McCoy]

I was able to figure this issue out .

[gerda.grantina]

Hi @Tina_McCoy
Great to hear you were able to solve it. Could you share your solution if someone else is searching for a similar solution?
Also, here you can find a similar solution:

Is there a way to count number of reopens in a sprint and how many times each ticket got reopened

Hi, This community is still young and growing; sometimes answers are not provided as quickly as you would hope. I understand that you would like to get only those transitions which happened during dates while a sprint was active. Measures Transitions to status and Transitions to status issues count are associated with Sprint dimension through issues within a sprint. Therefore measures may return transitions an issue had even before a sprint had started. This is what you may do to get an accur…

Kind regards,
Gerda // support@eazyBI.com

[Tina_McCoy]

@gerda.grantina Of course! I created a new Calculated Measure to only get the transitions that happened during the sprint:

 ([Measures].[Transitions to status],
    [Sprint Status].[Active])