Reporting on incident_metric table for to ONLY display the priorty change of incidentsIssue Sometimes you might want to keep track of when and how many times the priority has been changed on a ticket. For this one of the solutions is to use metrics. You can create a metric definition on the incident table for the "priority" field. Once the metric definition is created, metric instances would be created for the metric definition. Whenever there is a priority change a new record would be created in the metric_instance table. As per the metric definition functionality, a record will be created in metric_instance with the priority of the incident with which it has been created and the calculation complete will be false. When you try to create a report on incident_metric or metric_instance table and run the report, it would display incidents for which there is no priority change as well. There is no condition with which you can exclude those records. This article will provide you a script include to achieve the requirement. You can call the script include from the report.ReleaseAll ReleasesResolution1. Create a script include: 2. Use the script include in the report. The below report is created on the incident_metric table: Now, the report will exclude the metric instances for the incidents with no priority change. Group By Incident Number and you can notice that there are no incidents in the report for which there is only 1 metric instance. Please note that the definition condition is also added in the report. This works for any type of metric definition.Related LinksMetrics in ServiceNow Test the report in your recently cloned sub production instance before you apply the change in PROD directly. If you have any further requirements, please do not reach ServiceNow for assistance, check with your developer for any changes.