Forum Discussion

BJE's avatar
BJE
Helper I
6 years ago
Solved

Sorting a visual using text-based ranges

I have a table that I has a column recording the FTE for each company in the list. I have created an additional column that has created FTE ranges, i.e.: 0-4 5-9 10-24 25-49 50-99 100-149 150-...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    or better could use " " (2 blanks or 1 blank depending the number of digits) instead "0"

     

Greg_Deckler's avatar
Greg_Deckler
Community Champion
6 years ago

BJE - Use a separate colum with numeric sort values. Use the Sort By feature to sort your text column by your numeric column.

BJE's avatar
BJE
Helper I
6 years ago

Thanks. Have tried that - not changing my visual.

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    if it is not acceptable for aesthetic reasons, try somethonk like this

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      or better could use " " (2 blanks or 1 blank depending the number of digits) instead "0"

       

      • BJE's avatar
        BJE
        Helper I
        6 years ago

        Thanks - this worked for me