How to Filter for "Today AND Last 7 Days" in Domo Visualizer?

DataLawton
DataLawton Member
in Cards, Dashboards, Stories

Hi everyone,

I’m trying to implement a date range in Domo (using `Reservation Start Date`) that includes both Today AND the Last 7 Days at the same time. This will be for a weekly scheduled send.

I know Domo has built-in filters for "Last 7 Days" and "Today," but I can't find a way to combine them in a single filter within Domo Visualizer.

Is this possible? Should I be using Beast Mode, Magic ETL, or another method to achieve this?

Thank you!

Tagged:

Answers

  • MichelleH
    MichelleH Coach

    @DataLawton If you select Previous > Last in the card date range picker, it will give you the option to select Last 8 days, which should give you what you want. Note that Domo's Last X Days/Weeks/Years etc. includes the current period.

    image.png
  • DataLawton
    DataLawton Member

    The solution to get Last x Days + Current day is by creating a beast mode and adding to Filters:

    CASE
    WHEN Hotel Arrival Date >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
    AND Hotel Arrival Date <= CURRENT_DATE() THEN 'Include'
    ELSE 'Exclude'
    END

Categories