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

[nwilliams]

in my load script for my calendar, I have put the following:

Left(Month(c_Date),1) AS Calendar.MonthInital,

When I use "Calendar.MonthInital" as a dimension, in Stead of 13 months I get 8, in a random order.  Currently "N,D,J,O,S,A,M,F"

My suspicion is as "J" is not unique, it puts all of Jan, Jun & Jul under "J"

[antoniotiman]

I think Ramon answer is correct.

However You can' change dimension and chek

But You have   J...F..M. and so on.

Regards,

Antonio

[nwilliams]

This has done it, but to get this work over 2 years instead on using month number as the second part, I changed it to Month Name

Dual(Left(Month(c_Date),1 ),MonthName(c_Date)) 

Thanks!!!!! ::)