Report Needed for Age of Oldest “New” Incident

[supriya pratapa]

I want to generate a report that shows the age of the oldest incident in the New state.
For instance, if an incident was created on December 1st and is still in the New state today, the report should show the number of days between December 1st and today.

[sumityadav8]

Hii @supriya pratapa 

I hope this helps 

https://www.servicenow.com/community/developer-forum/aging-report-for-incidents/m-p/2805301

Just Change accordingly as per use case

If you find my answer as Helpful, please mark it as helpful🙂

Warm Regards,

Sumit Y

Technical Consultant

[Ankur Bawiskar]

@supriya pratapa 

you can use a function field in your report and it will store the difference between created time and now time

see this link where I shared approach, see and enhance

Function field to calculate Ageing in Report Designer 

see these links also

Platform: Reporting || Knowledge & Troubleshooting Resources 

Incident Age Calculate Report-Live Tracking 

Script illistration - incident.age.days 

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏

[Dr Atul G- LNG]

Hi @supriya pratapa 

I doubt what you’re looking for is possible, but we can only get this based on the out-of-the-box reports

[Mark_Branscombe]

I would look into reporting on the Incident Metric [incident_metric] table with an appropriate Metric Definition.

"Create to Resolve Duration" is an out of box example that may be suitable.

The Duration [mi_duration] field will hold the age of the incident, however this will be expressed as a duration rather than a strict number of days, however this should fulfil the functional requirement using out of box functionality.