Beast mode calculations with multiple conditions

user03799

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

RGranada

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.