Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello
I have 2 questions which I am trying to resolve without success. I would appreciate help
1. I would like to view my data week by week for which I am using "week" or "WeekYear" but how can I display a "dd/mmm" for each column instead of week number "24" for example?
2. I need a vertical Reference line on week 24 (10th June 2020 to be specific)
Please help
Got the answer for my 1st question 🙂
date(WeekStart(TempDate),'DD-MMM') as WeeklyDate
but I still can't figure out how to get the Vertical line at the 10/June week.
Best I have is the following Help link:
Not sure it is going to do what you want, the only other thing of which I can think would be to overlay a line on top of the chart object marking things, but I do not know if that will work for you or not.
Regards,
Brett