Hi Ravi if you write Date(date,'MMM-YYYY') , if the field date is in time format then you'll face the problem in frontend , it will give repeated values in list box
to avoid that use the floor function before as follows
For a vertical reference line, you need to enable continuous mode for the x-axis (Properties | Axes).
for vertical reference lines you need a continous x axis. So you better should use dates instead of month. Please look at this training video for explanation:
Hope this helps
Plz check the attached file. You need to add reference line for each dimensions value. It is not full solution, I'm giving just idea.
Hope you will get better solution from others.
a very simple solution to your problem could be to ad a second expression event with vertical labels. This would look like below:
This is the easy way...
Thanks for your response but here the month no dimension is showing some invalid values??
may i know why it is showing like that?? (we have monthno as only 1,2 )
this is only cause your date format in the expression for the reference line was slightly incorrect. You have to use
Date#('01-06-2014', 'DD-MM-YYYY') then everything looks fine: