When should you use a relationship instead of a join for two data sets?
When should you use a relationship instead of a join for two data sets?
You should use a relationship instead of a join for two data sets when the data sets include similar data aggregated at different levels of detail. Relationships are designed to handle multiple levels of data aggregation without losing or duplicating information. They allow for flexible combinations of data sources that maintain their native level of detail, making scenario C the correct choice.
C IS THE ANSWER
I think this is wrong
I thought the answer is A
Relationship combine multiple tables, not multiple sheets
Answer is C "You can see aggregations at the level of detail of the fields in your viz rather than having to think about the underlying joins." https://help.tableau.com/current/online/en-us/datasource_relationships_learnmorepage.htm
C. The data sets include similar data aggregated at different levels of detail.
The answer : C
From Tableau Help: During analysis, Tableau adjusts join types intelligently and preserves the native level of detail in your data. You can see aggregations at the level of detail of the fields in your viz rather than having to think about the underlying joins.