Formatting month_name from Time Dimension Group

[ginandtobby]

Hi Community!

I'm using month_name defined below as my line chart x-axis dimension.

The x-axis display looks like this:

Now, instead of having full month name like 'January', I only want the first 3 letters of month name like 'Jan'.

I tried this but it does not work:

Please advise how I can achieve the display I wanted. I must use 'month_name' as I'm using year as the pivot column to get year-on-year comparison. So, I cannot use 'month' instead of 'month_name' and format it to %b.

Thanks!

[ginandtobby · Accepted solution]

Nvm found a workaround