Filtering multiple data tables with a single control

You can connect multiple data tables to one global filter as long as they share a common field you want to filter by. This means everything downstream including visuals and loco tables gets filtered by one control, rather than adding individual filters to each table. Let's walk through an example, using three data tables: Spotify Artists, Spotify Tracks, and Spotify Genres. These three data tables have a common field, which is Artist ID, which we want to filter by. Let's start by adding in a control cell. Here we'll go for a Multi Select, and we'll give it a name. Next, we want to select our base table. Note that even though we specify one data base table, we can connect multiple others to the same filter. So let's go down to automatic references to start doing that. First we'll add in Spotify genres and select artist ID, and then we'll add in Spotify tracks and select artist ID. So you can see here that even though our base table is Spotify artists, Spotify tracks and Spotify genres are also now connected. So let's select everything, and there we have it. One filter impacting multiple data sources at once. Everything downstream from each connected table will now respond to this single control, making it a really simple, fast way to filter.