You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.
View groupJoin the community to find out what other Atlassian users are discussing, debating and creating.
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:
SLA goal is displayed in the UI, so it should be in there somewhere:
Thanks!
Rik
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
OOTB you would need to recalculate that in Excel, Sheets, Numbers.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Jack,
Thanks for your answer!
Unfortunately I hit a problem with this method this morning: my report had calculated the SLA goal for the ticket's current priority (P2 => 2h), but the SLA was fulfilled under the ticket's original priority (P4 => 16h). Result: my report is showing a negative resolution time for this particular ticket (as in: it was solved 12 hours before it was logged...).
To make the recalculation work, I would basically need the state of the ticket at the time the SLA was fulfilled, so I can calculate the correct SLA goal at that time. Any idea if I can make that work somehow?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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 @Gokce Gursel _Snapbytes_ suggested or check on the Marketplace.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @Rik ,
You can do this using Time to SLA.
You can use SLA detailed report to extract SLA dates and durations (working (time elapsed) and remaining) and SLA dates (start,target and end dates) and export them to Excel by clicking the Export button.
Please let me know if you have further questions.
Cheers,
Gökçe
Please note that I'm one of the members of the Snapbytes team.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
We often have questions from folks using Jira Service Management about the benefits to using Premium. Check out this video to learn how you can unlock even more value in our Premium plan. &nb...
Connect with like-minded Atlassian users at free events near you!
Find an eventConnect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.
Host an eventYou're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.