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
4.6K members online now
4.6K members online now
Ask questions about Data Studio
Guide Me
star_border
Reply

How to calculate percentage with text field

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

If I have a text field, where the response is yes/no. How can I count the yes and/or no and divide by total to get a percentage?

For example if 100 respondents reply, but only 93 say yes. How do I calculate the 93% from a text field?


Gregg

How to calculate percentage with text field

Follower ✭ ☆ ☆
# 2
Follower ✭ ☆ ☆

This seems something you can fix via About CASE statement, you can find more info here https://support.google.com/datastudio/answer/7020724?hl=en