Need average days for transition status for only non-zero days

Questions & Answers
,
1

Hi,
We are trying to calculate average days for transition status. For example, for transition “Debug => Analyzed”
Bug1 0.00
Bug2 0.00
Bug3 0.00
Bug4 0.00
Bug5 11.04
Bug6 1.09

EazyBI formula for “Average days in transition status” shows average as: (11.04 + 1.09) / 6

We need to calculate average for only bugs for which transition days are above certain threshold value such as 0: (11.04 + 1.09)/2

Any suggestion how to calculate this “non-zero average days in transition status” ?
Thanks,
Vrukesh

2

Hi @vrukesh

You can create a custom measure that iterates through all issues, checking whether their time spent in status is larger than 0.01 days (or select your lower limit).

CASE WHEN [Measures].[Transitions from status] > 0 AND
[Measures].[Days in transition status] >= 0.01
THEN
  [Measures].[Days in transition status] /
 NonZero( count
  (Filter(
      Descendants([Issue].CurrentMember,[Issue].[Issue]),
      ([Measures].[Days in transition status] >=0.01
    ))))
    END

Please let me know if you have further questions regarding this!

Kind regards,

Elita from support@eazybi.com

3

Hi Elita,
Thanks! this formula helps!
Vrukesh