Ordering Months Sequence in Chart View

[TPS]

Hello,

Can someone help me to order the sequence of the months from Jan to Dec instead of the alphabetic order that I have it currently in my application as per the attached picture.

I used the formula INDEX( LIST("Jan", "Feb", "Mar", "Apr", "May", "Jun", "Jul", "Aug", "Sep", "Oct", "Nov", "Dec"), Month([Date])) to change the month from numbers (i.e 1)to text (i.e Jan).

Thank you.

[Suvrutt_Gurjar]

AppSheet sorts alphabetically. You could try attaching some prefix such as M1-Jan , M2-Feb, M3-Mar..... to sort them in the calendar order. If your charts overlap calendar years too, then you will need to introduce year element as well, such as    21-M12-Dec , 22M1-Jan etc.