beastmode week start

kingaaronj

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

 

 

Gimli

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. 

http://knowledge.domo.com?cid=beastmodereference

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

kshah008

Hi all,

Can anybody help @kingaaronj out?

Thanks!

Gimli

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. 

http://knowledge.domo.com?cid=beastmodereference

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

kingaaronj

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.

HelenOBrien

can you start the week on a Friday 

Week(date,?) what number do you use 

thanks 

mczerniak

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)

rado98

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.

 

German_Rodriguez

https://community-forums.domo.com/main/discussion/comment/16002#Comment_16002

thank you, it works

WEEK(timestamp,1) move the beginning of the week from Sunday to Monday