Does Beast Mode support using "Contains" to Identify Value Count

afieweger
afieweger Member
in Beast Mode

Hey there…

I have a field called PresentationName where we (unfortunately) use a text string as part of the PresentationName to identify a Type of presentation. Clearly we need to pull that out into its own metadata and will in the future.

But for now, I need to find a way to create a calculated field that lets me get a count of PresentationName where the PresentationName contains "self-service" text string.

Any thoughts on how to structure this?

Thank you

Tagged:

Best Answers

  • RobSomers
    RobSomers Coach
    Answer ✓

    @afieweger Yes, you will use LIKE and wildcard characters in your case when statement:

    SUM(case when PresentationName LIKE '%self-service%' then 1 else 0 end)

    The % symbol will just say there can be any number of characters before or after 'self-service'. I like doing counts with an equivalent sum expression.

    **Was this post helpful? Click Agree or Like below**

    **Did this solve your problem? Accept it as a solution!**

  • MarkSnodgrass
    MarkSnodgrass Coach
    Answer ✓

    you can use the LIKE operator with the % sign on each side to make it look for the phrase contains. Would be something like this:

    CASE WHEN fieldname LIKE '%self-service%' THEN 'Self-Service'

    ELSE 'Something else'

    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.

Answers

  • RobSomers
    RobSomers Coach
    Answer ✓

    @afieweger Yes, you will use LIKE and wildcard characters in your case when statement:

    SUM(case when PresentationName LIKE '%self-service%' then 1 else 0 end)

    The % symbol will just say there can be any number of characters before or after 'self-service'. I like doing counts with an equivalent sum expression.

    **Was this post helpful? Click Agree or Like below**

    **Did this solve your problem? Accept it as a solution!**

  • MarkSnodgrass
    MarkSnodgrass Coach
    Answer ✓

    you can use the LIKE operator with the % sign on each side to make it look for the phrase contains. Would be something like this:

    CASE WHEN fieldname LIKE '%self-service%' THEN 'Self-Service'

    ELSE 'Something else'

    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.
  • Charlie Bantoft
    Charlie Bantoft Member

    Can you put a variable inside the %s? So:

    CASE WHEN fieldname LIKE '%'variable a'%' THEN 'Self-Service' ELSE 'Something else'

  • Mark Puddephatt
    Mark Puddephatt Member

    Same question as Charlie ^^

Categories