Calculating a weighted average in Data Studio
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?