Comments
-
An example (minus percent change): Another example (minus percent change):
-
Thank you for this, this helped me create: Previous Month YoY: CASE WHEN ( YEAR(Date) = YEAR(DATE_SUB(CURDATE(), INTERVAL 1 MONTH)) AND MONTH(Date) = MONTH(DATE_SUB(CURDATE(), INTERVAL 1 MONTH)) ) OR ( YEAR(Date) = YEAR(DATE_SUB(CURDATE(), INTERVAL 13 MONTH)) AND MONTH(Date) = MONTH(DATE_SUB(CURDATE(), INTERVAL 13 MONTH))…
-
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
