Quick Filter Number Formatting

user091935
user091935 Member
in Charting

I'm trying to remove the commas from numbers that are 1000+ in my quick filter. I can't for the life of me figure out how!

Comments

  • trafalger
    trafalger Coach

    Not sure if it's best practice, but Domo is adding the commas since it's formatted as a number. Quick way to fix this is to make a beast mode that is Concat(`numberfield`) and then Domo will view it as Text. 

     

    Sometimes I've had to do Concat(`numberfield`, '') and add a space too. 

  • GrantSmith
    GrantSmith Coach

    One thing to look out for though is that converting the number to a text field will cause Domo to sort it based on the textual representation and not the numeric number within the field.

     

    For Example (text sorting):
    1

    10

    2

    3

    ...

    9

     

    The way to get around the textual sorting issue would be to left pad your numbers with 0s which just causes another display issue of having leading 0s.

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**
This discussion has been closed.

Categories