How to calculate a "MTTR" considering only some statuses

[nauris.malitis]

Hi @walterdp

Issue cycles have been added since eazyBI version 6.5.0 / Released Jun 27, 2022.
If it is possible, I’d suggest updating eazyBI to the latest version.

If it is not possible, you can use some of the workarounds described in these Community answers:

Avg days between two statuses

@joejames Try this code: CASE WHEN ( [Measures].[Transitions to status], [Transition Status].[Waiting for Production] ) > 0 THEN AVG( Filter( Descendants([Issue].CurrentMember, [Issue].[Issue]), ( [Measures].[Transitions to status], [Transition Status].[Waiting for Production] ) > 0 ), DateDiffDays( ( [Measures].[Transition to status first date], [Transition Status].[In Progress], [Time].CurrentHierarchy.DefaultMember…

Calculate Lead/Cycle Time From Specific Statuses

You would like to check out our example reports in our demo accounts for Cycle and Lead times. We set a dashboard Age Lead, and Cycle Time there to represent different cases. Here are some measures I would like to point as examples: Cycle time for a specific set of statuses for resolved issues and measure Rolling average cycle time in particular. This measure contains two approaches. The formula by default works for any statuses in status category In Progress. There is an alternative solution …

Also, you can check out this “Issue days in selected status” Demo report: Issue days in selected status - Issues - Jira Demo - eazyBI
And also this Dashboard:
Age, Lead, and Cycle Time - Jira Demo - eazyBI