Sort S M L XL tee-shirt sizes correctly

[robdhondt]

Hi @GeorgeReimonn -

You can use a calculated field and custom sort. Look at this answer to get an idea.

Sorting X Axis by Day of Week

Hi @Tanisha_Shetty - If you have the actual dates you can do this. Create a calculated field for the sorting. c_week_day extract('WD',dt) Go to “sort options” in your x-axis dimension and sort by c_week_day (max/min) ascending. [image] If for some reason you don’t have actual dates but strings with the day of the week. You can do something like this but in reverse, then use the calculated field with step 2. ifelse( extract('WD',dt)=1,'Sunday', extract('WD',dt)=2,'Monday', extract(…

c_custom_sort

ifelse(
size='S',1,
size='M',2,
size='L',3,
size='XL',4,
0)

or

switch(size, 'S', 1, 'M', 2, 'L', 3, 'XL', 4, 0)