Announcements
The Google Cloud Community will be in read-only from July 16 - July 22 as we migrate to a new platform; refer to this community post for more details.

Helpfulness calculation

vavet
New Member

hey, I have a metric that is called "Feedback". I receive two action event "Yes" & "No". With looker studio i want to calculate the helpfulness ranking of my page (total number of "Yes"/total number of "Feedback")

But I can't find a way to do it. Anyone can help me to create this calculation? 

1 1 56
1 REPLY 1

Something like this?

SUM(IF(Feedback="Yes",1,0))/COUNT(Feedback)