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 - LNG]

Hi @dd31 

https://www.servicenow.com/community/platform-analytics-forum/creating-an-aging-report-in-snow/m-p/1...

https://www.servicenow.com/community/platform-analytics-forum/how-to-create-a-report-showing-average...

Example:

[dd31]

Hi @Dr Atul - LNG 

Thanks for the references.
My requirement is at the RITM level, with the output as a single score report.

[Dr Atul - LNG]

The issue is that the single score shows only one value, and in the RITM, we do not have a field called “Open as selectable”. This is a limitation in the current setup.

For incidents, it works fine. For RITMs, we can either reuse the Business Duration field in RITM and then use it accordingly.

[dd31]

Yes, that’s exactly why I raised this concern.
Is there any way to use a configured function field?
I’m unsure how to pass today’s date as one of the parameters — gs.nowDateTime() doesn’t seem to work in this context.
Any ideas on how to handle this?