Date as dimension but showing only month in chart

[linusblomberg]

Is it possible to have a linechart with date as a hidden dimension but displaying month as kind of a reference to what dates are displayed?

I'll try to visualize what I'm trying to accomplish

In this example I have selected Jan, Feb, Mar and Apr. The reference can be either on the first or 15 doesn't really matter.

Any help is appreciated

Thank you

[sebastianlettner]

HI,

if you use a master calendar add an additional field  (e.g. dspMonth)

Cal:
LOAD
     Date,
     Dual(If(Day(Date) = 1, MonthName(Date), ''), Date) as dspMonth // Reference on 1st day
...

and use dspMonth as Dimension.

If you need the reference on the 15th day use

If(Day(Date) = 15, ...

or

If(Day(Date) = 1 or Day(Date) = 15, ...

if you want two references.

Regards

Sebastian Lettner

[linusblomberg]

Interesting approach. I will try it.

I tried adding an extra expression with "text on axis"

if(right(%Date,2)=15,MonthShort,null())

This works just as I want it but the text is Strike through and I can't manage to remove it?

I'll give your example a try.

[Anonymous]

Sebastian, 

That is nice.  I have done similar before in the front end, but your way in the load script is much easier.