Sum Value Not Calculating With Date Range
Hey, I have created a blended data source between two different Google Ads accounts, I now want to create a scorecard that shows the total value something (like clicks, cost, impressions etc).
I have got this working (to a certain extent) by renaming the fields in the blended source so that I can easily add them together as a calculated field, the sum looks like this:
SUM(firstgoogleadsaccountclicks)+SUM(secondgoogleadsaccountclicks)
This works in the scorecard for a particular day, but it is not aggregated to show the correct sum for a date range.
Any ideas? I can provide more info is necessary.
Hi Mike,
Thanks for reaching out.
Generally we can't offer in depth support for calculated fields or blending features, hence the disclaimer below. However we are willing to review your file if we can spot the issue within our abilities.
We've sent you a private message in order to request some details of the dashboard configuration.
https://support.google.com/datastudio/community?authuser=0
Kind regards
Supermetrics Support