Forum Discussion

HeatherBryant2's avatar
HeatherBryant2
Qrew Assistant Captain
9 years ago

Set Order for Summary Crosstabs & Chart Legends

Hello, I'm working with a text formula in my app that looks at a numeric field's value and formulates whether the score for a record is High, Medium or Low.  The formula is working fine, with the ...
_anomDiebolt_'s avatar
_anomDiebolt_
Qrew Elite
9 years ago
You might try using an HTML field or a text formula that contains leading spaces to force the apparent sort order you want.

​ ​ ​ High

​ ​ Medium

​ Low

where ​ is the numeric character entity for a unicode zero width space.
  • _anomDiebolt_'s avatar
    _anomDiebolt_
    Qrew Elite
    9 years ago
    The Mongolian Vowel Separator  looks promising: ᠎

    As does the Invisible Separator: ⁣

    Also, the Zero-Width Joiner works: ‍

    Lots of possibilities to try!
  • _anomDiebolt_'s avatar
    _anomDiebolt_
    Qrew Elite
    9 years ago
    My favorite is the Function Application character: ⁡