How can I sort by grouping Count?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-08-2018 09:15 AM
I am trying to sort by the count of incidents that a change is related to. How might I go about this?
- Labels:
-
Reporting
- 21,946 Views

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-08-2018 03:45 PM
You can utilize grouped list feature.
Please check below for more details
https://docs.servicenow.com/bundle/london-platform-user-interface/page/use/using-lists/concept/c_GroupedLists.html
Regards,
Sachin
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-06-2023 04:37 PM - edited 06-07-2023 02:49 PM
This link is unfortunately not helpful. There is nothing in that documentation about sorting a group by COUNT.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-07-2019 10:30 AM
For a full list you can add the following parameter to sort:
&sysparm_group_sort=COUNT
or
&sysparm_group_sort=COUNTDESC
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-23-2020 01:39 AM
Can someone tell me how to acchieve this?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-06-2021 11:06 AM
I did it by finding the GROUPBY parameter in the URL, and then adding the new one. In my company the '&' is translated as %26 and the = %3D so, I just added the new parameter after Groupby
GROUPBYu_incident_type%26sysparm_group_sort%3DCOUNT