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 to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.0
Categories
- All Categories
- 1.4K Product Ideas
- 1.4K Ideas Exchange
- 1.4K Connect
- 1.2K Connectors
- 284 Workbench
- 4 Cloud Amplifier
- 4 Federated
- 2.9K Transform
- 89 SQL DataFlows
- 556 Datasets
- 2.2K Magic ETL
- 3.3K Visualize
- 2.3K Charting
- 569 Beast Mode
- 11 App Studio
- 27 Variables
- 578 Automate
- 140 Apps
- 414 APIs & Domo Developer
- 23 Workflows
- 1 DomoAI
- 28 Predict
- 12 Jupyter Workspaces
- 16 R & Python Tiles
- 350 Distribute
- 90 Domo Everywhere
- 258 Scheduled Reports
- 2 Software Integrations
- 92 Manage
- 89 Governance & Security
- 9 Product Release Questions
- Community Forums
- 42 Getting Started
- 28 Community Member Introductions
- 85 Community Announcements
- 4.8K Archive