Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

Average time calculation from open to close using performance analytics

SNow35
Giga Guru

Hi All,

 

I am new to performance Analytics, I need to calculate the average time it took from open to close duration weekly.

I need to do this using performance analytics only.

 

Thanks in advance

1 REPLY 1

jstoessel
Tera Guru

Assuming that the table you are using has a duration, or business duration field that is working.

Use the Unit you want, this is for incident MTTR, so I'm using days

The aggregate is Average and field is Duration

jstoessel_0-1722948929964.png