Forum Discussion
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...
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
MFelix
Super User
Super UserHI 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