Displaying Google Form survey data as percent favorable in Looker

[cgil1]

Hi!

I'm working on a survey dashboard in Looker using form responses from a Google Form. The form asks participants to rate their session and facilitator on a scale of 1 to 5. I will need to sort this data by a variety of metrics like facilitator, client name, date and participant type. 

Where I'm getting stuck is trying to calculate percent favorable across a session with multiple survey responses, which would mean of the scores 1, 2, 3, 4 and 5, scores of 4 and 5 are considered favorable. Ideally I'd want the percentage of favorable scores calculated for each session, client and facilitator. 

Here's a sample  of the type of date we receive. 

Is there a way to create a calculated field to output the percent favorable metric that references col B-E having matching values? Or another method I'm not seeing? Here's a link to the Looker Studio report  I have so far. Appreciate any help here!

[Mehdi_Oudjida · Accepted solution]

Hi cgil1,

If I understood correctly the question, to calculate the Favorable rate for Workshop CSAT, you can create a calculated field and apply the following formula:

SUM(IF(Workshop CSAT > 3, 1 ,0))/COUNT(Workshop CSAT)
and display it as a numeric percent data type

I hope it helps.

[cgil1]

This worked perfectly! Thank you so much.