Create a dynamic date range with a beast mode
user084060
⚪️
in Dataflows
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?
Tagged:
0
Comments
-
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 Agree or Like below**
**Did this solve your problem? Accept it as a solution!**1
Categories
- 11K All Categories
- 5 Private Company Board
- 2 APAC User Group
- 12 Welcome
- 43 Domo News
- 9.9K Using Domo
- 2K Dataflows
- 2.5K Card Building
- 2.2K Ideas Exchange
- 1.2K Connectors
- 349 Workbench
- 267 Domo Best Practices
- 12 Domo Certification
- 474 Domo Developer
- 51 Domo Everywhere
- 111 Apps
- 728 New to Domo
- 85 Dojo
- Domopalooza
- 1.1K 日本支部
- 4 道場-日本支部へようこそ
- 31 お知らせ
- 65 Kowaza
- 303 仲間に相談
- 664 ひらめき共有