Why won't this beast mode work -- case statement

CASE WHEN `Variable Name`<= 1 THEN 'SMALL'

 WHEN `Variable Name` BETWEEN 1 AND 1,000 THEN 'MEDIUM'

WHEN `Variable Name` > 1,000 'LARGE' END

Comments

  • Domo's beast mode doesn't like the BETWEEN clause. Also, you are missing the THEN statement just before 'Large'. Try this:

    CASE 
    WHEN `Variable Name`<= 1 THEN 'SMALL'
    WHEN `Variable Name` >= 1 AND `Variable Name` <= 1000 THEN 'MEDIUM'
    WHEN `Variable Name` > 1000 THEN 'LARGE' 
    END
    


    **Check out my Domo Tips & Tricks Videos

    **Make sure to <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.
  • You can't use commas in numerical comparisons. Also as @MarkSnodgrass mentioned you're missing a THEN in the last WHEN clause.

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