I want to create a dynamic date range to capture the following period: 100 days ago excluding the last 4 weeks (28 days). The date I want to use is signup_date.
Is this possible with a beast mode?
You could use a beast mode to create a new column to filter on using a CASE statement.
CASE WHEN `signup_date` >= CURRENT_DATE - INTERVAL '100' DAY AND `signup_date` < CURRENT_DATE - INTERVAL '28' DAY THEN 'Yes' ELSE 'No' END
Then just filter for 'Yes' and it should only show you your related rows.
It looks like you're new here. Those who sign in get access to engage with even MORE fire content. To get involved, click one of these buttons!