Average time spend by status (transitions + current state)

[gerda.grantina]

Hi @jriehn ,
First of all, the measure “Days in transition status” is not working with dimension “Status” as you would expect. Measure “Days in transition status” is a historical measure and works with the dimension “Transition status”, see more here: Import issue change history

But, yes, you are right, this question is reoccurring one and my colleague has provided a detailed answer here for the needed measure:

How to calculate Days in transition status including the time in current status

The measure Days in transition status works for issues that already moved out from the status. Zeros might indicate an issue was moved out of the status shortly after adding to the status (or have transitioned to the same status). It does not include the time since the last status update. The following MDX formula (use it to define a new calculated member in Measures) will include in the calculation also days in the current status: -- days in transition status when issue was in this status in …

Also, we have a demo report that you may want to check for calculated measure: Issue days in selected status - Issues - Jira Demo - eazyBI

best,
Gerda // support@eazyBI.com