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
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.