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
5.3K members online now
5.3K 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.