Unable to Link Matching Values from Different Dimensions
Published: 01 Dec 2016
Last Modified Date: 20 Jun 2017
IssueYou are unable to link matching values from different dimensions.
For example, the underlying data may contain the fields [Origin], [Destination], [Origin Amount], and [Destination Amount]. The goal would be to show list of all places with their associated values of [Origin Amount] and [Destination Amount]. The issue is that [Destination Amount] is not associated with a place but with a specific value of [Origin] and the value of [Destination] on the same row.
Option 1: Pivot the data
Using the above example, the underlying data should have the fields: [Place Name], [Origin or Destination], and [Amount].
For some data sources it may be possible to pivot the data in Tableau Desktop. See the following entry in Tableau Help for more details: Pivot Data from Columns to Rows.
Option 2: Blend in a duplicate of the data source
- Navigate to Data > Sheet1 (Sample) > Duplicate
- Navigate to Data > Edit Relationships…
- In the Relationships dialog, do the following and click OK:
- Select Custom
- Remove all existing relationships
- Add a relationship for Origin =Destination
- Use fields with values relating to the origin, such as [Origin Amount] from the primary data source, and fields relating to the destination from the secondary data source.