topic Re: Split Month Year data in line chart in App Development

Split Month Year data in line chart

muthukumarbalu — Thu, 06 Dec 2018 12:48:16 GMT

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.

Re: Split Month Year data in line chart

sunny_talwar — Thu, 06 Dec 2018 12:55:23 GMT

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.

Re: Split Month Year data in line chart

muthukumarbalu — Thu, 06 Dec 2018 13:31:53 GMT

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

Re: Split Month Year data in line chart

sunny_talwar — Thu, 06 Dec 2018 13:33:43 GMT

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

Re: Split Month Year data in line chart

muthukumarbalu — Thu, 06 Dec 2018 15:10:26 GMT

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