Remove dates from a card with a beastmode?

pauljames

Hi, is this possible?

GrantSmith

Something like this can work. You can tweak based on your logic but I tried to give several different examples:

CASE WHEN date IN ('2022-01-01', '2022-02-01'…) THEN 'Exclude'

WHEN YEAR(`date`) = 2022 THEN 'Exclude'

WHEN DAYOFMONTH(`date`) = 1 THEN 'Exclude'

WHEN DAYOFWEEK(`date`) = 4 THEN 'Exclude'

WHEN LAST_DAY(`date`) = 2022-01-31 THEN 'Exclude'

ELSE 'Include'

END

Then just filter for Inlcude in your card.

ST_Superman

You can create a beastmode to flag certain dates and then select to either include or exclude those dates by adding the beastmode to the filter section.

pauljames

how do you batch dates together in a beast mode? case statement?

GrantSmith

Something like this can work. You can tweak based on your logic but I tried to give several different examples:

CASE WHEN date IN ('2022-01-01', '2022-02-01'…) THEN 'Exclude'

WHEN YEAR(`date`) = 2022 THEN 'Exclude'

WHEN DAYOFMONTH(`date`) = 1 THEN 'Exclude'

WHEN DAYOFWEEK(`date`) = 4 THEN 'Exclude'

WHEN LAST_DAY(`date`) = 2022-01-31 THEN 'Exclude'

ELSE 'Include'

END

Then just filter for Inlcude in your card.