Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

SOLVED

Calculated Metrics IF THEN ELSE statements

Avatar

Not applicable

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

1 Accepted Solution

Avatar

Correct answer by
Level 2

Hi Laura,

Conditional statement works fine, usually.

However, there could have a mistake in the metric definition: could you please share a screenshot of your custom metric with us?

Thanks,

Nicolas

View solution in original post

1 Reply

Avatar

Correct answer by
Level 2

Hi Laura,

Conditional statement works fine, usually.

However, there could have a mistake in the metric definition: could you please share a screenshot of your custom metric with us?

Thanks,

Nicolas