-
Book Overview & Buying
-
Table Of Contents
Tableau Cookbook for Experienced Professionals
By :
In many scenarios, when creating relationships between tables, you’ll not need to do anything other than specify the related fields between them. This will guarantee you get meaningful results and, in general, a good performance.
Sometimes, with complex data models with a lot of different tables or big datasets and complex relationships, you might want to adjust how the tables are related to let Tableau know specifically how to perform those relationships and improve query performance and overall speed.
Tableau allows us to do this by manually setting the cardinality and referential integrity of each table in a relationship. It is important to keep in mind that setting these options incorrectly can also translate into wrong results during your analysis.
A best practice is to only adjust the following settings when you have a deep understanding of your data, especially of the fields you are using to relate your tables.