Best Of

Upcoming January Feature Release-January 24th

We are excited to have new features shipping to customers next week. One of my core goals for our team this year is to improve release transparency. Many of you noticed that we did send an in product announcement last week with a list of the upcoming new features. I have heard from some that they saw it but now want to go back and see the list. While we figure out if there is a more technical way to do this, I did want to share a PDF with the preview screens you would have seen in Domo. Excited to get these features out to all of our users soon!

Upcoming Product Release - January 2024-20240116.pdf

BenSchein

15

Re: Beast Mode to show total for previous week and two weeks prior

@user028686

If you absolutely must use a beast mode you could utilize the DAYOFWEEK function to get the end of the prior week and then subtract the number of weeks you're interested in. DAYOFWEEK returns values between 1 (Sunday) and 7 (Saturday). Subtracting that value for the number of days will return the end of last week

For example - 1 Week Ago / Last Week:

SUM(
CASE WHEN (`Date`) > DATE_SUB(CURRENT_DATE(), INTERVAL DAYOFWEEK(CURRENT_DATE()) + (1*7) DAY)
AND (`Date`) <= DATE_SUB(CURRENT_DATE(), INTERVAL DAYOFWEEK(CURRENT_DATE()) + (0*7) DAY)
THEN 1
ELSE 0
END)

2 Weeks Ago:

SUM(
CASE WHEN (`Date`) > DATE_SUB(CURRENT_DATE(), INTERVAL DAYOFWEEK(CURRENT_DATE()) + (2*7) DAY)
AND (`Date`) <= DATE_SUB(CURRENT_DATE(), INTERVAL DAYOFWEEK(CURRENT_DATE()) + (1*7) DAY)
THEN 1
ELSE 0
END)

To break it down for the week ago example: DATE_SUB(INTERVAL DAYOFWEEK(CURRENT_DATE()) + (0*7) DAY) says give me the Date of the Saturday before today. (0*7 here isn't needed but is to help illustrate the logic saying I don't want any weeks prior to this date)

(1*7) adds an extra week before that. (2*7) is two weeks prior.