kaushal_snow
Giga Sage

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.

 

Thanks and Regards,
Kaushal Kumar Jha - ServiceNow Technical Consultant/Developer

View solution in original post