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

Data Averaging Problem

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Hi, I have a custom data source that works perfectly, except that when I take away the data dimension google automatically sums all the metrics. This is a problem b/c metrics like CPC shouldn't be summed but averaged over a time period. Google automatically averages cpc from google analytics data when the date dimension is removed, so I'm wondering if there's a way to tell google to average metrics instead of sum them when the date dimension is removed. Thanks!