Count number of status changes per ticket

Questions & Answers
1

I currently run a report displaying a list of open issues with some information relevant to us (how old is the ticket, current status etc…).I would like to add info about the number of status changes for every ticket to see a “back-and-forth” effect in numbers. It most probably makes no sense to filter for specific transitions because the workflow we use is not that predictable.

I was looking into Transition to status issue count or something the like but this would be usefull if I want to have totals, averages etc. if I am not mistaken. Is there another predefined measure I am missing?

2

Hi Maiko,

If you want the total number of all status changes, then “Transitions to status” could be the measure you are looking for.
You can use a tuple to count how many times an issue was transitioned to a specific status, for example, “In Progress” (from any status):

([Measures].[Transitions to status],
[Transition Status].[In Progress])

If you have issues in the rows, any number larger than 1 means that the issue has repeatedly re-entered In Progress.

Kindly,
Ilze