Data Studio
2.4K members online now
2.4K members online now
Ask questions about Data Studio
Guide Me
star_border
Reply

Case with calculated field

Follower ✭ ☆ ☆
# 1
Follower ✭ ☆ ☆

Hello,

 

I have a problem with case using calculated field.

Into the case help is written that: 

CASE
    WHEN metric1 + metric2 > 4 THEN ... // error!

is not allowed and suggestion is to create a field with that calculation.

But when I'm trying to use such a filed I have an error that Re-aggregating metrics are not supported.

Any help on that? 

Case with calculated field

Explorer ✭ ✭ ✭
# 2
Explorer ✭ ✭ ✭

Hi @Hristo H

 

I believe this is because you are trying to calculate within your CASE statement, can you make a new measure (metric 3, for example) which is [metric1] + [metric2] and alter your case to WHEN metric3 > 4 THEN...

 

Hope that helps,

Ben