Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

How to sort categorical(text) column ?

Hi all, 

 

I need some help with sorting the categorical(text) column.  is there any way to sort the value in one column in order?

 

Less than 5,

6 - 10,

11 - 20

...

over 500

 

I have tried switch(true() ....) to make a new column and sort by the new column, it's not working.

 

Many thanks!!

Need Help
  • MFelix's avatar
    MFelix
    7 years ago

    HI Anonymous ,

     

    I'm assuming that the groups you have here represent a column on your data, correct?

     

    Create a table with the following data:

     

    Category Sort
    Less than 5 1
    6-10 2
    11-20 3
    21-50 4
    51-100 5
    101-500 6
    Over 500 7

     

    Use the sort column to sort the category and relate this table with the column on your data table.

     

    Then just use this table on your graph.

     

    Regards,

    MFelix

1 Reply

  • MFelix's avatar
    MFelix
    Icon for Super User rankSuper User
    7 years ago

    HI Anonymous ,

     

    I'm assuming that the groups you have here represent a column on your data, correct?

     

    Create a table with the following data:

     

    Category Sort
    Less than 5 1
    6-10 2
    11-20 3
    21-50 4
    51-100 5
    101-500 6
    Over 500 7

     

    Use the sort column to sort the category and relate this table with the column on your data table.

     

    Then just use this table on your graph.

     

    Regards,

    MFelix