Single Letter Month

[nwilliams]

Hi,

I'm creating a line graph to show trend, and the full axis labels are not important, so have removed them.  What I am after is to get a sense of the time on the dimension axis, so want to put the month in there.  The dimension I'm sowing at the moment would display "Jan 2015", but what I'm after is just "J", "F", "M" etc.  I tried using "Date(field, 'M') in the load script, but the created "1", "2", "3" etc

Any ideas how I get just "J" for January?

Thanks

[Anonymous]

=left(Month(today()),1)

[alexandros17]

Use:

Left(myDimension,1)

[ramoncova06]

You could try with a left and month combination

Left(Month(field),1 )

[nwilliams]

Tried that, but the issue comes where you have Jan, Jun, & Jul all get grouped under one "J", same with Aug & Apr

[Anonymous]

What single letter result are you after for each of the 12 months ?

[nwilliams]

Jan = J

Feb = F

Mar = M

Apr = A

May = M

Jun = J

Jul = J

A = A

Sep = S

Oct = O

Nov = N

Dec = D

So when you look at a 13 month rolling chart, you would see:

M J J A S O N D J F M A M

[Anonymous]

I am confused now as you said this was no good :

"Tried that, but the issue comes where you have Jan, Jun, & Jul all get grouped under one "J", same with Aug & Apr"

[awhitfield]

HI Neil,

you'd need to go to for calculated dimension of =Left(Month,3) to get them unique

HTH

Andy

[ramoncova06 · Accepted solution]

maybe by using a dual function so each entry is recognized as a different value

=dual(Left(Month(field),1 ),num(month(field)))