How to sort categorical(text) column ?

[Anonymous]

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!!

[MFelix · Accepted solution]

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