I want to create aging of reports by calculating (Age of reports=Created date-Resolved Date)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-03-2014 02:27 AM
Hi all,
I have a requirement where i have to create a report for calculating the age of the incidents which are there in ServiceNow pool.
I thought of doing it by calculating the age of the incident by following formula:
Age of incidents=Created date - Resolved Date.
Also i need to create a report of it in the format of: 7-Days, 8-15 Days, 16 -30 Days, >30 Days
So can you guys suggest how should i approach this problem?
Regards,
Sunil Arya
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-03-2014 02:41 AM
refer these reports
'Age of Open Items' and 'KPI - Average Incident Resolution Time by Category'
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-03-2014 02:45 AM
Hi Kalaiarasan can you forward a link of these items so that i can go through it
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-03-2014 03:05 AM
Hi kalaiarasan,
the topics you provided are not helping me...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-03-2014 03:13 AM
Hi Sunil,
What Kalai meant was log in to any demo instance and click on "View/Run" report link in left navigation panel. There you would find above two reports, which may help you in your requirement.
