Beastmode for Week starting Monday

Ashley_Hanson
Member
in Charting
I have a colleague whose reporting week starts on Monday but our Domo instance starts our weeks on Sunday (and needs to stay that way). Most of their reporting is looking at the previous week's data and they are not the only person using the dataset so I can't adjust the dataset. Is there a way to write and a beastmode as a filter to have the card's data reflect a Monday-Sunday week?
Tagged:
0
Answers
-
You could create a custom beast mode sort order to get the order you want. This, for example, would move Sunday to the end of the week:
CASE WHEN DAYOFWEEK('dt') = 1 THEN 8 ELSE DAYOFWEEK('dt') END
I would also suggest looking at this post for several other date functions that might be useful for you.
**Check out my Domo Tips & Tricks Videos
**Make sure toany users posts that helped you.
**Please mark as accepted the ones who solved your issue.0
Categories
- All Categories
- Product Ideas
- 2K Ideas Exchange
- Connect
- 1.3K Connectors
- 308 Workbench
- 7 Cloud Amplifier
- 10 Federated
- Transform
- 661 Datasets
- 117 SQL DataFlows
- 2.2K Magic ETL
- 819 Beast Mode
- Visualize
- 2.6K Charting
- 85 App Studio
- 46 Variables
- Automate
- 193 Apps
- 483 APIs & Domo Developer
- 85 Workflows
- 23 Code Engine
- AI and Machine Learning
- 22 AI Chat
- 3 AI Projects and Models
- 18 Jupyter Workspaces
- Distribute
- 116 Domo Everywhere
- 282 Scheduled Reports
- 11 Software Integrations
- Manage
- 142 Governance & Security
- 9 Domo Community Gallery
- 49 Product Releases
- 13 Domo University
- Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 115 Community Announcements
- 5K Archive