For example, use ROUND(SUM(),1) instead of ROUND(,1). Some number functions can still be used if they include an additive aggregation. Non-additive aggregates from the secondary data source: Non-additive aggregates are only supported in the secondary data source if the linking field from the primary data source is included in the view and no non-aggregated dimensions from the secondary data source is included in the view. To work around this issue, consider creating an extract of your data source. Non-additive aggregates from the primary data source: Non-additive aggregates are only supported in the primary data source if the data in the data source comes from a relational database that allows the use of temporary tables. This error can occur for one of the following reasons: If you hover your mouse cursor over one of these invalid fields, you see the following error:Ĭannot blend the secondary data source because one or more fields use an unsupported aggregation. These limitations cause certain fields in the view to become invalid under certain circumstances. For more information, see Tableau Functions (by Category). All Number functions, except for MAX and MIN, are non-additive aggregates. Instead, the values have to be calculated individually. Non-additive aggregates are aggregate functions that produce results that cannot be aggregated along a dimension. Cannot blend the secondary data source because one or more fields use an unsupported aggregationĭata blending has some limitations regarding non-additive aggregates such as COUNTD, MEDIAN, and RAWSQLAGG. Though you can combine data in this way, Tableau recommends that you use a join or relationship to combine data from the same database instead, as they can leverage some of the database’s native optimizations in ways blending can’t. This warning occurs when the workbook contains separate data sources that connect to the same database. Joins can integrate data from many tables and may improve performance and filtering.

Instead of linking the connections, use the Data menu to join the data. The primary and secondary connections are from tables in the same data source. When you drag a field from a secondary data source to the view, you might see a warning that says: Primary and secondary connections are from tables in the same data source For more information, see Blend Your Data. Name, you must define a link between them. Tableau automatically linksįields that have the same name. You can make the link active by clicking a broken link icon ( )in the Data pane or by using the linking field from the primary data source in the view.ĭata source may not have any links to the primary data source. At least one of these fields must have the active link icon ( ) next to it in the secondary data source. Have no active links in the secondary data sourceįor example, suppose you have two data sources that are related by the State and Date fields. In the Data pane, switch to the data source, and click at least one link icon to blend these data sources. You drag a field from a secondary data source to the view, youįields cannot be used from the data source, because there is no blend relationship to the primary data source. Common warnings and errors when blending data sources No relationship to the primary data source

Perfect timing tune no limit 2