Skip to Content
avatar image
Former Member

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

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)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers