Sorting Values in Grouped Value Category Selector

569
1
01-19-2021 11:26 AM
by Anonymous User
Not applicable

Hello,

I have a dashboard which uses a grouped value category selector. When using a group value, it appears that the dashboard will only let me sort the category list by the category field.

For example, my "category field" in the selector is a list of numeric public bus routes. The sorting lists the 100 routes (101, 102, 103, etc.) before the 20's (21, 22, 23, etc.). I have an additional field which orders the routes that I would like to sort by, however the dashboard will not allow me to.

Any ideas or workarounds? Thanks!

0 Kudos
1 Reply
DavidPike
MVP Frequent Contributor

It seems like he bus route is text rather than a number.  From memory, the only sorting is the default asc and desc.  Could you perhaps create another custom attribute where you cast the string into a number, e.g. int(!myfield!) ? I'm guessing you actually have 101A, 101B 20A etc? which would preclude that.

Please don't take this as an indication that it's not possible, I'm no dashboard expert, just throwing in a  suggestion.

0 Kudos