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?
Something like this?
SUM(IF(Feedback="Yes",1,0))/COUNT(Feedback)
User | Count |
---|---|
1 | |
1 | |
1 | |
1 | |
1 |