Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

'Display data table' checked - is there a way to sort this data?

Eric_Gauthier
Tera Contributor

Created a trend report for one of my users, and checked 'Display data table'.  

The report is by month and shows the number of tickets closed by Assigned to.  Simple. 

Looks like the default for the Data table is to sort alpha by the Assigned to (in this case).  When there are a lot of data items, like there are sometimes, my customer asked if there was a way to sort the data table by the number of items so that they could easily see the largest at a glance and not have to hunt and peck around.  

Example: 

Eric_Gauthier_1-1729292932165.png

They would like to see the one with 143 at the top, then the one with 47, etc. 
I have not been able to find a way to do this, but if any of you have any tricks, please let me know.  You will make my user VERY happy! 
Thank You! 

 

 

Eric Gauthier, CSPO
BECU
ServiceNow Operations Engineer
2 REPLIES 2

Roq
Tera Contributor

Wonder if anyone was able to manage and work this out?

Kri
Kilo Sage

Did you find a solution for this? I have the same issue.