Background: I need to report on how often an issue was transitioned more than once to a particular status during its lifecycle, the assumption being that if it was transitioned to this status more than once, something didn’t go to plan (ie. it had to be backtracked and re-worked on).
Eg. During October 2019, 50 issues were resolved, and the average number of times these issues were transitioned into the ‘QA’ status was 1.5.
Hope this makes sense, any pointers would be appreciated.
Hi @Doug
One way how to achieve this would be to create a new calculated measure that calculates the average number of times the resolved issues went through each transition status. Please have a look at the formula below:
AVG(
Filter(
Descendants([Issue].CurrentHierarchyMember,[Issue].[Issue]),
DateInPeriod(
[Measures].[Issue resolution date],
[Time].CurrentHierarchyMember
)
),
([Measures].[Transitions to status],
[Time].CurrentHierarchy.DefaultMember)
)
Then you can select the Transition Status dimension in columns and the Time dimension in rows. The measure then would display the average times all the issues resolved in that time period transitioned to the specific statuses in the columns. Please have a look at the picture of a sample report below:
You can use the “Drill through” issues feature to see which issues have been the problematic ones where the value of the measure is higher than one.
You can find out more about calculated measures and members on the eazyBI documentation page - https://docs.eazybi.com/eazybijira/analyze-and-visualize/calculated-measures-and-members.
Best,
Roberts // eazyBI support
