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

Aggregate to Null results in invalid filter

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Hi All

 

I have a table with columns like

 

iteration_number (unique)

search_time_in_ms bigint,

launch_time_in_ms bigint,

play_time_in_ms bigint,

location varchar2(50),

timestamp timestamp

 

When I run a chart, it shows aggregation to SUM/Average but when I set it to NONE, the metrics show up as Invalid.

 

How do I draw a chart/report showing all of the above items (I will add a date and location filter on top of the chart/report).

 

Kindly advise. 

 

 

 

Aggregate to Null results in invalid filter

Visitor ✭ ✭ ✭
# 2
Visitor ✭ ✭ ✭

Addendum

 

I am using mYSQL data source.

Aggregate to Null results in invalid filter

Visitor ✭ ✭ ✭
# 3
Visitor ✭ ✭ ✭

Since there are 5 locations, want 15 line charts (1 per country per column (ms))