Convert Week Numbers to Start of the Week Date

user069636 · June 2021

I am trying to create a table graphed by week, and the analyzer converts the date columns to week numbers. Is there a way to convert these week numbers to start of the week date? eg. 5/23/21, 5/16/21, 5/9/21... 4/4/21

MarkSnodgrass · June 2021

You can create a beast mode to calculate the first day of the week with this:

DATE_SUB(`dt`, INTERVAL (DAYOFWEEK(`dt`) - 1) DAY)

You would then drag this field into your table and then change your date filter to group by none.

@GrantSmith did a nice write up about this and other date functions here in case you want to dig deeper.

https://dojo.domo.com/discussion/52687/domo-ideas-exchange-beast-modes-first-last-days-of-the-month-week#latest

MarkSnodgrass · June 2021

You can create a beast mode to calculate the first day of the week with this:

DATE_SUB(`dt`, INTERVAL (DAYOFWEEK(`dt`) - 1) DAY)

You would then drag this field into your table and then change your date filter to group by none.

@GrantSmith did a nice write up about this and other date functions here in case you want to dig deeper.

https://dojo.domo.com/discussion/52687/domo-ideas-exchange-beast-modes-first-last-days-of-the-month-week#latest

user069636 · June 2021

@MarkSnodgrass It worked. Thank you very much!

GrantSmith · June 2021

@user069636

That post was from a presentation that I gave for the Domo IDEAs conference. If you're interested the entire session can be found here: https://www.youtube.com/watch?v=gO8OLpsAk4M

Convert Week Numbers to Start of the Week Date

Best Answer

Answers

Categories