Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
maybe by using a dual function so each entry is recognized as a different value
=dual(Left(Month(field),1 ),num(month(field)))
=left(Month(today()),1)
Use:
Left(myDimension,1)
You could try with a left and month combination
Left(Month(field),1 )
Tried that, but the issue comes where you have Jan, Jun, & Jul all get grouped under one "J", same with Aug & Apr
What single letter result are you after for each of the 12 months ?
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
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"
HI Neil,
you'd need to go to for calculated dimension of =Left(Month,3) to get them unique
HTH
Andy
maybe by using a dual function so each entry is recognized as a different value
=dual(Left(Month(field),1 ),num(month(field)))