How to calculate average age of open incidents and requested items

Ankita Gupte
Kilo Sage

I want to calculate average age of all open incidents and open requested item in instance

Kindly help how to calculate.

8 REPLIES 8

hello,

Navigate to Performance Analytics->widgets

find_real_file.png

 

Here search for Average age open Incident, you will get the score widget

find_real_file.png

 

Now you can add this score widget to any Dashboard of your choice to see the single scores

Please mark answer correct/helpful based on Impact

Hello Saurav,

I added this to dashboard.

find_real_file.png

It showing me until Jan 6.

I just want total average age of all open incidents.

Like if there are total 50 open incidents in instance so average age of 50 open incidents today.

Hello,

Go to the Dashboard Named Incident Management then goto Incident open tab. There you will see the widget Average age of Open Incident.

If your jobs are ative then it should show the correct value.

find_real_file.png

Please mark answer correct/helpful based on impact.

I am getting below graph

find_real_file.png

which is 181 days average age on 6jan 2022.

I am not able to understand how should I explain this to client how servicenow is calculating average age of open incidents.

The requirement is single value of average in days for all open incidents.