Split Month Year data in line chart

[muthukumarbalu]

Hi Team ,

I need to show data in month wise order . e.g

Jan-2017 , Feb-2017 ...Dec-2017, Jan-2018,Feb-2018... Dec-2018.

At present my report showing like in below format

Jan-2017, Jan-2018, Feb-2017, Feb-2018,.... Dec-2017,Dec-2018.

PFA and advise.

[sunny_talwar]

You need to sort your month field within your cycle group to fix this... or override the sort order within the chart properties itself... but then it may not work for the other dimensions within the cycle.

[muthukumarbalu]

I have two group, One is based on year and other is Month-Year. I have done sorting in grouping itself , Still it's not working

[sunny_talwar]

Would you be able to share your app for us to check out?

[muthukumarbalu · Accepted solution]

I fixed it by using monthname function. Thanks a lot .