The CreatorCon Call for Content is officially open! Get started here.

Show records grouped by location where location is more than 1

chanp
Tera Contributor

This is similar to this thread Show group by records with more than 1 record - ServiceNow Community.

 

I am struggling to find a resource of documentation that will guide me to create an incident report that is grouped by location and only show records with multiple occurrences on the last 30 days.

 

This is to identify locations with multiple incidents on the last 30 days.

 

Will appreciate any assistance.

6 REPLIES 6

Bert_c1
Kilo Patron

A simple report on the incident table, with 'Group by' "Location" 

 

Screenshot 2025-10-16 124844.png

chanp
Tera Contributor

You skipped the part where incidents need to be grouped and exclude locations with only one record.