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
3.1K members online now
3.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))