I'm trying to set up some vertical lines as references on my graph. I found this solution on the forum.
I did a variation to get that reference line on a daily basis.
IF(DATETIME_TRUNC(date, Day) = DATETIME_TRUNC(DATE '2022-06-15', Day), 250000, NULL)
The issue is that the reference line looks super thin on my graph. I would like to do a condition to TRUNC several consecutive days to have a thicker line.
Specific questions:
Is it possible to Trunc several consecutive with the DATETIME_TRUNC function?
Is there a simpler solution to set up vertical reference lines in my graph?