Getting x axis sorted correctly

ColinHaze

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.

GrantSmith

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.

GrantSmith

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.

ColinHaze

Thank you, woulda never thought of that!