KNOWLEDGE BASE

Numbers Showed as Repeating on Worksheet When Blending Data


Published: 14 Jul 2015
Last Modified Date: 25 Oct 2016

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".
 
CategoryWeek 1Week 2Week 3Week 4
Furniture209209209209
Technology116116116116
Office Supplies55555555

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. 
 
CategoryWeek 1Week 2Week 3Week 4
Furniture50455559
Technology16603010
Office Supplies1512208

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.
Did this article resolve the issue?