Data behind the SLA Breached vs Met report?

[Dean Verappan]

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 

Regards

Dean Verappan

[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]

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.

[Dean Verappan]

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...

[Jack Brickey]

@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.

[Dean Verappan]

Good morning Jack,

Thank you - I'll give that a go.

Have a great week...

[Mariana_Pryshliak_Saasjet]

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.

[Dean Verappan]

Good morning Mariana,

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

Have a great week...