Filter required for all issues resolved within 5 days of creation date to support KPI

[Barbara Murray]

Hi, I have a request to provide dashboards/reports to help track KPIs for issues.

The data required is: 

All issues resolved within 5 days of creation date for the current year (or given time frame)

All issues that were not resolved within 5 days of creation date for the current year with number of days open for each issue.

I have only been able to create filters that show issues closed within 5 days but seem unable to do a calculation between created and resolution date.

project = XX AND issuetype = Enabler and resolutiondate >=-5d

Is there a way to create these filters/charts?

My organisation does not allow the downloading of any additional Apps on our Jira Cloud installation.

[Jack Brickey · Accepted solution]

While JSM has the concept of SLAs that can easily provide this type of info, JSW does not. However you can achieve your goal by using a custom field (FiveDay) and automation. The idea here would be to trigger on a transition to your done status and then check the resolution date to see if it’s within five days of the created date. If it is then set your FiveDay to yes otherwise it would be no. Then you can use this FiveDay result in your filters and dashboard gadgets. Let me know if this makes sense or not.

[Barbara Murray]

Hi, thanks for your response, our organisation does not allow for the creation of custom fields so I wouldn't be able to use this solution.  

I will investigate using Eazibi and the custom measures, found a link for that here:

Report on issues closed within number of days from creation - Questions & Answers - eazyBI Community

[Zane eazyBI Support]

Hi @Barbara Murray

Using eazyBI, you can get the desired result in several ways. For example, eazyBI offers grouping issues by the resolution intervals so you can see how many issues were resolved in the first 5 days, 10 days, 30 days, and so on (the intervals are customizable).

Use the measure "Issue created count" to count issues and filter them by the period of creation date. In addition, you may filter data by Time period, Issue type, Project and Priority, and other issue fields. The report might look like in the picture below:

You may check out other reports to analyse issue age, resolution time, and lead time in the demo account here: https://eazybi.com/accounts/1000/dashboards/7513-age-lead-and-cycle-time.

Best,
Zane / support@eazyBI.com

[Barbara Murray]

excellent Zane! thanks for that, will take a look. Those are exactly the sort of questions being asked of me

[Barbara Murray]

when using the Distinct Issues count, I wonder if it can help with a problem I have with a pie chart. We use labels to distinguish different issues, and there can be multiple labels on an issue, so when I display a Pie chart showing the split by labels this will show an issue count of 640 issues instead of the actual number which is 320. This is due to the multiple labels, even if I use the Issues Due Count measure. Is there a potential workaround for that? 

[Zane eazyBI Support]

I feel you, labels are handy and easy to use for sorting issues, but might mess with use when we do reporting.

Labels are multi-selection fields, and the same issue is counted for each of the labels when filtering data by Labels. The distinct count measures, like "Issue created count" and "Issues due count," solves the problem nicely and count issue only once for selected labels (see picture below).

If you have labels on report rows or columns to group results by each label, make sure to have a total row or some higher hierarchy level to show the distinct count of issues matching selected labels (see picture below). 

You may check out this eazyBI Community post on how to handle multiple labels grouping data by label combinations as another alternative: https://community.eazybi.com/t/multi-labels-dimension-table/6276/2

If you have a specific use case and would like some assistance to adjust the report, you may contact eazyBI support or post the question in the community.

[Barbara Murray]

Thanks Zane!

[Barbara Murray]

Hi Zane, just one final question on this, How do you add that total line to the table for the row? 

[Zane eazyBI Support]

In the report toolbar is an option to show the Total row or Total column (see picture below).

[Barbara Murray · Accepted solution]

n

[Jack Brickey]

@Barbara Murray , For sure if you have an addon already in place like eBI that is preferred to custom field in this case.