You might remember how analysis suits together and you will just what inquiries we wish to respond to, in lieu of how to combine the data or compensate for artifacts regarding repository.

Instead, relationships are the the new, versatile means to fix offer investigation along with her away from multiple supply. The present strategies commonly disappearing, and generally are however helpful in particular scenarios.

• Relationships, region step 1: Introducing this new investigation acting within the Tableau (Hook reveals from inside the an alternative window)
• Relationships, region 2: Tips and tricks (Hook opens during the another window)
• Relationships, area step 3: Asking concerns across several associated dining tables (Connect opens up in a different sort of screen)

Have fun with Matchmaking

This subject walks compliment of building a related repository and using one for research. If you need to follow together, you could potentially down load brand new Bookshop research put (Link opens up when you look at the another type of windows) . Prefer Bookshop.xlsx towards raw studies to start out of abrasion, or MinimalBookshop.tdsx first off the fresh relevant repository basics designed to have you.

Video: Moved Analysis

For many who unlock a current workbook out of a past form of Tableau (version 2020.1 or earlier) within the Tableau 2020.dos or after, your computer data supply case you are going to let you know a great Migrated Studies desk.

Discover numerous films embedded inside material. For your convenience, a good transcript exists throughout the expandable part the lower for each and every movies.

For folks who discover a great workbook created before dating was in fact readily available (in advance of variation 2020.2), your data provider may look additional. In the event that there have been entered or unioned tables, they appear because one analytical dining table named Migrated Research. Double mouse click to see the underlying dining tables-these include still there, plus studies tend to nonetheless become expected.

Remember that when you are using only the fresh new Migrated Analysis desk, the info pane acts similar to previous versions away from Tableau Desktop computer.

After you’ve extra matchmaking for the investigation model, the information pane updates into the this new style, having dimensions and actions managed inside for each dining table, in addition to Migrated Studies desk was shown as just one, merged desk.

Video: Associate bu web sitesine geç dining tables

To create a data source out of related tables, connect with your computer data and drag a table on canvas. Drag out one minute dining table. A relationship have a tendency to automatically function whether or not it can. In the event that Tableau never position the brand new associated industries, you will be caused to pick her or him yourself.

The fresh canvas you happen to be seeing is actually a special layer of your investigation model where you can relate tables along with her. Dragging out most dining tables contributes them to the info model. The newest noodle reveals hence dining tables are related.

Relationships will be centered on calculated fields. It’s also possible to identify exactly how fields are going to be opposed by using workers after you determine the connection.

Include suits

You can create a jump on by double clicking on a table to open up brand new signup canvas (also known as the fresh actual coating), following dragging-out a desk to manufacture a hop on. Starting meets is similar experience as earlier incarnations away from Tableau-you can lay a hop on term, also a formula if necessary, and you will arrange the fresh new subscribe kind of.

After you close the latest join material, the fresh dining table on matchmaking fabric (also known as the newest analytical level) has a hop on symbol to indicate the root signup. For the reason that a hop on merges the dining tables together with her to make one, the fresh table. Related dining tables are still line of.

Include unions

Incorporate unions by the dragging out New Union. Unions, for example touches, in reality blend the information and knowledge, and feature an icon towards the logical coating. We advice constantly renaming unions-otherwise people tables which have unsure brands-so you’re able to anything a lot more useful.

Video: Overall performance Solutions

Your relationships, discover efficiency selection in addition to relevant sphere. Tableau immediately chooses secure defaults for those choices. not, while you are sure of the characteristics of your own studies, switching these selection can give Tableau addiitional information for you to ideal configure automatic touches through the research. Setting the newest cardinality and you may referential integrity possibilities gives Tableau more information for you to improve question.