I want to create a report : Report Name: Average resolution time of resolved cases for team. Type: Pivot or Graph. Details: Average of how long cases took to be closed over the selected time period for the team (use resolved date not closed date).
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-27-2020 10:44 PM
Hi ,
I have a requirement as follows :
I want to create a report :
Report Name: Average resolution time of resolved cases for team.
Type: Pivot or Graph.
Details: Average of how long cases took to be closed over the selected time period for the team (use resolved date not closed date).
Can someone tell how to achieve this?
Thanks in advance
Thanks in advance
7 REPLIES 7
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-28-2020 01:02 AM
Hi,
Can you do the same for HR case table?
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-28-2020 01:05 AM
Just do the same report for hr case table and check if there is resolution, duration field available.
If not please contact you servicenow admins to add such.

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-28-2020 01:44 AM