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