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

0 votes
Jack Brickey
Community Champion
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

Suggest an answer

Log in or Sign up to answer