I have a Date Range in my Looker Studio visualization, and from a google sheet I have Start and End dates of projects.
I would like to do a calculated field which shows that the current date range set a project is inside (started in the date range or ended or fully inside) or outside of the range, or just the start date is before the date range and still not finished (it's still ongoin at the selected date range).
The calculated field I alreaddy tried looks like this but always had an error:
CASE
WHEN Project start date<=@ds_END_DATE AND (Project end date IS NULL OR Project end date>=@DS_START_DATE) THEN 1
ELSE 0
END
How can this problem be solved? Anywhere I looked I didn't find the good date range identifiers.
LinkedIn
Twitter
