Discussions
-
Test to see if a specific date falls between two other dates
Hi all, I am having trouble getting this beast mode to work. CASE WHEN 05-30-2022 >= start_date AND 05-30-2022 <= `end_date` THEN 1 ELSE 0 END or something like this CASE WHEN str_to_date('30-MAY-22','%d-%b-%y') >= start_date AND str_to_date('30-MAY-22','%d-%b-%y') <= `end_date` THEN 1 ELSE 0 END Both start_date and…
-
Default Date Filter on an Embedded Dashboard
(NOT USING DATA RANGE) I am wanting to filter data by Week ( 1, 2, 3, 4, 5, 6, etc..), but I am having trouble finding a solution that will allow me to 1. have a default filter that will open up the dashboard to the current week and then 2. being able to filter by other weeks. Here's what I have tried: Using the Beast mode…
