Beast mode to find last working day
Trying to figure out a beast mode that will filter my data to the last working day. Business works Monday-Friday. Want to be able to set chart to yesterday so that for daily morning chart shows yesterday's data. On a Monday it would pull data from Friday instead of Sunday.
If there is a better way to do this other than a beast mode open to that as well.
Best Answer
-
@RTM Try this beast mode to include data from 3 days ago if today is Monday or yesterday if today is not Monday. If your users need to look at the data over the weekend, then you will need to add an additional line to subtract 2 days if today is Sunday.
case when DAYNAME(CURRENT_DATE()) = 'Monday' and `Date` = DATE_SUB(CURRENT_DATE(),3) then 'Include' when `Date` = DATE_SUB(CURRENT_DATE(),1) then 'Include' else 'Exclude' end
1
Answers
-
@RTM Try this beast mode to include data from 3 days ago if today is Monday or yesterday if today is not Monday. If your users need to look at the data over the weekend, then you will need to add an additional line to subtract 2 days if today is Sunday.
case when DAYNAME(CURRENT_DATE()) = 'Monday' and `Date` = DATE_SUB(CURRENT_DATE(),3) then 'Include' when `Date` = DATE_SUB(CURRENT_DATE(),1) then 'Include' else 'Exclude' end
1 -
Thank you. Tried it and it seems to be working.
0
Categories
- All Categories
- 1.5K Product Ideas
- 1.5K Ideas Exchange
- 1.4K Connect
- 1.1K Connectors
- 280 Workbench
- 4 Cloud Amplifier
- 4 Federated
- 2.7K Transform
- 90 SQL DataFlows
- 563 Datasets
- 2K Magic ETL
- 3.4K Visualize
- 2.3K Charting
- 592 Beast Mode
- 13 App Studio
- 28 Variables
- 588 Automate
- 143 Apps
- 417 APIs & Domo Developer
- 27 Workflows
- 1 DomoAI
- 28 Predict
- 12 Jupyter Workspaces
- 16 R & Python Tiles
- 361 Distribute
- 99 Domo Everywhere
- 260 Scheduled Reports
- 2 Software Integrations
- 94 Manage
- 91 Governance & Security
- 9 Product Releases
- Community Forums
- 37 Getting Started
- 28 Community Member Introductions
- 90 Community Announcements
- 4.8K Archive