I’m currently using the measure “Average days in transition status” to calculate the days in status.
It’s working pretty well until we have some issues that were transitioned from a specific status more than once.
Details: issue A was transitioned from status B 3 times, total days in status B: 60 days => average days in status B of issue A = 60/3, and actually we want to see 60 days as the result.
Can you please help alter this measure so it would fit our use case?
Measure “Average days in transition status” calculates an average time over the count of transitions , not count of issues. The calculation is the total days in selected transition statuses divided by the count of status transition. If an issue transitioned to the same status 3 times, then the total time is divided by 3 transitions.
To count Average days in transition status by issues, you might want to define a new calculated measure like this:
CASE WHEN [Measures].[Transitions from status issues count] > 0 THEN
[Measures].[Days in transition status] /
[Measures].[Transitions from status issues count]
Zane / support@eazyBI.com