Count if Average Resolution Days within SLA

Questions & Answers
,
1

Hello
I have a report that lists issues resolved for a given month. Each row is an issue and I am showing the Average resolution days for each. I’d like to add a measure to count if that time was within 45 days.

My guess is a need a different report to also view that but the MDX for the countif is what I am stuck on

2

Hi @JohnMichael_Talarico,

You may group issues by resolution time using interval dimension “Resolution interval”.

  1. In import options, select to import the interval dimension (Jira Issues Import - eazyBI for Jira).
  2. In the report set Interval dimension on report rows and measures “Issuers resolved” on columns
  3. Open the interval dimension and edit intervals to match your use case. There are more details on how to specify the intervals: Interval dimensions - eazyBI

Here is another example in the Demo account of how you can sort issues in two groups - less than 45 days and more than 45 days - using interval dimension in the calculated measure: Issue resolution days (Lead Time) - Issues - Jira Demo - eazyBI

Best,
Zane / support@eazyBI.com