- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-17-2025 12:47 PM
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.
Kaushal Kumar Jha - ServiceNow Technical Consultant/Developer