Create a dynamic date range with a beast mode

Hi,

 

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?

Comments

  • GrantSmith
    GrantSmith Indiana 🟤

    Hi @user084060 

     

    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.

Sign In or Register to comment.

Hey, Stranger!

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!