beastmode week start
I have a client whose week starts on Monday. since the default week start day in Domo is Sunday, I would like to use beastmode to calculate week numbers with a start day of monday.
I get a validation error every time I try to input a number in the [mode] portion of WEEK(date,[mode]). I'm referencing MySQL 5.5 documentation when inputting the number 5 as my mode. I've tried single quotes, double quotes, no quotes, all get the same error. I've also tried inputting all numbers from 0-7 in the formula and gotten the same error each time. Has anyone else encountered/overcome this?
from MySQL 5.5 Reference on week function
Error in beastmode calc
Best Answer
-
Hello @kingaaronj,
There is a great article that goes into details about each function in beastmode. Please see the section under, "Week" in the following article.WEEK Returns the week number for all dates in a date/time column. Equivalent to WEEKOFYEAR.
Adrenaline 2 users can also use the following modifiers:
WEEK(`Date Column`,11) = Week starts January 1st and Sunday is start of week
WEEK(`Date Column`,22) = Week follows ISO calendar and Monday is start of week
**Say “Thanks" by clicking the thumbs up in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"6
Answers
-
Hi all,
Can anybody help @kingaaronj out?
Thanks!0 -
Hello @kingaaronj,
There is a great article that goes into details about each function in beastmode. Please see the section under, "Week" in the following article.WEEK Returns the week number for all dates in a date/time column. Equivalent to WEEKOFYEAR.
Adrenaline 2 users can also use the following modifiers:
WEEK(`Date Column`,11) = Week starts January 1st and Sunday is start of week
WEEK(`Date Column`,22) = Week follows ISO calendar and Monday is start of week
**Say “Thanks" by clicking the thumbs up in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"6 -
Thank you for this @ilikenno. Very helpful!
I actually noticed through trial & error that WEEK(`Date Column`) appears to give the same result as WEEK(`Date Column`,22) where the weeks start on Monday. Good to know.
2 -
can you start the week on a Friday
Week(date,?) what number do you use
thanks
0 -
Hello,
I know this is an old thread, but perhaps someone is still reading. I would like my year to begin on 6/1 and week to begin on Saturday, and end Friday. I'm messing around in Beast Mode trying to get this to work. Here is what I have so far:
WEEK(`INVOICE_DATE`,61)
0 -
Two ways of doing it (for me anyways):
IF you need this as the calendar for your whole instance, ask your Domo rep to set it up as a Fiscal Calendar
If this is for a specific card:
Create a spreadsheet with the following columns adjsuted for your new calendar
Date, Adjusted Year, Adjusted Week First Day
Join them using ETL
You cna then use those columns when building cards, not as good as a fiscal calendar though.
0 -
thank you, it works
WEEK(
timestamp
,1) move the beginning of the week from Sunday to Monday0
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 294 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 97 SQL DataFlows
- 607 Datasets
- 2.1K Magic ETL
- 3.8K Visualize
- 2.4K Charting
- 707 Beast Mode
- 49 App Studio
- 39 Variables
- 667 Automate
- 170 Apps
- 446 APIs & Domo Developer
- 44 Workflows
- 7 DomoAI
- 33 Predict
- 13 Jupyter Workspaces
- 20 R & Python Tiles
- 391 Distribute
- 111 Domo Everywhere
- 274 Scheduled Reports
- 6 Software Integrations
- 115 Manage
- 112 Governance & Security
- Domo Community Gallery
- 31 Product Releases
- 9 Domo University
- 5.3K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 103 Community Announcements
- 4.8K Archive