Comments
-
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
