Change order of expresion

[peterderrington]

Hi,

An easy question i'm sure......

I have a couple of (line) charts that have either the day of the week or the month as the second expression but they're showing in the wrong order (ie not chronologically).

I know that i have to add something into the expression box in the sort page but i'm not sure what.

Any ideas?

Thanks

[sunny_talwar · Accepted solution]

May be use a sort expression for your Day field:

Match(Day, 'Monday', 'Tuesday', 'Wednesday', 'Thursday', 'Friday', 'Saturday', 'Sunday')

[peterderrington]

Thank you so much,

i knew it had to be fairly simple.

And using your logic i used

Match(Month, 'January', 'February', 'March', 'April', 'May', 'June', 'July', 'August', 'September', 'October', 'November', 'December')

and that organised my monthly ones too!

Thanks.

[sunny_talwar]

Month can be simplified using this as the sort expression:

Month(Date#(Month, 'MMMM'))

Just need to make sure that you have this in your environmental variables:

SET LongMonthNames='January;February;March;April;May;June;July;August;September;October;November;December';