What is the best method of reporting MoM / YoY results for custom business application fields?

[Karen_K]

My team has a number of metrics based on custom business application fields that we report on monthly using Tableau because of calculations required to arrive at those metrics. Now we are being asked to also look at those metrics MoM and YoY. We require assistance identifying: 

• The most effective method of building complex calculations on a daily, monthly basis. 
• What tables would be used to collect snapshots of data for MoM / YoY reports. 
• The most effective method to produce MoM / YoY reports. 

My search of the SNOW knowledge base has not provided beneficial documentation. Any knowledge links applicable to this ask would be appreciated. 

[kaushal_snow]

Hi @Karen_K ,

Use ServiceNow’s Metric Definitions / metric_instance tables to capture durations or state changes, combined with a daily snapshot custom table for custom field values, then set up Performance Analytics indicators (with automated indicator sources and data collection jobs) to store snapshots at fixed periods, and build Tableau dashboards that pull both snapshot and metrics, define MoM / YoY calculated fields (e.g. current vs prior month, same month last year), include date dimension hierarchies, and ensure backfill or audit data where needed for historical coverage...

If you found my response helpful, please mark it as ‘Accept as Solution’ and ‘Helpful’. This helps other community members find the right answer more easily and supports the community.