How can I see month name in place of month number in Analytics Column chart?
I created a chart in NetSuite Suite Analytics workbook where I am showing salesrep sales monthly basis.
Now in column chart it is showing 1,2,3,4,5,6 in place of Jan,Feb,Mar,Apr,May
Please help.
I don’t think there’s a way to do this without having some sort of number otherwise the sort order is completely thrown out.
I did manage to get this which I don’t think looks too bad:
In the dataset, I added a formula field to convert the date to a string:
(You can see other formatting options here: https://docs.oracle.com/cd/B19306_01/server.102/b14200/sql_elements004.htm)
And then added this to the chart like this:
That worked for me, Thanks!
