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

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 !

 

Arthur