Report on Average Response time and Resolution time
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-23-2019 05:37 AM
Hi Folks,
I would like to know how to create a Weekly trend report on Average Response time and for past 12 weeks and similar trend report on Average resolution time.
Please guide me in this case, and appreciate your help
Thanks in Advance,
Regards,
Naveen Beswa

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-23-2019 06:02 AM
Hi Naveen,
When you mention response time and resolution time in your question, it instantly came to my mind the SLA table. So assuming you have your SLA definitions up and running, the report/dashboard should use it (task_sla).
That table has a column called "target" that will give you either resolution or response. You probably will be looking at the SLAs that are complete. You also have to limit your query to only list the task type you are interested in (eg. incidents, problems, catalog tasks, etc.). Finally, you can calculate your average using either the duration field or the business_duration field depending on your requirements.
You can use the logic above to create reports or PA indicators.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-23-2019 06:15 AM
SLAs are only reliable in that fashion *IF* they're for response and resolution specifically.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-18-2025 11:45 PM
Thankyou @Marcello Correa ,it's helpful
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-23-2019 06:52 AM
Problem 1 - How does your organization currently define Response?
I've seen probably a dozen definitions in the field, and it would be risky for us to suggest something before we know how you already calculate it.
Problem 2 - Average Resolution Time
There are already indicators that track this. Are they not meeting your requirement? If so, how are they different from what you expect?