Help with Date Range/ Period to Date

As you know Domo has a selection Date Range, Period to Date, and if I click on Week to Date, my 3 cards will update the date dimension to current Week to Date, Month to Date, and Quarter to Date.
I'm trying to create a filter or a button to do same functions Period to Date: WTD, MTD, QTD, YTD without clicking on Date Range, Current. The reason for this filter is I can place it on the main dashboard and my stakeholders can easily see WTD, MTD buttons and they can select Period to Date. Any suggestions?
Best Answer
-
Anything you create manually will not interact with the Date Range filter, keep that in mind because it could cause issues. It might be helpful to uncheck "Allow Global Date" filtering on your cards.
If you go this route, I would recommend creating a variable and then have a beast mode that uses the variable and then place the beast mode in your filters. Example:
CASE WHEN `Period Variable` = 'WTD' AND `Date` >= DATE_SUB(TODAY(), INTERVAL (DAYOFWEEK(TODAY()) - 1) DAY) AND `Date` ⇐ TODAY()THEN 'Include' WHEN `Period Variable` = 'MTD' AND `Date` >= DATE_SUB(TODAY(), INTERVAL (DAY(TODAY()) - 1) DAY) AND `Date` ⇐ TODAY()THEN 'Include' WHEN `Period Variable` = 'QTD' AND `Date` >= DATE_SUB(DATE_SUB(TODAY(), INTERVAL (DAY(TODAY()) - 1) DAY) , INTERVAL (MOD(MONTH(TODAY()) + 2, 3)) MONTH) AND `Date` ⇐ TODAY()THEN 'Include' WHEN `Period Variable` = 'YTD' AND `Date` >= STR_TO_DATE(CONCAT('01-01',YEAR(TODAY)),'%Y-%m-%d') AND `Date` ⇐ TODAY()THEN 'Include' ELSE 'Exclude' END
1
Answers
-
Anything you create manually will not interact with the Date Range filter, keep that in mind because it could cause issues. It might be helpful to uncheck "Allow Global Date" filtering on your cards.
If you go this route, I would recommend creating a variable and then have a beast mode that uses the variable and then place the beast mode in your filters. Example:
CASE WHEN `Period Variable` = 'WTD' AND `Date` >= DATE_SUB(TODAY(), INTERVAL (DAYOFWEEK(TODAY()) - 1) DAY) AND `Date` ⇐ TODAY()THEN 'Include' WHEN `Period Variable` = 'MTD' AND `Date` >= DATE_SUB(TODAY(), INTERVAL (DAY(TODAY()) - 1) DAY) AND `Date` ⇐ TODAY()THEN 'Include' WHEN `Period Variable` = 'QTD' AND `Date` >= DATE_SUB(DATE_SUB(TODAY(), INTERVAL (DAY(TODAY()) - 1) DAY) , INTERVAL (MOD(MONTH(TODAY()) + 2, 3)) MONTH) AND `Date` ⇐ TODAY()THEN 'Include' WHEN `Period Variable` = 'YTD' AND `Date` >= STR_TO_DATE(CONCAT('01-01',YEAR(TODAY)),'%Y-%m-%d') AND `Date` ⇐ TODAY()THEN 'Include' ELSE 'Exclude' END
1 -
Anything you create manually will not interact with the Date Range filter, keep that in mind because it could cause issues. It might be helpful to uncheck "Allow Global Date" filtering on your cards.
If you go this route, I would recommend creating a variable and then have a beast mode that uses the variable and then place the beast mode in your filters. Example:
It's better late than never - thank you! 😃
0
Categories
- All Categories
- 2K Product Ideas
- 2K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 311 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 3.8K Transform
- 657 Datasets
- 115 SQL DataFlows
- 2.2K Magic ETL
- 815 Beast Mode
- 3.3K Visualize
- 2.5K Charting
- 81 App Studio
- 45 Variables
- 775 Automate
- 190 Apps
- 481 APIs & Domo Developer
- 81 Workflows
- 23 Code Engine
- 40 AI and Machine Learning
- 20 AI Chat
- 1 AI Playground
- 1 AI Projects and Models
- 18 Jupyter Workspaces
- 410 Distribute
- 120 Domo Everywhere
- 280 Scheduled Reports
- 10 Software Integrations
- 144 Manage
- 140 Governance & Security
- 8 Domo Community Gallery
- 48 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 114 Community Announcements
- 4.8K Archive