Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Calculating the average time in an SLA

Gavin Johnson June 5, 2018

Hey,

I would like to calculate the average time that a group of tickets have spent in a certain SLA.

For example I have a Time to Resolution SLA and the following filter to determine which tickets have breached the SLA:

issuetype = "Client Problem" AND "Time to resolution" = breached() AND status not in ("In Progress - Customer Feedback", Done, Rejected)

So I would like the average time that each of the tickets spent in the SLA.

I'm running a Cloud instance of Jira Service Desk.

Thanks for your help!

1 answer

0 votes
Qu3ntin
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
December 13, 2018

Hi,

I think you could use the report feature with the (avg) option for the targeted SLA and your JQL filter. You can add series per SLA in the same report.

You will have the avg time per day, week or months.

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events