How to display the sum of hours of each incident

Neil_Carlo24
Tera Contributor

Hello,

I want to display the sum of hours of each incident since opened to closed but my score won't appear.

Neil_Carlo24_0-1738210302848.png

 

5 REPLIES 5

Ankur Bawiskar
Tera Patron
Tera Patron

@Neil_Carlo24 

what's your business requirement here?

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

Hello @Ankur Bawiskar 
Im trying to display the sum of hours each incident from created to closed 

@Neil_Carlo24 

this link has solution

How to calculate average time taken from open to closed incident 

Sharing here again, how to do that

AnkurBawiskar_0-1738219711098.png

 

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

@Neil_Carlo24 

also check these links

How to get duration for Task created to closed ? 

MTTR (Mean Time to Resolution) Reporting

Need a Query For Calculating Mean time to resolve by month

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader