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
You may group issues by resolution time using interval dimension “Resolution interval”.
- In import options, select to import the interval dimension (Jira Issues Import - eazyBI for Jira).
- In the report set Interval dimension on report rows and measures “Issuers resolved” on columns
- 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
Zane / support@eazyBI.com