How to calculate a "MTTR" considering only some statuses

Hi all:

I need to calculate some kind of “MTTRCA” (Mean Time to find out a Root Cause) for Problem Management. I know that there is a measure for that, but the thing is that the Jira project is used by Incident Management team as well, therefore some statuses are part of the Incident whereas others are part of Problem Management.

How to calculate that “MTTRCA” considering only the statuses used by Problem Management (therefore the days spent only on those statuses)?

Thanks!

Hi @walterdp

I would suggest using Issue cycles to define which Statuses should be combined to form which cycles.

You can define them in the Source Data tab in the Jira import options:

​Let me know if this fits your use case or if you have any additional questions on this!
​Best regards,
​Nauris

Hi, @nauris.malitis :

Thanks for replying. I’ll check if this is possible with the cube I have because there are 2 project in it, one is a Jira Software (and this is the one I need to extract the data from) and the other is a Jira Service Management project.

I’ll let you know.

Walter

Hi, @nauris.malitis :

Unfortunately, that option does not appear

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:

Also, you can check out this “Issue days in selected status” Demo report: https://eazybi.com/accounts/1000/cubes/Issues/reports/61947-issue-days-in-selected-status
And also this Dashboard:
Age, Lead, and Cycle Time - Jira Demo - eazyBI

1 Like