Remove dates from a card with a beastmode?

pauljames
pauljames Contributor
edited October 2023 in Beast Mode

Hi, is this possible?

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

Tagged:

Best Answer

  • GrantSmith
    GrantSmith Coach
    edited October 2023 Answer ✓

    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.

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**

Answers

  • ST_Superman
    ST_Superman Domo Employee

    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
    pauljames Contributor

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

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

  • GrantSmith
    GrantSmith Coach
    edited October 2023 Answer ✓

    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.

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**

Categories