Create a dynamic date range with a beast mode

Reply
Highlighted
Yellow Belt

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?

Major Red Belt

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.



**Was this post helpful? Click the heart icon**

**Did this solve your problem? Accept it as a solution!**
Announcements
Domopalooza 2021 Call for Presenters: We want to hear how Domo is revolutionizing the way you do business!

Click here to submit your story.