Display ave age from creation to status Completed

Questions & Answers
1

Hi everyone, I am trying to display all issues that went from creation date to status Completed with the following formula but the result is blank. Any ideas?

CASE WHEN [Measures].[Open issues] > 0 THEN
[Measures].[Total resolution days] / [Measures].[Transitions to status].[Completed]
END

2

Hi, @Haig

Welcom to the eazyBI community.

Please consider using Issue cycles: Issue cycles

With issue cycles, you define the whole cycle you are interested in, the each status can be used only once. And the cycle can be defined as one for the whole account.

If that is the limitation that is not working for you, please consider the following:

  1. Creating the aggregated member in the Status dimension that includes all the statuses till the issue is completed. I called mine “open statuses”. Please see here how to create a new calculated member in dimension: Calculated members in other dimensions

  2. Use the measures “Days in transition status” and “Transitions from status issues count” to get the average age. Read more about these measures here: Import issue change history

(
  [Measures].[Days in transition status],
  [Transition Status].[open statuses]
)
/
(
  [Measures].[Transitions from status issues count],
  [Transition Status].[open statuses]
)

Kindly,
Ilze

3

Thanks Ilze. That was it.