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

sachin_namjoshi
Kilo Patron
Kilo Patron

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

This link is unfortunately not helpful. There is nothing in that documentation about sorting a group by COUNT.

will_leingang
ServiceNow Employee
ServiceNow Employee

For a full list you can add the following parameter to sort:

&sysparm_group_sort=COUNT

or 

&sysparm_group_sort=COUNTDESC

Can someone tell me how to acchieve this?

Community Alums
Not applicable

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