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

DataLawton · February 17

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!

MichelleH · February 17

@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 · March 2

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

Cards, Dashboards, Stories

Cards, Dashboards, Stories

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

Answers

Welcome!

Welcome!

Quick Links

Categories