Beast Mode - Multiple functions
I've created a beast mode which is correct to add 2 working days to a date.
However I want then be able to group this new date into calendar weeks. I used WeekofYear Beast Mode which came out as valid but when I graph this then drill into the week is the first date for the week is Thursday not Monday.
I assume that based on how I did this I can't have 1 beast mode and then use that beast mode for the DataSet Field and I need to make 1 beast mode.
Any ideas how to do this?
What I have with the beast mode used as a data set inside another beast moade
WEEKOFYEAR(DATE(DATE_ADD(`estimated arrival at pod date`, INTERVAL (FLOOR(4/5) * 7 + CASE WHEN MOD(4,5) + DAYOFWEEK(`estimated arrival at pod date`) >= 7 THEN 2 - FLOOR(DAYOFWEEK(`estimated arrival at pod date`)/7) ELSE 0 END + MOD(4,5)) DAY)))
- 10.6K All Categories
- 13 Getting Started in the Community
- 29 Beastmode & Analytics
- 2.1K Data Platform & Data Science
- 59 Domo Everywhere
- 2.7K Charting
- 2.4K Ideas Exchange
- 1.3K Connectors
- 362 Workbench
- 300 Use Cases & Best Practices
- 499 APIs
- 118 Apps
- 48 News
- 753 Onboarding
- 1.1K 日本支部
- 4 Private Company Board