KNOWLEDGE BASE

Error "Cannot blend the secondary data source because one or more fields use an unsupported aggregation" when Data Blending


Published: 13 Mar 2017
Last Modified Date: 21 May 2017

Issue

When working with data blending using non-additive aggregates such as COUNTD, MEDIAN, and RAWSQLAGG, you may see the following error message if you hover your mouse cursor over one of these fields: 
"Cannot blend the secondary data source because one or more fields use an unsupported aggregation"

Note: This error message can also appear when you use a level of detail expression in a view that uses data blending. The linking field in the primary data source must be in the blended view before you can use an LOD expression from the secondary data source. 

Environment

  • Tableau Desktop

Resolution

Use one of the following workarounds

  • If you need a non-additive aggregate on the primary data source, but your data source does not support temporary tables, consider creating an extract. Tableau data extracts support temporary tables.

  • If you are using a secondary dimension, try changing the dimension to an attribute instead. To do that, right-click the field in the view, and select Attribute.
    Important: Selecting Attribute might replace values with an asterisk (*). This indicates that there are multiple values in your data at this level of detail and Tableau can't determine which to display.

  • Using the Number of Records field might be an alternative to using COUNTD, depending on your data.
Note: These suggestions may not work if you explicitly added linking fields by clicking the link icon in the secondary dimensions window.

Alternative workaround

If a non-additive aggregation from the primary data source is in the view, you cannot use a group created in the primary data source in the view.

  • To work around this limitation, convert the group to a calculated field.

Non-additive aggregates are only supported for the primary data source, if that data source is a relational data source that allows the use of temporary tables. Non-additive aggregates are not supported for any secondary data sources.

Additional Information

Tableau Data Blending supports the following operations:

  • Filter on secondary dimensions fields
  • Use secondary dimensions in the view
  • Link data between two data sources using fields that are not in the view
Did this article resolve the issue?