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

Calculating a weighted average in Data Studio

Explorer ✭ ✭ ✭
# 1
Explorer ✭ ✭ ✭

Does anyone know how to create a calculated average in Data Studio? 

 

I would like to calculate the average number of days it takes someone to complete a website conversion using multi-channel funnel data from google analytics. If we suppose the data I'm using is in Google Sheets and it is structured like:

Column A: Date (dimension)

Column B: traffic channel (dimension)

Column C: # of days to conversion (dimension) and

Column D: Total conversions (metric)

How would you write a formula in Data Studio that will calculate the weighted average for # of days to conversion?

Calculating a weighted average in Data Studio

Visitor ✭ ✭ ✭
# 2
Visitor ✭ ✭ ✭

Hi,

Did you find an answer for this, if so could you please share.

 

Thanks