Beast mode calculations with multiple conditions

user03799
user03799
in Archive

Hi!

 

Has anyone got a formula for a calculation which uses multiple conditions/parameters? 

For example: If Ad = Rewards and Activity = 'App Complete' then click through conversions

I'm trying to identify which ads delivering what kind of conversion.

 

Anyone please help

Comments

  • RGranada
    RGranada Contributor

    Hi,

     

    You must be looking for something like :

     

    CASE WHEN Ad = Rewards and Activity = 'App Complete'  THEN click through 

              WHEN Ad = RewardsZX and Activity = 'App Complete 2'  THEN click through2

              WHEN Ad = Type2  and Activity = 'App inComplete '  THEN click through3

    END 

     

    those are example situations.

     

    There is a nice video on case statements in this link:

    https://university.domo.com/videos/watch/gzaHJiMDE6NgneXhCj_39_wZES-5u3yn

     

    And some information here:

     

    http://knowledge.domo.com?cid=beastmodereference

     

    Hope this helps.

    Ricardo Granada 

    MajorDomo@Lusiaves

    **If the post solves your problem, mark it by clicking on "Accept as Solution"
    **You can say "Thank you" by clicking the thumbs up in the post that helped you.

Categories