How to calculate average age of issues in specific status over time

Questions & Answers
1

I defined a calculated measure that sums up specific statuses using Transition Status and Issue history so that I can create a historical view of the number of issues in these statuses.

For that I used

Sum(
  {
    [Transition Status].[A],
    [Transition Status].[B],
    [Transition Status].[C],
    [Transition Status].[D],
    [Transition Status].[E],
    [Transition Status].[F]
  },
    [Measures].[Issues history]
  )

There is a second measure just like that which includes different statuses. I use these two measures in a bar diagram so that our company can get a feel for how the numbers compare(d) each month.

Now we want to add how old the issues in these status group are on average and I just can’t get this to work. Every calculation I’ve tried until now returned either nothing or wrong numbers.

Is there a way to calculate the average of the issues in my calculated measures? Or a different way entirely to group multiple statuses into one big number and getting the average age?

I have already seen the Average Age of Open Issues report, that’s not what I need since the issues in both groups are open and not resolved and need separate age calculations. I also don’t think i need “Average resolution days” because most of these issues aren’t being resolved for 200+ days. The measure Average days in transition status also seems to be wrong on my end, because i’m getting really small numbers using that but most of our issues are insanely old so I would expect big numbers.

Can anybody help me here?

2

Hello @Kal

Thanks for posting your question!

Please take a look at our demo report here - Issue days in selected status - Issues - Jira Demo - eazyBI it shows how you may create a report combining the time issues spent historically and including the time they have spent in the current status.

You may also take a look at the report here - Cumulative Age by status report - Issues - Jira Demo - eazyBI that may be something similar to what you are looking for. It will require you to import the Interval dimension access the Age interval dimension ( Data from Jira )

Best wishes,

Elita from support@eazybi.com

1 Like
3

Thank you so much for your reply. This is what I was looking for. Unfortunately it seems that we have reached the limits of eazyBI with 140,000 issues in one project so I can’t use the custom measures needed without timeouts. But it’s good to know for future reference.