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.9K Product Ideas
- 1.9K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 302 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 104 SQL DataFlows
- 637 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 761 Beast Mode
- 65 App Studio
- 42 Variables
- 704 Automate
- 182 Apps
- 458 APIs & Domo Developer
- 53 Workflows
- 11 DomoAI
- 39 Predict
- 16 Jupyter Workspaces
- 23 R & Python Tiles
- 401 Distribute
- 116 Domo Everywhere
- 277 Scheduled Reports
- 8 Software Integrations
- 132 Manage
- 129 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 111 Community Announcements
- 4.8K Archive