Let’s go deeper and see what happens when we break the cardinality, or in other words, use it in a way it’s not designed for. Also, it helps to understand everything a bit better. For those looking for more of an introduction to performance, you...
Now, let’s look into the second part of the Performance Options: Referential Integrity. What a daunting phrase! Sounds scary, but it’s actually simpler than the Cardinality. With this option, we tell Tableau whether it should expect values to have a match in the other table or...
It may happen that we work with really big tables that are not just a few rows but millions or even billions of rows. Tableau’s VizQL’s SQL (what a beginning of a sentence!) has to query all these tables, and that takes time. When we...
From here on out (at least for a few posts), we will have a look into the Performance Options of Relationships that are shown when we design a relation between two tables. If you have no idea what I am talking about, chances are that...
The new data model brought us the Logical Layer, from which we can draw specific tables without being forced to load the data from all the related tables. Remember, with traditional joins, all sheets that worked with that join had to load the full data...
There are quite a few tips and tricks out there for Relationships in Tableau; just not nearly as many as for every other topic in Tableau, which is a shame. Nevertheless, this article is supposed to grow over time, and we start with something very...
Until Tableau version 2020.1, whenever we had two or more tables that we wanted to connect with each other, we had to either join them or blend them. If you aren't sure about joins, please take a minute and get yourself up to speed. We...
.mejs-container .mejs-controls { background:#f7f7f7 !important; } Relationships work on what Tableau calls the Logical Layer, while traditional joins work on the Physical Layer. Let’s have a look at what those two layers actually mean and why they have their names. [video width="1920" height="1080" mp4="https://interworks.com/wp-content/uploads/2022/07/Relationships_en_A1-1.mp4"][/video] Tableau's Physical Layer So, the Physical Layer...
Relationships in Tableau have grown older – it's been almost two years now when they started seeing the light of day. And still, even after all that time, there are many questions around this data model, be it within the Tableau Community, be it in...
Interworks GmbH
Ratinger Straße 9
40213 Düsseldorf
Germany
Geschäftsführer: Mel Stephenson
Kontaktaufnahme: markus@interworks.eu
Telefon: +49 (0)211 5408 5301
Amtsgericht Düsseldorf HRB 79752
UstldNr: DE 313 353 072