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

CASE formula to sum (counter) when a text field occurs

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Hello.

 

I'm trying to create a metric that will sum a counter field (origin) (which is prepopulated with a value of 1) every time a text field with the value "Hello" occurs.

 

So, something like:

 

CASE WHEN field_name = 'Yes' THEN SUM (origin) ELSE END

 

I don't need the "else" in this case.

 

Thank you.