How to Calculate Average Age % of open Incidents

kriti2
Giga Contributor

I have a requirement to calculate the Avg age % open incidents in Days. 

Have applied the below formula 

 

find_real_file.png

 

 

 

OOB we have formula  "Summed age open incidents / Number of open incidents / 24 hours" to calculate Average age open incidents .

Let me know if this is correct way to calculate age % in days?

 

 

Thanks in advance.

1 REPLY 1

AbhishekGardade
Giga Sage

Hello Kriti,

Check out this article:

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

Please mark as Correct Answer/Helpful, if applicable.
Thanks!
Abhishek Gardade

 

Thank you,
Abhishek Gardade