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.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 616 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 738 Beast Mode
- 56 App Studio
- 40 Variables
- 684 Automate
- 176 Apps
- 452 APIs & Domo Developer
- 46 Workflows
- 10 DomoAI
- 35 Predict
- 14 Jupyter Workspaces
- 21 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 123 Manage
- 120 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive