Average of sc_task records created each month based on RITMs that have a specific category

DTulbure
Tera Contributor

Hi all.

So my OM recently asked within my team how many on average tasks are created for a new starter. For each starter, we have to create tasks on the specific RITM record manually and that's the reason why our OM wants to know how many are create on average based on how many starters we get within a month.

 

I have tried to create a report for this on the sc_task table (our new starters are basically created from a generic catalog item in service portal and we work on the RITMs (with the categories Category - Access Management, Subcat - Active Directory, Subcat2. Create account) by creating tasks and marking them as closed.

 

Tried to create a report based on the sc_task table but i'm getting stuck as I don't know how to apply the average conditions based on the categories of the RITM that we are working on.

 

As I mentioned I want the report to show the average of tasks created based on all of the RITM items with the categories above, for each month.

 

Would appreciate your help. Thanks!

0 REPLIES 0