Calculated Metrics IF THEN ELSE Statements

Avatar

Avatar

laurab73463013

Avatar

laurab73463013

laurab73463013

15-07-2019

Hi, i am trying to use if then else statements in a calculated metric to give me a column with all relevant numbers. However it will only generate the first 2 correctly then seems to stop, i have tried stripping right back but i cant seem to get some to work at all.

I am simply using a calculated metric to say If metric = A then value of X, else If metric = B, then value of Y, if metric = C then value = Z ELSE value 0

Any help please would be great! Thank you

View Entire Topic

Avatar

Avatar

madhurc30892467

Avatar

madhurc30892467

madhurc30892467

16-07-2019

Hi Laurab,

I've tried creating a calculated metric using 'if' statement (see the screengrabs) & in this case I've taken referring domains as a dimension with visit metrics & it seems to be working fine. You can use the similar logic & see if it's working for you.

1792954_pastedImage_1.png

1792961_pastedImage_2.png

Thanks

M