Applying filters to calculated fields
Is there any way to apply a filter to a calculated field please?
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!