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,