- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-25-2024 11:40 AM - edited 01-25-2024 11:41 AM
Hi all,
I have to create aging report for incidents
I want to show age of incidents in each state.
Not sure how I can do this.
Please someone guide me on this.
Thanks in advance!
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-25-2024 10:46 PM
Hi @BijoyDeb
You can create a simple Bar Report, which is using group by on the Created field.
Sample below.
If you're familiar with PA, you may wanna have a look to this dashboard below which will give you an overview of average age and assignment times and breakdown incidents in different age buckets.
Name: Open Incident Age Monitor
URL: https://<instance_name>/$pa_dashboard.do?sysparm_dashboard=45cb98f1d7f00200b96d45a3ce6103d2
Cheers,
Tai Vu
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-25-2024 11:23 PM
Hi @BijoyDeb ,
Please follow bellow to get a ageing incident report grouped by state:
1.
Create a report based on the incident table:
2.
Select "bars" as type of report.
3.
In the configure tab select group by "created"
In the conditions set condition as state is "in progress":
4. Save the report
5. Add an additional dataset:
6. make the new dataset based on the incident:
7. group by "created":
8 .set condition as state is "on hold":
9. press save dataset:
10. you will see the report shown as:
Please follow above instructions to add other states.
If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.
Best regards
Anders
If my answer has helped with your question, please mark my answer as the accepted solution and give a thumbs up.
Best regards
Anders
Rising star 2024
MVP 2025
linkedIn: https://www.linkedin.com/in/andersskovbjerg/
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-25-2024 11:45 AM
Hi @BijoyDeb ,
Are you trying to creating ageing report that shows time between incident creation and resolution?
If yes, then on incident there a field 'Duration' which calculates the time between incident creation and resolution, you can create a pie report and group by 'Duration' for ageing.
Regards,
Sandeep Raj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-30-2025 10:19 AM
Is there any field same as like "Duration" for the New / In Progress / On Hold tickets ? I wanted to create a report where it has to show the aging of each incident.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-25-2024 07:03 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-25-2024 10:46 PM
Hi @BijoyDeb
You can create a simple Bar Report, which is using group by on the Created field.
Sample below.
If you're familiar with PA, you may wanna have a look to this dashboard below which will give you an overview of average age and assignment times and breakdown incidents in different age buckets.
Name: Open Incident Age Monitor
URL: https://<instance_name>/$pa_dashboard.do?sysparm_dashboard=45cb98f1d7f00200b96d45a3ce6103d2
Cheers,
Tai Vu