nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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.

Accepted answers

Jack Brickey

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

All comments

Jack Brickey

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:

eazyBI issue resolution time by creation date.png

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

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.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

cloud

jira-software

jira-software-cloud