Report based on Incident_metric

[ShobhitA]

Hello Champions, I have created a report in Service Now based on Incident_metrics table.

For one incident, I have multiple records based on  change of the Assignment group.

I want a single record per incident, with a  minimum start ( start is a date column).

Please advise how to fetch records based on the minimum date . I think there must be some java script function through which I can achieve this.

Thanks

Shobhit Agarwal

[Dr Atul G- LNG]

Hi @ShobhitA 

The question is about what time you need it. The metric records are generated based on activity in the incident, so it’s difficult to determine or calculate a specific time. Do you have any screenshots that could help us understand better?

[ShobhitA]

e.g. I have three records for an incident, I want to make a report that returns the record having the minimum start (date column)

Number	Opened	Start
INC001	2025-07-28 09:44:24	2025-07-28 09:47:00
INC001	2025-07-28 09:44:24	2025-07-28 14:41:23
INC001	2025-07-28 09:44:24	2025-07-28 09:47:00

[Dr Atul G- LNG]

Hi @ShobhitA 

You can do this using a pivot table type report. Once you’ve created the metric, use that metric to build a report of type ‘Pivot.’