Show records grouped by location where location is more than 1
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-16-2025 09:17 AM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-16-2025 10:11 AM
Pareto chart may help in giving a relevant requirement if ServiceNow really has no way to filter out lesser counts. But it's really not what we want right now since we are dealing with huge records.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-16-2025 09:49 AM
A simple report on the incident table, with 'Group by' "Location"
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-16-2025 10:05 AM
You skipped the part where incidents need to be grouped and exclude locations with only one record.