Aging report for incidents

BijoyDeb
Tera Contributor

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!

2 ACCEPTED SOLUTIONS

Tai Vu
Kilo Patron
Kilo Patron

Hi @BijoyDeb 

You can create a simple Bar Report, which is using group by on the Created field.

Sample below.

Screenshot 2024-01-26 at 13.44.03.png

 

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

Timi_0-1706251544128.png

 

Cheers,

Tai Vu

View solution in original post

AndersBGS
Tera Patron
Tera Patron

Hi @BijoyDeb ,

 

Please follow bellow to get a ageing incident report grouped by state:

 

1.

Create a report based on the incident table:

AndersBGS_0-1706253396157.png

2.

Select "bars" as type of report. 

AndersBGS_1-1706253417244.png

3.

In the configure tab select group by "created"

AndersBGS_2-1706253466173.png

In the conditions set condition as state is "in progress":

AndersBGS_3-1706253517525.png

4. Save the report

5. Add an additional dataset:

AndersBGS_4-1706253563793.png

6. make the new dataset based on the incident:

 

AndersBGS_5-1706253594789.png

7. group by "created":

AndersBGS_6-1706253630746.png

8 .set condition as state is "on hold":

AndersBGS_7-1706253659595.png

9. press save dataset:

10. you will see the report shown as:

AndersBGS_8-1706253757476.png

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/

View solution in original post

5 REPLIES 5

Sandeep Raj Ram
Tera Contributor

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 

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. 

Maik Skoddow
Tera Patron
Tera Patron

Hi @BijoyDeb 

please watch the following video: https://www.youtube.com/watch?v=mjA4Qf6nynY

Maik

This ServiceNow tutorial will demonstrate how to create incident aging report in ServiceNow and how to create aging report in ServiceNow. A ServiceNow aging report allows you to view the ServiceNow incident age. Incident age refers to how old a ServiceNow incident or ServiceNow request is and is ...

Tai Vu
Kilo Patron
Kilo Patron

Hi @BijoyDeb 

You can create a simple Bar Report, which is using group by on the Created field.

Sample below.

Screenshot 2024-01-26 at 13.44.03.png

 

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

Timi_0-1706251544128.png

 

Cheers,

Tai Vu