Exclude current month from Card

A_Benincasa
A_Benincasa Member
in Beast Mode

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

Tagged:

Best Answers

  • pauljames
    pauljames Contributor
    Answer ✓

    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.

    IF I SOLVED YOUR PROBLEM, PLEASE "ACCEPT" MY ANSWER AS A SOLUTION. THANK YOU!

  • ColemenWilson
    ColemenWilson Coach
    edited November 2023 Answer ✓

    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

    If I solved your problem, please select "yes" above

  • GrantSmith
    GrantSmith Coach
    Answer ✓

    +1 for LAST_DAY. An alternative is:

    CASE WHEN LAST_DAY(`Date`) < LAST_DAY(CURRENT_DATE()) THEN 'In' ELSE 'Out' END
    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**

Answers

  • pauljames
    pauljames Contributor
    Answer ✓

    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.

    IF I SOLVED YOUR PROBLEM, PLEASE "ACCEPT" MY ANSWER AS A SOLUTION. THANK YOU!

  • ColemenWilson
    ColemenWilson Coach
    edited November 2023 Answer ✓

    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

    If I solved your problem, please select "yes" above

  • GrantSmith
    GrantSmith Coach
    Answer ✓

    +1 for LAST_DAY. An alternative is:

    CASE WHEN LAST_DAY(`Date`) < LAST_DAY(CURRENT_DATE()) THEN 'In' ELSE 'Out' END
    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**

Categories