WebThat's why you can't do COUNTD on a secondary blended data source. (You need to get individual row access to evaluate DISTINCT functionality.) Two approaches to consider: … WebCOUNTD - Blended data Hi everyone, my first attempt to blend 2 data sets was not successful (Sheet called 1st attempt - attached), because its appears the following message "Cannot blend the secondary data source because one or more fields use an unsupported aggregation". Someone in the Community told me the following:

Data Blending Limitations in Tableau - Datameer

WebMar 29, 2024 · I have 2 published datasource and i think i cannot perform JOIN, LOD and COUNTD. I am using blending and created Relationship but i am having problem in terms of getting distinct count from one of the data sources. Let say from DS1 if i am making it as primary datasource then i can get the distinct count. WebError: Cannot blend the secondary data source because one or more fields use an unsupported aggregation I have a primary data source coming from a published data … pine clearance

How to handle "Cannot blend the secondary data source …

WebJan 11, 2024 · Blending isn't ideal in most cases but you could try it. Bring in each data source separately and "join" them within your workbook pane on Employee or hopefully an Employee_id. Click the little chain once you have them both loaded and you are on a worksheet tab. Then you could sum the counts by employee. WebThis works fine when there is no secondary data source but when I blend with a secondary data source it grays out my sheet i.e. unsupported aggregation.This calculated field is present in my primary data source. LOD Calculations Using Tableau Upvote Answer Share 10 answers 311 views WebCannot blend the secondary data source because one or more fields use an unsupported aggregation " but I resolved this error to get what I need. by "materializing" the field originally from the SECONDARY side data … top mold testing kits