Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Yes, You can created MonthNum from Month field and use MonthNul as sort expression with ascending. So that, It will fix the result
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))
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)