Data Averaging Problem
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!