Excel Plug-in When running a query to obtain the SLAs it only shows times

[Julio Banegas]

When I use the excel plug in to get data about all requests in my service desk it returns all requested data but in the SLAs fields it only shows times and not whether that particular issue was "Met" or "Breached". I have different customers in the same Jira Service Desk Project and the time does not tell me if the issue met SLAs because I have different SLAs for different organizations and priorities. Is there any way to add this in the Excel field report ?

[Earl McCutcheon]

Hello @Julio Banegas ,

That is a great idea to add in the additional data as a subfield option for the SLA fields.

I created the following Feature request for some follow up, please make sure to add your vote and drop some comments on the request if there is anything else you can think of to improve on this, as well as how this is currently impacting your reporting efforts:

• https://jira.atlassian.com/browse/API-387

as for a workaround, I added the following to the feature request:

Workaround

Define various sheets using JQL to group the SLA variables and show a list of the various states in each sheet as covered in Write JQL queries for SLAs:

• breached()
• everBreached()
• paused()
• completed()
• running()
• withincalendarhours()
• elapsed()
• remaining()

As an example, if you wanted a report to show the differences between all completed SLA's for the "time to first response" metrics that have breached and a list of all completed that have not breached use the following JQL on sheet 1 to show the non breached and completed SLA:

"Time to first response" = completed() AND "Time to first response" != everBreached()

And the second sheet would use the following JQL to show all completed but did not meet the metric goal:

"Time to first response" = completed() AND "Time to first response" = everBreached()

And you could take that a bit further and have your primary data sheet with all the values and then the subsequent sheets with the separated data points per grouping and name the sheet something like everBreached and neverBreached and then on your main datasheet do something like what is described in This example from the Mr.Excel forum to add in a validation column of the current status using the sheet titles. Or possibly use the same formulas but with conditional formatting to highlight the SLA fields with a defined color based on the status.

Hope this gets you pointed in the right direction, and thanks again.

Regards,
Earl