Line chart dimension name of month

[Anonymous]

Hi all,

Just a minor issue that i can't seem to solve.

I have a line chart with its x-axis with dates displayed according to the month name.

I am using a drill-down chart, hence the following equations for the drill-down dimension are as follows:

=Year(Date(Date#(MYDATE,'DDMMYYYY')))

=Month(Date(Date#(MYDATE,'DDMMYYYY')))

=Date(Date#(MYDATE,'DDMMYYYY'))

Whenever i click the year to see the months, i will have August displayed as "Augk" instead of "Aug".

Any help is appreciated.

Thanks and regards,

Gaston

[anushree1]

Can you check if the month is present as augk in the data itself by adding it into list box.

if not, please share the sample app

[Anonymous · Accepted solution]

My apologies,

I have realised that there was an accidental typo in the data load editor where the month name is loaded as Augk.

Thanks!