How can we create Aging Report for Incidents.

[Aswathy3]

How can we create Aging Report for Incidents.

Based on buckets we need this report as list of bar type.

Buckets will be,

Aging > 60 days

Aging > 45 days

Aging > 30 days

Aging > 7days

Also we need to Schedule this report to share every day.

Please help me with this.

Thanks

Aswathy

[Krishna Penaka · Accepted solution]

https://community.servicenow.com/community?id=community_question&sys_id=00a3a1a0db00e380feb1a851ca96...

[Aswathy3]

Hi Krishna,

Thanks for your help.

I need to include Aging Duration(Duration type field) field also in the Incident form , in which i need to populate the elapsed time.

I have tried the similar way of adding Aging Category in this requirement also. but it is not getting updated 

[Aswathy3]

Hi,

Anyone please help me to include "Aging Duration"  also in the Incident form.

So that we can know, how much days the is now the ticket is with particular group.

Thanks 

Aswathy

[Andrew_TND]

Hello,

There's 3 ways I recon you can do this the easiest is by creating bar graph and grouping it by created. This will give you the quanity of how many are created today, 2 days old, 2-5 days etc etc...

If you wanted something more tailored is that you'll need to make 4 different reports or combine 4 different data sets together via the data structure area. (highlighted)

Aging > 60 days - Created = relative before 60 days ago

Aging > 45 days - Created = relative before 45 days ago

Aging > 30 days - Created = relative before 30 days ago

Aging > 7 days - Created = relative before 7 days ago

If you have admin access and you're happy to make some scripting changes follow the link below at Mark strangers response. 

https://community.servicenow.com/community?id=community_question&sys_id=00a3a1a0db00e380feb1a851ca96...

Please mark as helpful or if its answered the question please mark as correct!