Funnel conversion filterable by dimensions
Hey dear Data Studio Community,
I've got some trouble trying to put together a conversion funnel. I'm extracting some data using a personalized big query request which outputs data organized like this :
In data studio, the data is received like this :
The trouble is that when aggregating the data, it averages the transformation rate regardless of the volume associated (number of users). Then, the Safari transformation (50% let's say) with its 2 users will by bluntly averaged with the chrome transformation (25% let's say) and its 300 users, outputing in my graph a conversion rate of 32.5%.
How can I organize things so that the pourcentages doesn't get tricked by aggregation ? I guess I could create a calculated field in data studio to obtain the transformation instead of processing it in my query. I tried something like number_of_users / max(number_of_users) but this doesn't work.
Thank you very much in advance for your help !