How can I group by "Assignment Group" but sort by "Count" on a Trend report?

[bostonsnow]

Hello,

I created a report with the following criteria (see screenshot). Is there a way to sort the results by Count so I can either show the highest number first while retaining the Group By on Assignment Group? Currently the results are grouped by Assignment Group which I need but I can't figure out to sort the results by Count.

My results currently look like this...

Assignment Group             Task Count

Assignment Group 1              54

Assignment Group 2             199

Assignment Group 3             170

Assignment Group 4             201

But I need this...

Assignment Group             Task Count

Assignment Group 4             201

Assignment Group 2             199

Assignment Group 3             170

Assignment Group 1              54

 

 Thanks!

Mike

[Allen Andreas]

Ah, ok. Understood.

It appears that the basic reporting system doesn't allow for this and you'd have to go with Performance Analytics, instead.

[bostonsnow]

**Updated my original post due to a typo that added confusion to what I am trying to achieve. Should be clear now.

[Community Alums]

Not sure how you'll be able to leverage this but thought it would be relevant to your use case.

https://community.servicenow.com/community?id=community_question&sys_id=e9a5e595dbc5a7c0fece0b55ca96...

Also, there's the function field type that you could eventually use for your reporting.

https://docs.servicenow.com/bundle/quebec-platform-administration/page/build/platform-functions/conc...

You could add some logic with GlideAggregate to order by group count and set a Order function field, for example. 

https://developer.servicenow.com/dev.do#!/reference/api/quebec/server/no-namespace/c_GlideAggregateS...

[Mads Jensen]

Hi'
'Active' does not work.

Did you ever find a solution?
This is also driving me nuts.

[mullenr]

I need the same.  But have not found a way to do it.  All Assignment Groups in my widgets and list come up alphabetically and I need them displayed top-down by the number of incidents or requests that are in that assignment group.  I may have over 100+ assignment groups and I really want to see on my dashboards the ones that are highest count at the top vs. being mixed in down the list alphabetically.  I can get this by list by adding to the URL  " &sysparm_group_sort=COUNTDESC "  but I want to set that parameter as the default for the entire dashboard and all widgets/reports/list views.