Average time of all tickets in specific status

Hi everyone, I’m trying to build a report that tells me how long the tickets have spent in their lifecycle (from funnel to done), in each phase.

I am currently using “Average days in current status” but unfortunately the numbers only refer to the current tickets in the current phases.

-- Average days in transition status and days since last transition
    Descendants([Issue].CurrentMember, [Issue].[Issue]),
    -- for unresolved issues only
    IsEmpty([Issue].CurrentHierarchyMember.Get("Resolved at")) AND
    IIF([Transition status].CurrentHierarchyMember.Level.Name = "Transition Status",
        [Transition status].CurrentHierarchyMember.Name = [Measures].[Issue status], 1) AND
    IIF([Status].CurrentHierarchyMember.Level.Name = "Status",
        [Status].CurrentHierarchyMember.Name = [Measures].[Issue status], 1)
  -- Total days calculation (both in transition and since last transition)
    [Status].CurrentHierarchyMember.Level.Name = "Status" and Not [Transition Status].CurrentHierarchyMember.Level.name = "Transition Status",
      ([Measures].[Days in transition status],
       [Transition Status].[Transition status].GetMemberByKey(
      [Measures].[Days in transition status]
  ) +
    [Measures].[Issues history] > 0
      [Measures].[Issue status updated date],

But what I am interested in is the answer to the question - If I look at all the tickets that existed, how long did they spend on average in which phase/status?

So if I look at one ticket that has run through completely, I want to know how long the issue was in each status on average (also in the status funnel, which is not recognized as a transition status).

This will be visualized in a bar chart with statuses on the X-Axis and average days on Y-Axis.

Hi, @DNL

Welcom to the eazyBI community!

The measure you are looking for is “Average days in transition status” together with the “Traision Status” dimension. This measure will calculate the average days that the issue stayed in status that is selected in the Transition status dimension. Please read more here: Import issue change history

Depending on what you want to see on the rows, the report should look something like this:


Hi @ilze.mezite , thanks for the reply!

Unfortunately this doesn’t work out properly :frowning:

  1. It only shows the average days of the tickets, which are currently in the specific status (no historic values)
  2. It only shows the values for the transition status → Funnel is not included here.

I basically want to see for the sum of all tickets (which some day will all be in status “Completed”), the time they spent in average in each status.

Thanks in advance!

Hi, @DNL

I’m sorry to hear that.

Did you use the “Transition Status” dimension? This won’t work with the Status dimension.


Hi @ilze.mezite ,

thank you very much!

I managed to to visualize it using the 2 measures from the following thread: