How to calculate Age of the tickets?

[taqdeer]

Hi All,

I want to calculate the age of the incidents on the incident table.

Could some one please help me on starting from creating the Age field and till it calculates the age.

Thanks.

[Jaspal Singh]

Hi Taqdeer,

You can use Metric reporting available OOB. So, report on Incident Metric table & get ageing calculated by on basis of State, Assignment group, Assigned To.

Also, check link that has detailed steps & should help you for creation.

[sachin_namjoshi]

You do not need to create any field.

If you have performance analytics, this is available OOB with PA dashboard, indicators.

Regards,

Sachin

[Gaurav Shirsat]

Hi Taqder

There is no direct OOB feature that is available other than the duration field. You shall use duration field which calculates on resolve or use the code that calculates during resolve and store it in your custom field.

You Can Achieve this by Using the Metrics or With The help of Scheduled Jobs.

Refer This

https://community.servicenow.com/community?id=community_question&sys_id=9f709a52dbb83b48d82ffb243996...

 Please Mark Correct and Helpful

Thanks and Regards

Gaurav Shirsat

[Gaurav Shirsat]

Hi Taqdeer

Please Find the below Answer.

Actually This Belongs to Analytics..

https://community.servicenow.com/community?id=community_question&sys_id=912b7658db863340fff8a345ca96...

Please Mark Correct and Helpful

Thanks and Regards

Gaurav Shirsat