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.1K Connectors
- 282 Workbench
- 3 Cloud Amplifier
- 4 Federated
- 2.8K Transform
- 86 SQL DataFlows
- 548 Datasets
- 2.2K Magic ETL
- 3.2K Visualize
- 2.3K Charting
- 544 Beast Mode
- App Studio
- 26 Variables
- 566 Automate
- 134 Apps
- 411 APIs & Domo Developer
- 21 Workflows
- DomoAI
- 28 Predict
- 12 Jupyter Workspaces
- 16 R & Python Tiles
- 345 Distribute
- 87 Domo Everywhere
- 257 Scheduled Reports
- 1 Software Integrations
- 85 Manage
- 84 Governance & Security
- 9 Product Release Questions
- Community Forums
- 41 Getting Started
- 27 Community Member Introductions
- 81 Community Announcements
- 4.8K Archive