AdWords is now Google Ads. Our new name reflects the full range of advertising options we offer across Search, Display, YouTube, and more. Learn more

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

Scatter Plot keeps summing my data

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Hello all!

 

I connected my Big Query datasource to a dataset table with the following schema:

* dt: datetime

* frequency: integer

* count: integer

 

For each day, there is a "frequency distribution" of "counts" e.g.

* 2017-06-30  frequency=1  count=10000

* 2017-06-30  frequency=2  count=5000

etc.

 

The problem I am having is that the "scatter plot" sums up my data for each day, resulting in 1 data point per day.  This is not what I want : I wish to display 1 day of data with the full frequency distribution.

 

Please help !

Thanks,

Jean-Lou Dupont

Scatter Plot keeps summing my data

Participant ✭ ✭ ☆
# 2
Participant ✭ ✭ ☆

In your data source in Data Studio (when you click the pencil button), how is the frequency set up? I suspect that it's set up as a sum, and it sounds like that's not what you want. I'm not entirely clear how exactly you want to represent frequency though. Is it that you want any item with a frequency of 1 to be reported separately than that with a frequency of 2? If so, that sounds more like a dimension to me than a metric. 

Scatter Plot keeps summing my data

Visitor ✭ ✭ ✭
# 3
Visitor ✭ ✭ ✭

You got me on the right track i.e. dimension instead of metric  !  Thanks.

Scatter Plot keeps summing my data

Visitor ✭ ✭ ✭
# 4
Visitor ✭ ✭ ✭

Hi Ive got the same issue. Did you find a solution to this?