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

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root


1 badge earned


Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!


Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.


Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!


Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
Community Members
Community Events
Community Groups

Data behind the SLA Breached vs Met report?

Hi Team,

I trust you are well.

I need your help please. I posted this question on the community board but I haven't had an answer as yet.

Please advise how to view the data behind the SLA Breached vs Met report?

I need to create an SLA Breached vs Met Excel report and dashboard that displays whether the SLA has been met or breached.

Thank you 


Dean Verappan


Hi Team,

I am grateful for the 'likes' but I need to urgently resolve this dilemma.

I have a customer who is waiting on this report.

Please urgently advise.

Much appreciated.

Have a great day

Jack Brickey Community Leader Mar 23, 2022

So again your goal is to do this in excel correct? Assuming so, Then I think that you will need to export issues that are done with the following data: Resolution date, created date. You will also need to know what your SLA value is and your calendar info for the sake of calculation. Basically you’re going to have to calculate the time between your created date and your resolution date. Then compare that value to the SLA goal.

Obviously a positive value in the SLA at the time the resolution is set indicates the SLA was met whereas a negative value indicates a miss.

Hi Jack,

Thanks for responding. 

I've given this a go but I cannot seem to get the information in the SLA Breached vs Met report in Jira.

The graphical report is there - all I need is to view the data behind the report.

Surely we should be able to do this with ease as the report has already been built...

@Dean Verappan , if I understand correctly under the reports section of your JSM project you have created a met vs. breached report, correct?  Now you are wanting to see the details of the issues that are associated with that report, correct? Below the graph you will see the summary by day for example. You can click on the individuals days which will present the details (issues) in list view. Now if you wanted to show all issues in list view you could simply build a JQL filter for this e.g.

project = abc and resolutiondate >= startofweek(-1) and resolutiondate < startofweek()

The above would give you all issues that were resolved "last week". You can then assess met vs. breached by including the SLA, e.g. Time to resolution in the columns.

Good morning Jack,

Thank you - I'll give that a go.

Have a great week...

Hello @Dean Verappan 

You can try SLA Time and Report, developed by my SaaSJet team which allows showing Exceed vs Met issues.


It can be shown as Charts or exported to Excel or CSV files. 

Hope it helps.

Good morning Mariana,

Thank you, but that's not quote what I am looking for.

Have a great week...


Log in or Sign up to comment