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

Applying filters to calculated fields

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Hey all,


Is there any way to apply a filter to a calculated field please?


For example:


I am trying to work out a 'love ratio' (the % of people that say they love my app when presented with a yes or no choice). I have an event called "ratings_prompt" and I need to set up the following (unless I am mistaken):


(Total rating_prompt events where the param "choice" value = "True" / Total rating_prompt events) x 100


The only problem is that the filters to allow be to select specific event names, parameter name and parameter string values, seem to be applied on the dash so I can not work out how to use them in the calculated field calculation. 


Any suggestions would be amazing!


Thank you,