Rolling 12 Month Chart - Month Sort Order

[danielle_v]

Hello,

I have a line chart that shows year on year volumes for a rolling 12 month period (based on user date selections) vs. the previous 12 month period. As per the below screenshot, the user has selected Feb-18 for the calendars so the chart is showing Mar-16 to Feb-17 vs. Mar-17-Feb-18. This is working as expected, however I can't get the chart sort order to work correctly. I want the order to be dependant on the users selection, so in the case below I would want the axis to be sorted from Mar -Feb.

I have used the following expression to try and sort the order, but as you can see form the screenshot, this hasn't worked as expected;

=if(Cal_Month = 'Feb', match(Cal_Month, 'Mar', 'Apr', 'May', 'Jun', 'Jul', 'Aug', 'Sep', 'Oct', 'Nov', 'Dec', 'Jan', 'Feb')) etc.....

Is anyone able to point mw in the right drection with this please?

[VishalWaghole]

Could you please try to sort it using date, from which you derived MonthYear.

Regards,
Vishal

[danielle_v]

Hi Vishal,

Thanks for your response

I have tried putting the Cal_MonthYear field into the sort by expression box, but this seems to behave exactly as per the above screenshot. I really don't know what to try now!

[VishalWaghole]

Could you please share some sample data.

[Madhab77]

Hi Danielle,

Thanks for posting query. Similar issue I am facing. Did you get any solution for this. If so, please reply here or can write me to madhab77@gmail.com

Thanks & Regards,

Madhab Sikder.