Beast mode 'Case when' for if a date exists

Katrina_Burns
Katrina_Burns Member
in Beast Mode

Hello! I am trying to write a beast mode that counts a row of data if a date is present. The first row of my beast mode is working, but I am having issues with the second row.

Basically, if a move-in date is present (or is not null), I want to count that row in this calculation.

I am new to writing beast modes so I am

Screenshot 2024-08-26 at 11.59.26 AM.png

not sure how to fix the syntax error. Any help is appreciated!

Tagged:

Best Answer

  • GrantSmith
    GrantSmith Coach
    Answer ✓ 
    CASE WHEN `Lead Stage` IN ('Move In', 'Moved In', 'Deposit') THEN 1
WHEN `MOVE_IN_DATE` IS NOT NULL THEN 1
ELSE 0
END

    You can use IN to check for multiple values

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

Answers

  • GrantSmith
    GrantSmith Coach
    Answer ✓ 
    CASE WHEN `Lead Stage` IN ('Move In', 'Moved In', 'Deposit') THEN 1
WHEN `MOVE_IN_DATE` IS NOT NULL THEN 1
ELSE 0
END

    You can use IN to check for multiple values

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

Categories