Catalog items: Average Time to Close Report

[Jon Collins2]

Hi Folks, 

I need to build a report for a specific team's catalog items, and it needs to list their average turn around time and average time to close. I am not sure where to start in my report, to accomplish this. Is there an OOTB metric to accomplish anything like this?

Thanks in advance. 

[Saurav11]

Hello jon,

Are sla attached to your ritm's you may use tge task sla fields to acheive this

Please ark correct/helpful based n response

[Jon Collins2]

We do not have SLA's built out for this yet. Is there a way to pull a metric without this?

[Jon Collins2 · Accepted solution]

I was able to build a report that gave me the data we were after. Using the [sc_task] table, I built the following: