Month sort order when 2 years selected

[Anonymous]

Hi, I would like to plot the visual as per the screen shot below. Can you please let me know what i can do to achieve it.

I tried sort on months which works great for single years. But when 2 years selected it doesn't show the way i would like to see as per pic.

Thank you.

[Anonymous]

Hi @ryan_mayu , Thanks for your help. I was doing the sort order column as mmyyyy and i tried your way by doing yyyymm and it helped it sort in a sequence as i wanted.

Thank you.

[ryan_mayu]

you are welcome

[ryan_mayu]

@Anonymous 

I think you can't only display month, you to display like 2020 Jan, 2020 Feb, etc... then you can sort in order.

[Anonymous]

Hi @ryan_mayu ,

   Yes i am doing that at the moment. Please see below.

And am tring to set an order like an index or something so they can be displayed in an order (calandar month order) one year next to another year. But didn't quite get there. 

Please help.

[ryan_mayu · Accepted solution]

@Anonymous 

the month in your screenshot looks like in the correct order.