Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Can we Control the order of Grouping Categories?


Level 3
I'd like to place my "At Risk" items at the top of the list, and the "on target" at the bottom. Is this done with Text mode? Any help would be appreciated. Thanks, Dave Dave Rulon Great Dane Savannah, GA 912-644-2452

Topics help categorize Community content and increase your ability to discover relevant content.

3 Replies


Level 3
Screenshot showing that we cannot sort grouping, but offers an alternative: Dave Rulon Great Dane Savannah, GA 912-644-2452


Level 3
Now that I can sort the groupings using a column, I want to hide the column. Hide a column in a view. You can build a column in a view, for purposes of sorting the view by a certain field, for example, but you can use text mode to hide it from displaying in the view. For example, to hide the Task Number column in a task report, replace the text in the Task Number column with the following: displayname= linkedname=direct querysort=taskNumber sortOrder=1 sortType=asc textmode=true value= valueformat=int width=0 The important changes in this code which make the column hidden are: - displayname must be blank; - valuefield has been replaced by value , and must be blank; - width=0 Dave Rulon Great Dane Savannah, GA 912-644-2452


Level 10
Well spotted Dave, Another relatively common technique to help with report sorting (and group sorting) is to use a calculated parameter to "decode" the status and prefix it with a numeric (similar to the picture on my "">One Chart To Rule Them All blog post), such as IF(Condition = "At Risk","01 At Risk",...) Regards, Doug Doug Den Hoed - AtAppStore Got Skills? Lend a hand!