Beastmode adding multiple different values from the same column

Golfoholic

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?

GrantSmith

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)