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