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

DataLawton · 2025-02-17T08:11:05+00:00

There was an error rendering this rich post.

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!

Find more posts tagged with

Visualization

Date

Magic ETL

Beast Mode

Scheduled Reports

Accepted answers

All comments

MichelleH

@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.

DataLawton

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