Getting x axis sorted correctly

ColinHaze · 2024-01-09T15:07:47+00:00

There was an error rendering this rich post.

Hi,

Any idea on how to fix this so that its in the correct order? The last two columns just need to switch. Its sorted by year and week right now.

Find more posts tagged with

I'd recommend calcluating the first date of the week and use that for your sorting. If you have a Date field you can do something like this:

`Date` - INTERVAL (DAYOFWEEK(`Date`)-1) DAY

This will return the Sunday of the week.

I'd recommend calcluating the first date of the week and use that for your sorting. If you have a Date field you can do something like this:

`Date` - INTERVAL (DAYOFWEEK(`Date`)-1) DAY

This will return the Sunday of the week.

Thank you, woulda never thought of that!