Data Studio
3.5K members online now
3.5K 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?