Skip to content

    • Charting

    Charting

    Beastmode adding multiple different values from the same column

    Member
    in Charting

    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

    • Coach

      Hi @user048760

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

      1. 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!**

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Quick Links

    Categories