- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-19-2024 04:35 PM
Hi All,
I'm attempting to report on all SCTASKS closed by my team over 12 months by month, broken down by how long the task was open. I've created the below report for this.
The totals for the month are correct, however, the coloured breakdown of days/weeks/months seems to be calculating the time from the time the task was closed. How do I show how long the task was open?
Solved! Go to Solution.
- Labels:
-
Dashboard
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-13-2025 08:15 PM
I eventually managed to do this by creating a report source.
See this KB for details: Opened vs. Closed Task Records combined in one Rep... - ServiceNow Community
Thanks.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-19-2024 08:48 PM
probably you can try creating a custom field and store the value (closed date - opened date ) and use that value in the report.
in general we can use metrics to check that out . I am not sure whether you are having metrics on that particular table or not
Thanks and Regards
sai venkatesh
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-13-2025 08:15 PM
I eventually managed to do this by creating a report source.
See this KB for details: Opened vs. Closed Task Records combined in one Rep... - ServiceNow Community
Thanks.