Beastmode adding multiple different values from the same column

Golfoholic
Golfoholic ⚪️
in Card Building

I have a marketing channel column. That has a dozen descriptions from all of our different marketing channels. I am only trying to take the count of a few of them together i.e. Yelp, Facebook, google ads, etc... How could I write a beastmode that I can pull out only the channels that I want to add together?

Tagged:

Answers

  • GrantSmith
    GrantSmith Indiana 🥷

    Hi @user048760

    You can utilize a beast mode to conditionally add the values together with a CASE statement:

    SUM(CASE WHEN `Marketing Channel` IN ('Yelp', 'Facebook', 'Google Ads') THEN `Value` ELSE 0 END)


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

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

Categories