AdWords is now Google Ads. Our new name reflects the full range of advertising options we offer across Search, Display, YouTube, and more. Learn more

Data Studio
1.8K members online now
1.8K 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