Numbers Showed as Repeating on Worksheet When Blending Data
Published: 14 Jul 2015 Last Modified Date: 20 Jul 2023
Issue
In a worksheet built with blended data, the measure values repeat the same value across a row or column; the data is not being populated from each data source.
For example, in a workbook that connects to Sample - Superstore as a primary data source and to Orders (Sample Superstore) as the secondary data source, the following weekly sales data per category will appear after editing the relationship only for the dimension called "Category".
Category
Week 1
Week 2
Week 3
Week 4
Furniture
209
209
209
209
Technology
116
116
116
116
Office Supplies
55
55
55
55
Environment
Tableau Desktop
Resolution
Ensure to "Edit the relationship" between the blended data sources that are required for the level of details of the view. For more information about editing relationship between data soures, see Blend Your Data.
In the same example, editing the "Category" and the "WEEK(Order Date)" relationship will resolve the issue.
Category
Week 1
Week 2
Week 3
Week 4
Furniture
50
45
55
59
Technology
16
60
30
10
Office Supplies
15
12
20
8
Cause
Data blending aggregates to the level of the linked field. Any data from the secondary data source will be limited to the level of detail that the links provide. Too many links can restrict the view to entirely null data, too few links can result in a higher level of aggregation than desired in the view.
Additional Information
The examples mentioned in this article can be found in the workbook attached to the right side of this page.
Thank you for providing your feedback on the effectiveness of the article.