Export SLA goal in Jira Cloud for Excel

Question

Hi,

For a report for stakeholders of our service desk, I need to report on the time it took to provide a first response on the ticket.

I've configured SLA rules for this (called Time to first response), which seem to be working fine. Unfortunately, in reporting, I can't access all the information I need.

I can access acolumns that provide information on this SLA: Time to first response shows me a countdown to the SLA goal (i.e. Goal Duration minus Actual Duration, for example 8h goal minus the 2h 30m it took to provide first response => column will display 5h 30m.

Is there a way to export:

* time elapsed on the SLA
* SLA goal

SLA goal is displayed in the UI, so it should be in there somewhere:

Thanks!

Rik

PaKat · Answer

Hi @Rik

I have the same task, to collect the time of the first response on the ticket, and whether our work meets the SLA.
Nowhere can I find information? Can I gather this information without plugins?

I will be very grateful to everyone for their advice!

Mariana_Pryshliak_Saasjet_qysy8m · Answer

Hello @Rik

You can try SLA Time and Report to set up SLAs for your tickets.

It allows you to set and track time frames for all types of projects (Jira service management, Jira Software, and Core). To get First Time Response data, you need to select "to do" or "waiting for support" status (depending on your project's statuses) as a Start condition. And "Comment from(assignee or reporter)" as a Stop condition.

Also, you can export SLA data as XLSX or CSV files - which is very convenient for further analysis.

I hope, you find this helpful

Best regards, Mariana

Jack Brickey · Answer

that gets messy. For sure there are limitations w/ Excel and I don't know of a one-size-fits-all solution. You would have to manually manipulate the data. If this is an ongoing and important need consider an addon like what @Gökçe Gürsel {Appfire} suggested or check on the Marketplace.