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?
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!
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 firstname.lastname@example.org
Thanks & Regards,