Data Studio
6.1K members online now
6.1K members online now
Ask questions about Data Studio
Guide Me

Funnel conversion filterable by dimensions

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

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 :


 Screen Shot 2017-03-09 at 20.07.37.png


In data studio,  the data is received like this : 


Screen Shot 2017-03-09 at 20.21.03.png


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 !