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

How to add a filter with a column field from 2 different data sources - Please see description

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

I have 2 data sources (google sheet) and both the data has got a column name " Company"

 

I wanted to create 2 tables, 1 from first data source and 2 from second data source.

 

I wanted to add "company" as a filter and whenever I select a particular company name both the data should filter the data.

 

Please help.

1 ACCEPTED SOLUTION

Accepted Solutions
Marked as Best Answer.
Solution
Accepted by topic author Vibin V
June 2017

How to add a filter with a column field from 2 different data sources - Please see description

Visitor ✭ ✭ ✭
# 2
Visitor ✭ ✭ ✭

Hi,
u can't use 1 filter for 2 data sources, u need to create 2 filters for each data source to make it work.
There is no oportunity to join data sources.
However, u can create 1 datasource from that 2 u already have and use it in your report

View solution in original post

Marked as Best Answer.
Solution
Accepted by topic author Vibin V
June 2017

How to add a filter with a column field from 2 different data sources - Please see description

Visitor ✭ ✭ ✭
# 2
Visitor ✭ ✭ ✭

Hi,
u can't use 1 filter for 2 data sources, u need to create 2 filters for each data source to make it work.
There is no oportunity to join data sources.
However, u can create 1 datasource from that 2 u already have and use it in your report

How to add a filter with a column field from 2 different data sources - Please see description

Visitor ✭ ✭ ✭
# 3
Visitor ✭ ✭ ✭

Thanks Dmitriy!