Rolling Calendar Month Expression

[JustTryingToLearn]

Hi,

I would like to make a rolling bar chart that has 12 months as the bottom axis. I plan to use 3 letter month names. I would like to do this using a chart expression of some kind. Is there any way to set up the sort so that this is possible?

Thank you!

[Anil_Babu_Samineni]

Yes, You can created MonthNum from Month field and use MonthNul as sort expression with ascending. So that, It will fix the result

[manoranjan_d]

 I plan to use 3 letter month names. I would like to do this using a chart expression of some kind.

>>you can use monthname function to get the three letter

monthname(your month field)

Is there any way to set up the sort so that this is possible?

>>In sorting you can try min({1}monthname(your month field))

[manoranjan_d]

Tried with sample data below is the script 

LOAD Date,
Sales,
date(MonthName(Date),'MMM') as monthname
FROM
[C:\Users\NM\Desktop\Scenarios\17 feb21\New Microsoft Excel Worksheet.xlsx]
(ooxml, embedded labels, table is Sheet2);

dim monthname

exp RangeSum(Above(Sales,0,12))

sort min({1}monthname)