Need a bit adjustment with Average days in transition status

Questions & Answers
1

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

2

Hi @jmpsupport,

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]
END

Best,
Zane / support@eazyBI.com