Hi,
I have a dashboard with 2 charts showing data from different sources (both are google sheets). How can I create dropdown controls that would filter both tables?
As a simplified example;
My first data source has the columns “date”, “city” and “degree” and all three columns are used in a Looker Studio dashboard table.
My seond data source has the colums “date”, “city” and “hobby” and all three columns are also used to create a separate table in the same dasboard.
In addtion to these 2 tables I want to have 2 drop down filters for “date” and “city”. These drop down should show all available options from both data sources ie even if a “date” (or “city) appears in only one of the sources, the drop down should show all dates (or cities) from both sources.
When the drop down filter is applied, only those records with matching “dates” (or “cities”) should be showing in both tables.
Has anyone had success in creating this kind of set up?
Thanks.