Hi all,
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?
Thank you,
Duong