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,959 Views

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-08-2018 03:44 PM
No way to do that with the standard reporting lists. You can do this with a bar chart though. Then you can show the related data in a table at the bottom.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-06-2023 04:45 PM
I've tried every bar chart offered in Reports, but none of them simply show anything by Count in a way that can be easily seen and drilled into. Do you have an example of this or more details you can share on how to accomplish it?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-06-2023 10:06 PM
Mate, chill. If you google this topic, you will find this KB article as the first option. If you are in Tokyo version or higher, you don't need to do the URL manipulation anymore.
https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0999606
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-07-2023 02:47 PM - edited 06-07-2023 02:49 PM
Mate, I'm totally chill.
Of course I googled it, yes. The returned results did not give me the KB you shared. Perhaps you're not aware of this, but Google uses all kinds of algorithms and filters to determine search results, and they can vary extensively from person to person. My results returned all kinds of unhelpful links, but not that KB article. It did however bring me here.
You answered my question indirectly, so thank you. URL manipulation hadn't occurred to me prior to your reply so that's really helpful. However, the new method you mentioned for Tokyo is not available in my instance. Makes me wonder if there's a plug-in that needs to be activated. I've always found the grouped "Count" issue to be extremely short-sighted on ServiceNow's part.