Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

JQL or report for avarage overrun SLA

Hello :) 

in the first place I'm sorry for maybe little bit confused description but I work with JIRA about 1 month. 

I would like to make a report about SLAs to show avarage SLAs overrun. In this situation we have lots of tickets which didn't keep SLA and I would like to say "our avarage overrun SLAs on B priority incidents is 1h30m". 

I'm pretty sure that JQL will not help me but if I try to make a report in SD the numbers are incorrect. 


Thank you for every help,



1 answer

1 accepted

0 votes
Answer accepted


Hi! You haven't said how your version isn't correct, but let's say you have a "time to resolution" SLA configured. You can just do your standard incident search on the B priority incidents and look for those which breached the SLA...

project = myProject and and priority=B and "Time to Resolution" = breached()  

...and then include the Time to Resolution column in your issue columns. Export your issues and calculate your average. It isn't the most elegant solution but should get you where you close to where you want to be without add-ons. 



Suggest an answer

Log in or Sign up to answer

Community Events

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

Find an event

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

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you