How can I create a custom moving date range
I need to create a custom date range that moves with the current day. It needs to show the date range of the previous 10 days and the next 5 days based on current day. I can't seem to wrap my head around how to get started on it and if it can even be done in beast mode.
Best Answer
-
So let's say the date column of your date is just called `Date`.
In that scenario you can build a beast mode that says:
CASE WHEN `Date` >= DATE_SUB(CURRENT_DATE(), INTERVAL 10 DAY)
AND `Date` <= DATE_ADD(CURRENT_DATE(), INTERVAL 5 DAY)
THEN 'Include'
ELSE 'Exclude'
ENDThen add that to your filters section of your card and set it to Include. That should give you only dates within the range you mentioned.
Best of luck,
Valiant0
Answers
-
So let's say the date column of your date is just called `Date`.
In that scenario you can build a beast mode that says:
CASE WHEN `Date` >= DATE_SUB(CURRENT_DATE(), INTERVAL 10 DAY)
AND `Date` <= DATE_ADD(CURRENT_DATE(), INTERVAL 5 DAY)
THEN 'Include'
ELSE 'Exclude'
ENDThen add that to your filters section of your card and set it to Include. That should give you only dates within the range you mentioned.
Best of luck,
Valiant0
Categories
- All Categories
- 1.4K Product Ideas
- 1.4K Ideas Exchange
- 1.4K Connect
- 1.2K Connectors
- 284 Workbench
- 4 Cloud Amplifier
- 4 Federated
- 2.9K Transform
- 89 SQL DataFlows
- 556 Datasets
- 2.2K Magic ETL
- 3.3K Visualize
- 2.3K Charting
- 569 Beast Mode
- 11 App Studio
- 27 Variables
- 578 Automate
- 140 Apps
- 414 APIs & Domo Developer
- 23 Workflows
- 1 DomoAI
- 28 Predict
- 12 Jupyter Workspaces
- 16 R & Python Tiles
- 350 Distribute
- 90 Domo Everywhere
- 258 Scheduled Reports
- 2 Software Integrations
- 92 Manage
- 89 Governance & Security
- 9 Product Release Questions
- Community Forums
- 42 Getting Started
- 28 Community Member Introductions
- 85 Community Announcements
- 4.8K Archive