Welcome to Community Week 2025! Join us to learn, connect, and be recognized as we celebrate the spirit of Community and the power of AI. Get the details  

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

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/