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

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

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭



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.