I want to create aging of reports by calculating (Age of reports=Created date-Resolved Date)

[User212122]

Hi all,

I have a requirement where i have to create a report for calculating the age of the incidents which are there in ServiceNow pool.

I thought of doing it by calculating the age of the incident by following formula:

Age of incidents=Created date - Resolved Date.

Also i need to create a report of it in the format of: 7-Days, 8-15 Days, 16 -30 Days, >30 Days

So can you guys suggest how should i approach this problem?

Regards,

Sunil Arya

[Bradford Shelle]

If I recall correctly, the duration field looks at the difference in time between the resolved date and the created on date. Sounds like something which might be useful.

From there you could go to Reports -> Report Ranges and define your time ranges for the Incident duration fields, then build a report that groups by Incident duration.