Skip to Content
0

How to sort bar chart based on Month Name (Jan - Dec) ?

Jul 12, 2017 at 04:19 PM

34

avatar image

Dear Experts,

I have designed bar chart and want to display MonthYear wise data in the report.I am Using Month_Year formula where it returns value "201701", but I want to display in "Jan-2017". SoI have created one more formula "MonthName", where it's displaying expected output.

But I had an issue with sorting month name, It brings April month record first instead of Jan. Could you please suggest.

Month_Year : if isnull({incident.opened_at}) then cstr(CurrentDate,"yyyyMM") else cstr({incident.opened_at},"yyyyMM")

Month_Name : if isnull({incident.opened_at}) then ToText(CurrentDate, "MMM")+"-"+{@Year} else ToText({incident.opened_at}, "MMM")+"-"+{@Year}

1.jpg (76.0 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers