Cross Table Horizontal Axis column order

[Thomas Love]

I have a cross table with a horizontal axis for weeks. The weeks go over week 9 so the order in the visualization is wrong. See below: Week 1 Week 10 Week 11 Week 12 Week 13 Week 14 Week 2 Week 3 Week 4 Week 5 Week 6 Week 7 Week 8 Week 9 I want it to be in order Week 1 Week 2 Week 3 Week 4 Week 5 Week 6 Week 7 Week 8 Week 9 Week 10 Week 11 Week 12 Week 13 Week 14 I wrote a case statement that delivers "Week 1" etc... I understand the logic that it is doing by putting everything that starts with a 1 first, but I do not know how to fix it. Do I use a Rank function or is there a better way to get the weeks I do not want they system generated 43, when that may be my Week 1. I hope this makes sense. Thank you in advance for any help.

[Gaia Paolini]

Hi

Numbers within strings are sorted like strings so e.g. 10 < 2.

Try using this custom expression instead of on the cross table axis:

 

This will extract the number from the 'Week nnn' value and cast it into an integer, which then sorts naturally in the right order.

Gaia

[Thomas Love]

Thank you.