Reporting on recently breached SLAs with JIRA Service Desk

I am trying to create an SLA reporting for one of our customers. I am trying to create a filter and subscribe team leaders group to that filter so they get DAILY mail messages about SLA breaches.

Reporting on issues that are close to breach are easy to report. That is no problem. My problem is with issues that has recently breached their SLA targets. If I create a filter with the following JQL I can get all Issues with their SLAs breached.

( "Time to resolution" = completed() AND "Time to resolution" = breached() )

But this filter keeps building up. It shows all past issues. Reporting on SLA breaches of last week or last month makes no sense. Whatever happened has happened there. I need to filter out recent SLA breaches.

How can I filter issues that have their SLAs breached during the last 24 hours?

2 answers

1 accepted

This widget could not be displayed.

Oh yeah that was short of me :)

How about "Time to resolution" < 0

That's what I'm using. I'm semi-working on it today/tomorrow but I'm not very imaginitive with what reports people want ... I get my work done ;)

Yes, that is more promising if used in conjunction with created date. Something like:

created > -2d and "Time to resolution" < remaining ("-1d")

Issues that were opened in the last two days and "Time To Resolution" was breached less that a day ago. Still not exactly what I am asking for but seems to do the trick.

I am having the exact same challenge and have yet to find a better solution/work around.

If anyone has any other suggestions, please post.

Thanks!

This widget could not be displayed.

Hi Emre,

Add created >= "-1d"

Hi,

Yes this can filter out most of the issues but it is based on creation date, not SLA completion date. I gave an example in the question with one SLA for the sake of simplicity and this works with one SLA definition but it fails if I try to do the filter with two SLA definitions with different SLA target durations.

On the other hand, it is better than nothing. Thanks anyway.

Suggest an answer

Log in or Sign up to answer
Atlassian Summit 2018

Meet the community IRL

Atlassian Summit is an excellent opportunity for in-person support, training, and networking.

Learn more
Community showcase
Posted Wednesday in New to Jira

Are you planning to trial, or are currently trialling Jira Software? - We want to talk to you!

Hello! I'm Rayen, a product manager at Atlassian. My team and I are working hard to improve the trial experience for Jira Software Cloud. We are interested in   talking to 20 people planning t...

173 views 2 0
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you