How can I sort by grouping Count?

Stephen11
Mega Contributor

I am trying to sort by the count of incidents that a change is related to.  How might I go about this?

 

 

find_real_file.png

23 REPLIES 23

Mark Stanger
Giga Sage

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.

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?

 

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

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.