The Atlassian Community Forums are currently in read-only mode. We will be relaunching on a new platform on September 22 (read more here). We apologize for the extended downtime. For concerns or questions, please email communitymanagers@atlassian.com. See you on the other side, on the new Atlassian Community Forums! :)

×

Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Reports to show Tickets Prior to SLA Breach

Hannah Lemke
February 16, 2022

I am trying to set up reports for our service tickets to show how long we have until a time breach of our SLA. 

We want 1 report that shows 7 days prior to breach and another that shows 14 days prior to breach. 

Currently this is what I am doing and it isn't working!

"Time to resolution" < remaining(336h) - this one is for 14 day series 

"Time to resolution" < remaining(168h) - this one is for 7 day series

Both are showing the exact same graphs and pulling the same tickets. 

For reference I used this article and the section way at the bottom of it to get these initial JQL codes. 

https://confluence.atlassian.com/servicemanagementserver/using-jql-queries-specific-to-slas-939926424.html 

Help!

1 answer

Comments for this post are closed

Community moderators have prevented the ability to post new answers.

0 votes
Jack Brickey
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Champions.
February 16, 2022

 maybe this?

Set your 14d to...

"Time to resolution" <= remaining(336h) AND "Time to resolution" > remaining(168h)

and 7d to...

"Time to resolution" <= remaining(168h)

basically your first one is anything 14 days or less but greater than seven days and the second one is anything seven days or less