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.

How can I see month name in place of month number in Analytics Column chart?

Rookie Asked on August 3, 2021 in Workbooks.
Add Comment
1 Answer(s)

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:

RE: How can I see month name in place of month number in Analytics Column chart?

In the dataset, I added a formula field to convert the date to a string:

RE: How can I see month name in place of month number in Analytics Column chart?

(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:

RE: How can I see month name in place of month number in Analytics Column chart?

Intermediate Answered on August 3, 2021.

 

That worked for me, Thanks!

on August 3, 2021.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.
  • This site made possible by our sponsors:   Tipalti   Celigo   Limebox   Become a Sponsor