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

[Kalaiarasan Pus]

saw the reports ? Sumeet just told you how to access those ....

[User212122]

Hi Kalaiarasan,

I tried those reports and i edited the range responses according to my requirements.

I have one question editing report ranges in the reporting module is a good practice?

[Kalaiarasan Pus]

if you are trying on demo , no issues.. but on your instance might be ... depends on the size of the results being returned .. But shouldn't cause any problems I guess ...

[User212122]

Hi Kalaiarasan,

The reports u mentioned are not helping to calculate the age i want to calculate the ticket was present in the pool...

From the created date untill it was resolved by your reports i am only getting a counts of open tickets

[User212122]

Hi all,

With the help of duration field can we calculate the age of tickets...??

I wrote a script to calculate duration and then using it on the reports