Excluding weekends from a prior day card
Hello,
I'm build a prior day card that as name says will be depicting a prior day data. Business operates Monday-Friday but prior day on Monday would show no data since it is using Sunday's information. Is there a syntax I could write or other transformation that would exclude weekends from being included in last day and on Mondays would show Friday's data?
Thank you
Answers
-
You can create a beast mode that you would add to your filters to filter out weekends from your dataset. Your beast mode would look like this:
CASE WHEN DAYNAME(`date`) IN ('Sunday','Saturday') THEN 'Exclude' ELSE 'Include' END
You would then add this to your filter and filter to Include.
**Check out my Domo Tips & Tricks Videos
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.1 -
@MarkSnodgrass thanks for that tip. Unfortunately, it doesn't work. When creating the beast mode I get the error 'Calculation Error : A column in this calculation did not exist.'
Any ideas?
0 -
@zuchu you are going to need to replace the "date" column with the name of your column that is in your dataset.
Also, which card are you using? That may affect if this solution will work for you or not.
**Check out my Domo Tips & Tricks Videos
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.0 -
Will give it a try!
I'm using a 'single value' card, if you feel like there is a better way to present a single value, please let me know
0 -
Up, anybody got any ideas?
0
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 295 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 97 SQL DataFlows
- 608 Datasets
- 2.1K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 712 Beast Mode
- 50 App Studio
- 39 Variables
- 668 Automate
- 170 Apps
- 446 APIs & Domo Developer
- 45 Workflows
- 7 DomoAI
- 34 Predict
- 14 Jupyter Workspaces
- 20 R & Python Tiles
- 391 Distribute
- 111 Domo Everywhere
- 274 Scheduled Reports
- 6 Software Integrations
- 116 Manage
- 113 Governance & Security
- Domo Community Gallery
- 31 Product Releases
- 9 Domo University
- 5.3K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 104 Community Announcements
- 4.8K Archive