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
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.
@MarkSnodgrass It worked. Thank you very much!
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