In the previous lessons we learned about parameters and how to use them in Looker Studio.
In this chapter we will talk about Advanced Control and Parameters.
In particular, we will discuss:
We will also cover Chart Interactions, Metric Sliders, Optional Metrics, Dimension Drill Down, and lastly, Custom Link Navigation using Hyperlink function in Looker Studio.
In this lesson, we'll discuss a limitation in Looker Studio: filtering across different data sources. Most of our discussions have focused on what you can do in Looker Studio, but it's essential to be aware of its limitations.
Filtering in Looker Studio works only across data sources of the same type, meaning those created by the same data connector. For example, if you have two different Google Analytics data sources from two different domains, they can be filtered together since they were both created using the same connector.
Suppose you have four data sources: two Google Analytics data sources, a Google Sheet, and a Google Ads source. All of them have a field called "country" (or something similar like "country/territory"). As humans, we understand that these fields represent the same information. However, controls in Looker Studio cannot filter charts based on different data source types.
Imagine a control (in yellow) that's connected to a Google Analytics data source. If you filter by "United States," the charts based on Google Analytics data sources will refresh to display data only from the United States. However, the charts based on the Google Sheet and Google Ads data sources will not change. They cannot be cross-filtered since they come from different data connectors.