Truncate Several Dates with DATETIME_TRUNC function - Vertical Reference Line

Viewed 22

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?

Thin Vertical Reference Line

0 Answers
Related