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.8K members online now
4.8K members online now
Ask questions about Data Studio
Guide Me
star_border
Reply

Invalid metric using None for the Aggregation

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

I'm trying to plot data collected in a Sheet vs time. Time appears as the Dimension (correctly). Columns are Additional Dimensions. Setting Aggregation to None forces a column (Chip color = green) to be a Dimension. However, I don't want any form of Aggregation for the columns - I just want to use the raw Sheet data for the plot. But I can't. In the screengrab below, Outside Air Temp becomes a second Dimension because it's Aggregation is set to None. In fact I want Outside Air Temp to be a plotted value using raw data directly from the Sheet.

Screenshot 2017-04-14 at 9.35.15 AM.png

Even using Aggregation = Average produces a weird plot. In the example below there are no zero values in the data - but the plot shows them.

Screenshot 2017-04-14 at 9.34.11 AM.png

What am I doing wrong? Or is Studio incapable of handling raw data?

 

Invalid metric using None for the Aggregation

Visitor ✭ ✭ ✭
# 2
Visitor ✭ ✭ ✭

I have the exact same question: Is DS capable of plotting raw values?

Invalid metric using None for the Aggregation

Participant ✭ ✭ ☆
# 3
Participant ✭ ✭ ☆

Do you have a non-zero value for every date and time? 

Invalid metric using None for the Aggregation

Visitor ✭ ✭ ✭
# 4
Visitor ✭ ✭ ✭

Same problem, is it possible just use a number as metric value?

Invalid metric using None for the Aggregation

Visitor ✭ ✭ ✭
# 5
Visitor ✭ ✭ ✭

Same issue. Is this solved yet??