How to report average age (in days) of open RITMs for a catalog item

[dd31]

Hi team,

I’m trying to create a report (without using Performance Analytics) to find the average age (in days) of open RITMs for a specific catalog item.

My requirement:

• Filter on specific catalog item

• Consider only open / active RITMs

• Show average age in days

FR

Looking for recommendations or examples on how others have achieved this without PA.

Thanks!

[Dr Atul G- LNG]

Hi @dd31 

I doubt this can be done. Did you check if there is any OOTB (out-of-the-box) report available for the same?

Check this OOTB

https://INSTACNCENAME.service-now.com/now/platform-analytics-workspace/visualization-designer/26e30d...

[dd31]

I did, its not available

[Dr Atul G- LNG]

Did you check above link, might be get some idea. else not possible.