Exclude current month from Card

A_Benincasa

Hello again,

I am trying to create a beast mode that would update automatically, but exclude the current month. I know there is a filter for this but we want it to update automatically for our users

pauljames

Hi @A_Benincasa! I've used this below.

CASE WHEN WEEK(`Date`) = WEEK(CURRENT_DATE()) AND YEAR(`Date`) = YEAR(CURRENT_DATE()) THEN 0 ELSE 1 END

Set this as a filter and have it = 1. This will allow any date that does not fall on the same Week # and Year as the current date to be included in your data.

ColemenWilson

You can create this beastmode and then use it as a filter on your card:

CASE WHEN `yourDateField` <= LAST_DAY(CURRENT_DATE()) - INTERVAL 1 MONTH THEN 'In' ELSE 'Out' END

GrantSmith

+1 for LAST_DAY. An alternative is:

CASE WHEN LAST_DAY(`Date`) < LAST_DAY(CURRENT_DATE()) THEN 'In' ELSE 'Out' END

pauljames

Hi @A_Benincasa! I've used this below.

CASE WHEN WEEK(`Date`) = WEEK(CURRENT_DATE()) AND YEAR(`Date`) = YEAR(CURRENT_DATE()) THEN 0 ELSE 1 END

Set this as a filter and have it = 1. This will allow any date that does not fall on the same Week # and Year as the current date to be included in your data.

ColemenWilson

You can create this beastmode and then use it as a filter on your card:

CASE WHEN `yourDateField` <= LAST_DAY(CURRENT_DATE()) - INTERVAL 1 MONTH THEN 'In' ELSE 'Out' END

GrantSmith

+1 for LAST_DAY. An alternative is:

CASE WHEN LAST_DAY(`Date`) < LAST_DAY(CURRENT_DATE()) THEN 'In' ELSE 'Out' END