Sorting in Line Chart

[hopkinsc]

Hi All,

i am trying to get a line chart sorted as per the following..

i have week number on my x axis which is currently sorted numerically (1-52) but what i want is to sort it based on the last date that data was received.

The last date is 09/10/2017 which is week 41, so i want the chart to start at week 42 and end at 41.

can anyone help please?

i have attached an example.

Thanks

[stigchel]

Try with

max({<raw_sales_volume={'>0'}>}nd_CALENDAR_YYYYMMDD)

[hopkinsc]

thats great, thanks so much for your help!