How can I sort by grouping Count?

[Stephen11]

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

[MH_Vent]

But where do you put this parameter? Where does it go? Without knowing that, the information isn't useful.

[Adam43]

i'm trying to add the parameter piece to sort by group count into a URL that contains other filtering criteria.  I got it to work on the full table, but would really prefer to have this narrowed down by my additional criteria and can't get it to work- any help?

here's my starting point:

service-now.com/nav_to.do?uri=%2Fsys_user_list.do%3Fsysparm_query%3Du_ems11_employee_numberISEMPTY%255Elocation.name%253Dnull%255Estreet!%253Dnull%255Ecity!%253Dnull%255EGROUPBYstreet%26sysparm_first_row%3D1%26sysparm_view%3D

[Henri1]

The end of your URL should be like this:

GROUPBYstreet&sysparm_first_row=1&sysparm_group_sort=COUNTDESC

[Adam43]

sweet- figured it out- thanks-

service-now.com/nav_to.do?uri=%2Fsys_user_list.do%3Fsysparm_query%3Du_ems11_employee_numberISEMPTY%255Elocation.name%253Dnull%255Estreet!%253Dnull%255Ecity!%253Dnull%255EGROUPBYstreet%26sysparm_first_row%3D1%26sysparm_group_sort%3DCOUNTDESC

[Henri1]

Great, happy I was able to help you.