[amount] into the view, it gives less than. " The only fields used in the view are the date fields, to which I did a . an aggregated left join where the aggregation of the secondary data cannot be used to increase the level of detail of the primary data. In the secondary data I have a LOD field called Total_Category_Response defined as { FIXED [Category]: SUM([Respose_ValI am working on a dashboard where I am using the data blending feature to visualize the data from different data sources in to a single view. In the attached file, table shows the sum of sales and first order date correctly from both the. good morning you have blended your data sources - data from the secondary source always comes to the primary and an aggregate so Budg_date needs to be aggregate with min max or attr but that will probably not give you the result you expect the data from the secondary source will come over as an * if there is more than one date filtered from that. 2, Tableau introduces relationships and splits. Currently, data sources that contain logical tables cannot be used as secondary data sources for data blending. I have 2 separate data sources that have similar fields. For example, select Analysis > Create Calculated Field, and in the Formula text box, type the. Instead, publish each data source separately (to the same server) and then blend the published data sources. blending [cannot blend Measure Values from a secondary data source] -----> this approach failed . All data from a secondary source comes back as an aggregate -- even if there is only one value from the secondary source. Hi there, I got a question about how can I count distinct customer ID? I have 10k customer IDs, some of them appear more than once. The success of BI projects depends on an organization's choice of BI solutions and the vendor’s ability to deliver relatively rapid and successful implementations, along with supportive. You combine data in the logical layer using relationships (or noodles). The problem I'm running into is when I use another data source as the primary source and attempt to bring over the LOD calculation from a secondary source. I have three different data source . Hi Data Modeler , I have an idea which I cannot test right away. A Level of Detail (LOD) expression is being taken from the secondary data source. Secondary data sources cannot have logical tables (except when they satisfy specific conditions). Before I check Date filters, I got this results. Data blending works only as a left join. Observations : 1. Because in Tableau, you don't use COUNTD function when Blending data source. COUNTD is not possible with Secondary datasource at Tableau (BLENDING) , below is one of the workaround that I would like to share (Maybe there are Many * Many ) I got one query at Tableau forum recently & below is based on the same . One approach that succeeds in adding another measure is to add the measure in question to your. if you have blended data sources you can not use lods One of the drawbacks of blended sources . Think of this layer as the Relationships canvas in the Data Source page. In the Data pane, select the Store - North data source. Loading. The default view that you first see in the Data Source page canvas is the logical layer of the data source. [Cash PTM]) Else [Null] ENDIn your example, this doesn't work, because your primary data source needs to be Master Store List, because you want to list all the store IDs. [Work Hours]) So you have to make. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. Open. No long-term contract. Another way to approach this is to do a join of the data outside Tableau via a federated data source. 3 and I have created aggregates AGG for fields from data extract and excel file. Some of the function doesn't work properly when we use blending like COUNTD(), LOD{} expression. I like to have the ability to swap a primary data source with a secondary data source for data blending in a workbook. then i added a secondary data source from google sheet , which has the fuel amount. ) If only one of the tables requires row level information, consider making that the primary data source in the blend (I. Note: If the geographic role does not exist in the primary data source, then it will be necessary to create the view with the data source that contains the geographic role as the primary data source. Secondary Data Source: Contains data relating to the usage of a website (hits). I am trying to use the below formula instead of countd function because my data comes from Impala. In second data source i don;t have salesrep column. Drag the State (group) dimension over the Region dimension on the Rows shelf to replace it. This happens only when the data sources are impala. I can add to filters from the data extracts. Step 3: Blend the fields with the target data source using simple blending method (clicking those broken links into red)Hi Saukarsha, The linking fields need to be somewhere on the view in order for the blend to work. The default view of Data Source canvas is the logical layer in Tableau version 2020. Make sure that you are blending on dimensions present in the view or on. To solve your issue you should ->go to Connections 2 , keep only facADP and remove all other relationships ->go to its physical layer (double click facADP)Two Data Sources A and B, one work sheet:W1 has used both this A and B to represent View. The data are sorted, but each row only shows one month of data with the other five columns blank. For example, COUNTD(). Tableau automatically adds an aggregation (SUM) around the column from the secondary source. E make table 2 the primary and table. e. Non-additive aggregates are aggregate functions that produce results that cannot be aggregated along a dimension. We would like to show you a description here but the site won’t allow us. - Dataset 1, records the amount spent on ads as "Cost". To fix this, we had to add the fields being used in the blending relationship onto the view: If attempting to use COUNTD in a secondary data source when blending, see the following additional workarounds: If Tableau Prep cannot be used, see: Getting around Count Distinct in a secondary data source (third party website) Creating a primary group: Bring a Field into the Primary Data Source in Tableau Help Sorted by: 2. Hi, Because we can't see the entire picture, no detail in the view of the connected data sources, the workbook, etc. Few things you need to keep in mind while blending data sources in tableau. " Filtering Across Multiple Data Sources Using a Parameter; Cause A sheet cannot be filtered by a field from a secondary data source. Marked as. I have two data sources which I have blended together on two fields: branch and date. Loading. Cannot blend the secondary data source because one or more fields use an unsupported aggregation . It also means you cannot create a workbook using the. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. I have my primary data source with dimensions customer and order no and a secondary data source with customer, postcode and an 'is vat exempt' boolean field. Please find the complete blog here ----> COUNTD with secondary DS Tableau(Blending) Workbook is attached. If multiple logical tables are related in a Tableau data source that source cannot be used as the secondary data source in a Tableau data blend, it can only be used as the primary Therefore one workaround is the Create Primary Group function that you described which "copies" the field from B into A as a group. Seemingly simple task is getting complicated in Tableau . Unfortunately can't share the data, and can't come up with a mock cause I can't figure out what's not/is working as expected. The unsupported aggregation happens when your aggregate requires row-level visibility to the secondary data source. I ended up purchasing an Alteryx license for our company (we now have a lot. I am confused, as I am not even trying to blend Data from both Data Sources. Data blending is a method for combining data from multiple sources. I have just realised why the blending was not working. The primary data source is just to filter for the invoices I want to look at. For more information, see Use Relationships for Multi-table Data Analysis. Option 2: Create a calculation for a more dynamic sort. In the Add/Edit User Mapping dialog crate, do the following: Select a select by the primary your data. The default view that you first see in the Data Source page canvas is the logical layer of the data source. Thank you. I want to display all values for all different data sources, and use them as filters, and filter the relevant records from both datasources at the same time. When I put category on either the row or column shelf I am getting the erro r "Cannot blend the secondary data source because one or more field use an unsupported aggregation". Now the nightmare starts: when I try to add the data source B and make all the relationships, it gives me the lovely error: "Cannot blend the secondary data source because one or more fields use the ZN function, which cannot be computed locally. This is a new complexity in Tableau v8: In v7 and earlier, to blend we had to have the linked dimensions in the view, i. I am trying to determine the Average Revenue per User by country for which my calculation is total revenue/unique subscribers. Hello Tableau world!! Am running into the strangest problem when data blending with V8. ×Sorry to interrupt. I have 2 duplicate data sources that I am blending together (they are duplicate because I want to filter the same data source 2 different ways but show it in. Remove all dimensions from the secondary data source and ensure that the primary data source’s linking field is in view. Fee". Use a parameter with a calculated field to filter the secondary data source at the row level. Data blending is a method for combining data from multiple sources. This feature would be really useful to ensure we can. Think of this layer as the Relationships canvas in the Data Source page. Current Year Actuals and Prior Year Actuals are housed in a corporate transnational data source. Nitish Pamarty (Member) 7 years ago. A COUNTD of Order ID should be all I need to show this data but it always results in a "Cannot blend the secondary data source because one or more of the fields use an unsupported aggregation". The unsupported aggregation happens when your aggregate requires row-level visibility to the secondary data source. Make the field(s) used to address the table calculation active linking fields. Selected as Best Selected as Best Upvote Upvoted Remove Upvote 1 upvote. The order in which fields are used determines which data source is the primary versus the secondary data source. T or F: Blends, unlike relationships or joins, never truly combine the data. Consider joining the two data sources together using Tableau Prep, and then you can use that data as a. 3. Use blends when:. Even if I don't join the 2 data sources and just blend them by "Region" and "Store Name", I still get "Cannot blend the secondary data source because one or more fields use an unsupported aggregation" on dragging Total Utilized Money field into the view. Cannot blend the secondary data source because one or more fields use an unsupported aggregation issue. Are you talking about Tableau Prep or Tableau Desktop? Any chance you can share a sample of your data? Expand Post. For more information, see Troubleshoot Data Blending; Blended data sources cannot be published as a unit. Data source filters. It throws me cannot blend secondary data source one or more becuase one or more fields use unsupported aggregation . When I create an additional calculated field in the primary data source with: COUNTD(Person ID) + COUNTD(Person ID), I receive the cannot blend the secondary data source because. The problem is when I try to calculate the median of that same measure. Error: 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 extract blending with a secondary data source coming from an Oracle Database. I've tried using COUNTD() ID First Last 1 Jim Carrey 1 Jim Carrey 2 Liam Neeson 3 Wynona Ryder COUNT([ID]) = 4 COUNTD([ID]). CSS ErrorI am trying to put my LOD calculation (below) on the rows shelf but encountering "cannot blend the secondary data source because one or more fields use an unsupported aggregation" {include [DATE. I was now trying to use both calculations you did on a different sheet through data blending. In the secondary data source, select Data > Create Calculated Field. Identify your data sources for common data types: both data sources must have a string or date field for linking data sources. The date values you want to blend on must exist in both data sources. Resolution. Hi All! I would like to ask for your help, I do have two data sources: BI Cube (primary source) & Excel file (secondary) BI Cube Data 1 pc. I am trying to create a waffle chart. ”. While on a view, right click a data source, click replace data source. I have two data sources to be used but need the count distinct of users from both the data sources. Best solution. This would be a great time saver, with all of the calculations and linking changing as well. And I want to add one of the field from secondary dataset to be in the filter. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. There is a possibility that the values can be restricted from the secondary data. The relationship is on the facility ID. In the actual data I get the error: Cannot blend the secondary data source because one or more fields use an unsupported aggregation. Trying to do a COUNTD() from a secondary data source and got this dreaded error: Cannot blend the secondary data source because one or more fields use an unsupported aggregation Did some research on this and found plenty of "workarounds" with no success, because apparently blending sucks and I shouldn't be using it. Loading. Primary Data source - Actuals ( day grain) Secondary data source - Goals (quarter grain) Calculated Measures: Primary Data source :- CustCount = CountD( Cust_ID ) Secondary Data source : %of Goal = CustCount/SUM([Goal])The physical layer of the Data Source page canvas is basically the "classic view" of the Data Source page in previous versions of Tableau. Data & Connectivity. cannot blend aggregated data from the secondary data source with data on this sheet. Cannot blend the secondary data source because one or more fields use an unsupported aggregation Did some research on this and found plenty of "workarounds" with no. You can create a federated database using linked tables/worksheets. It takes advantage of the data collected from previous research and uses it to carry out new research. Hi All, I have blended primary and secondary data sources. (It is a field that contains account names (company) in the sample data. newBranchProjection (Secondary) When I try to add COUNTD([DistrictId]) from my primary to text table. (to which I am blending data from other sources Name and Spend) and it worked! Observe the ordering of numbers in the last column between the. In my primary, I define another calculated field to do the aggregation for each project by tier: VendorClass: if max [Secondary]. Option 2: Create a calculation using WINDOW_SUM() Drag the linking field(s) from the secondary data source to. ” Causes and Workarounds for a Blending Limitation Errors 1. Status, Stage, etc). I am trying to blend the same data against the other because I wanted to show Same Period last Year. From what I can tell, joining on Tableau Server Data Sources has been a requested feature for 6 years (Idea: Ability to join Tableau Server data sources). cannot blend aggregated data from secondary data source. You are trying to bring fields from a second data source into a calculation that is being created in the primary (first) data source and aggregations are not consistent - data from the second source comes over as an aggregate - look into what the aggregation is on and how does that relate to what you have in the primary data baseI'm trying to blend two data sources on a single field, say 'Program Description'. I have two data sources which I have blended together on two fields: branch and date. please check the attached workbook. I am trying to . From what I understand, it's because the link variable must be present in the view, or else it does not work. You will need a common column between the two tables in order to blend. In addition, you cannot blend Measure Values from a secondary data-source, so that rules out this approach as well. Let say from DS1 if i am making it as primary datasource then i can get the. The secondary data source consists of 1 Fact table (Agg_ActualVsExpected) and 4 Dim tables, one of the Dim tables is Dim_Service, whose primary key is Service_Id, which appears also in the Fact table. Whichever data source is used first in the view, becomes the primary data source and the second one to be used in the view is the secondary data source. Data blending has some limitations regarding non-additive aggregates such as COUNTD, MEDIAN, and RAWSQLAGG. How to tackle “Cannot blend the secondary data source because one or more fields use an… How to tackle “Cannot blend the secondary data source because one or more fields use an unsupported aggregation” while blending Multiple data sources. This. Tableau v8 added a new style of data blending (DB2) where the linking field does not have to be in the view. These latter two situations trigger a different style of data blending (DB2) inside Tableau to ensure an accurate blend and that makes computation of non-additive aggregates much more difficult. A datetime field in the primary data source, for example, will not blend with a date field in the secondary data source. month([date])=month(Parameter. newBranchProjection (Secondary) When I try to add COUNTD([DistrictId]) from my primary to text table. CSS ErrorData blending is based on two key components- Primary data sources and Secondary data sources. 0, but I imagine someone has been able to identify what is causing the issue. Expand Post Using TableauThe secondary data source is indicated with an orange check mark on the data source and an orange bar down the side of the Data pane. Assuming that's what's going on, there's the question of how to work around this. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. A secondary data source can be used to re-alias the field values in a primary data source. 2 and later. General Information. The. When I make the data source as Primary, I am able to see the respective values, Kindly see the below screenshot:- But, when I consider this data source as secondary and then try to use it in primary data source sheet, I get this error:- Cannot blend the secondary data source because one or more fields use an unsupported aggregation. So the only way, it was possible was to connect one of the data sources with a calendar table joined with previous year and then blend it against the same data to get the Current Year and Same Period Last Year values in a single view. In this source create a calculated field to pull out the KMs on the date of oil change. According to Tableau, this error can also appear when using a LOD expression in a blended view. Hi. I made a waffle chart grid using an excel data source that contains 3 fields: Rows, Columns and Percentage. Cannot blend the secondary data source since one or more search use certain unsupported aggregation. Last week I’d promised to explain why the solution for identifying whether All items in a Tableau Quick Filter were selected wouldn’t work under certain circumstances in Tableau version 8, here it. And I use Join data source, after divide measures / row duplicate. In the secondary (user rights sheet), create a "Verify Username" calculation that has the fmula:. This is interesting. Error: Cannot Blend the secondary data source because one or more fields use an unsupported aggregation. Common Issue #1: Cannot blend the secondary data source because one or more fields use an unsupported aggregation The aggregation methods of COUNTD,. I. Beyond that personally I tend to do the work necessary to avoid using data blending in production data sources & views. In the Relationships dialog box, under Secondary data source select Custom, and then click Add. Resolution. From my primary data source I have a dimension in columns say 'Customer Segment'. If that does not help,. Overall LOD will show correct result in Primary datasource. Thanks for your help everyone! I've found what was happening: I had some filters on the secondary data source. ×Sorry to interrupt. Data. Data blending is a method for combining data from multiple sources. However, it gives me following error: "Cannot blend the secondary data source because one or more fields use an unsupported aggregation"We have an enterprise data source that is an SSAS Tabular model. Applies to: Tableau Cloud, Tableau Desktop, Tableau Server Data blending is a method for combining data from multiple sources. targets. cannot blend secondary data source because one or more fields use an unsupported aggregation beacuse of LOD. Case 2: If you are done with the dashboard development then create a empty extract and publish it on server and run the refresh so that data gets loaded. Click oLoading. Upvote Upvoted Remove Upvote Reply. The first field you drop onto a worksheet defines the primary datasource. e. But I cant add filter Month from the Budget Excel file. 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". ODBC is a pretty universal technology for doing this, you can find more by doing a web search on "linked tables" or "linked worksheets" for your specific data sources. So you need to create a Date field in your Master Data Source, which is why I usedAlternative to CountD function in Blending. To reduce query times when working with a large data source like Store - South, you can use data blending to blend only on the summary data of the large secondary data source (Store - South) with the data in the smaller and presumably faster primary data source (Store - North). I use the Opp ID to relate them. Proj. Also I see that if you put [Corrected Date] from the primary source instead of the secondary source, it behaves with the group (and the calc. id, A. Here is an example of what I am trying to accomplish:Data blending is a method for combining data from multiple sources. Owing to this, only those fields in the secondary data source which bear corresponding matches with the primary data source appear in the visualization pane. Relationships cannot be formed between tables from data sources published to Tableau Server or Tableau Online. I have two data sources and I have blended them together. It sounds like there might be some complications with a blend? Can’t speak to what’s happening thereAre you blending on [Endtimestamp]? By using the formula DAY([Endtimestamp]), you're changing the dimensionality a little bit. xls files). Even if I don't join the 2 data sources and just blend them by "Region" and "Store Name", I still get "Cannot blend the secondary data source because one or more fields use an unsupported aggregation" on dragging Total Utilized Money field into the view. additionally, data coming from the secondary source are always aggregated at the level of the link when brought to the primary source - the individual records are no longer available and you are not able to filter across the various data sources at that point - that is the long way of saying you will have to join or use a. Show moreA workbook or mock data would be a sure thing to comment and try upon it. Secondary Data Source: Extract W. Can't see what you are actually doing but Blending data has its limits. {FIXED [Machine Nr] : COUNT ( [Machine Nr] )} / {FIXED [Machine Nr] : COUNT ( [Machine Nr] )} This works fine when there is no secondary data source but when I blend with a secondary data source it grays. As it turns out, I didn't actually end up using an LOD, but thought I might have to, hence the reason for JOINING the data together as shown in. The blend is not activated meaning a field from secondary DS is not used in the view. SandhyaData from the secondary data source (via a data blend) can never be a dimension. But when I am trying to do that I am getting an errorThe issue comes when I try and add a metric that is an aggregate of the two different sources. For example, sheet A uses data source 1 as the primary data source; sheet B uses data source 1 as the secondary data source. If you make sheet 1 as the primary data source and do the data blending with sheet 2. "cannot blend the secondary data source because one or more fields use an unsupported aggregation" Attached is the workbook that could provide more clarity on my question. We cannot publish a blended data source as a single data source on the server. In this source create a calculated field to pull out the KMs on the date of oil change. Place Organisation Identifier on the level of detail shelf (from the primary source, or both sources) and the blend should work. If you want to filter data across secondary data sources, consider the following alternatives: Join tables that are in the same data source, instead of blending them. Primary Source: Payment details (to get customer ID and revenue) Secondary Source: Customer details (to get customer country) from this data source i get the sum of basic salary. Hi Andy, Following up on this - Tableau has been promoting the jump to relationships, in place of joins. 2) Use data source filters instead of the Filters Shelf. Common field is the employee ID. They both share a common field (State), and that is what I'm filtering on. CSS ErrorTo reduce query times when working with a large data source like Store - South, you can use data blending to blend only on the summary data of the large secondary data source (Store - South) with the data in the smaller and presumably faster primary data source (Store - North). Chicken - VMBurger + Choice of DrinkBurger - VMSpaghetti + Choice of DrinkSpaghetti - VM Trying to do a COUNTD() from a secondary data source and got this dreaded error: > Cannot blend the secondary data source because one or more fields use an unsupported aggregation . the branch field I'm using from the primary data source. Error: "data sources that contain logical tables cannot be used as secondary data sources for blending" I have two fact based data marts that I want to blend on a combination of dimensions (product, month, currency). I get a blank sheet on the dashboard using the secondary data source because it looks for CASE SENSITIVE ABC . It is important to understand which is the primary source, it can impact. The two data sources are identical. Select Default Properties > Sort. If there is another aggregation type such as AGG_AVG being used, change it to one of the supported aggregation listed above in the cube database itself before using in Tableau Desktop. IF min([Current Period ]) = true then [Display Sum Media Cost] end / sum(IF [Current Period ] = true then. It would be nice if when you blend two data sources, you could have the option to show "Only Relevant Values" on filters used from the secondary data source. Did some research on this and found plenty of "workarounds" with no success (like replacing COUNTD() with a LoD using AVG(# of Records)) Workaround: Option 1: Instead of using Data Blend, please use Relationship to relate the data sources, and the "Only relevant values" option is available to show only existing values. When on the dashboard, click on the ‘Dashboard’ drop-down and select ‘Actions’. "Cannot blend data from the secondary data source with the data on this sheet because there are no linking fields used in the view" Expand Post. Chicken + Choice of DrinkBurger + Choice of DrinkSpaghetti + Choice of Drink . [OIL DATE]) THEN MIN ( [KMs]) END. I am trying to use the below formula instead of countd function because my data comes from Impala. The Products set contain the individual products within an Opportunity whereas the Opportunities set contain Sales metrics (i. Pick the secondary data source in of Secondary data source pane. This means that it forces the view to display only relevant data in the secondary data source. Upvote Upvoted Remove Upvote Reply. In the Data window, right-click the relevant field. Tableau has two inbuilt data sources named Sample-superstore and Sample coffee chain. Filtering data across a worksheet's secondary data source is not currently supported in Tableau Desktop. Does the. Upvote. LOD (exclude) - Filtering using a different data source I've used LOD (exclude) to create a % of total calc field (and then created a moving average off that). In this case the cross. Answer. CSS ErrorIF user chooses month X and parameters/filters like gender/age/etc, THEN count all distinct users from data set #2 where the date of data set #2 is from 2017-08-01 through today's date. LOD Expressions will not be shown in the Data Source; When referencing a dimensionality declaration parameter, always use the parameter name and not the parameter value; With data blending, the primary data source's linking field must be in the view before you can use a LOD expression from the secondary data source. if that is the case I could get same results by joining 2 data sources just by linking Area and Qtr not all 4 and without using LOD for secondary data source i. I'm trying to blend two data sources on a single field, say 'Program Description'. Resolution. Next, create a table calc using the [Start KM] to calculate the total KMs:Error: Cannot blend the secondary data source because one or more fields use an unsupported aggregation. Common Issue #1: Cannot blend the secondary data source because one or more fields use an unsupported aggregation The aggregation methods of COUNTD, MEDIAN, and other non-additive aggregate functions can cause fields to become invalid. Now, in dashboard D1 : has two worksheets W1 and W2. Data blending brings in additional information from a secondary data source and displays it with data from the primary data source directly in the view. " inner cross database join on BU Code with a data source filter set up on UPPER([ID])=UPPER(USERNAME()) on the DS2 source. Data blend is like a Left outer join. 2) DB2 blending doesn't support non-additive aggregates like COUNTD() from secondary sources. Here are the 7 major steps for putting this together: Set up your primary (main) and secondary (parameter) data sources. According to Tableau, this error can also appear when using a LOD expression in a blended view. See Join your Data for instructions. I need to get a count distinct of Patient ID from the Primary data source, as well as count distinct of Patient ID from the Secondary data source in one worksheet. Relationships: Join: Combines columns: Yes: Cross database joins will not work with all data sources: Joins: Blend: Combines columns: No: Fields from the secondary data source cannot be brought in to the view unless there is a match on. For more information, see Use Relationships for Multi-table Data Analysis. Verify if one of the measures coming from the cube data source has a default aggregation different than SUM, MIN, MAX, COUNT. Marked as. Therefore it cannot display null data. If attempting to use COUNTD in a secondary data source when blending, see the following additional workarounds: If Tableau Prep cannot be used, see: Getting. In your 2nd and 3rd data sources. Unknown file type Total from Secondary Data Source. CSS Errorthe message says that a Logical table can not be used as a secondary source - You are trying to blend data (or at least tableau thinks you are) try reverting the data connection to a Physical model to JOIN the files together on the company name - JimThe secondary data source hasn't been changed and the groups work as filters. month([date])=month(Parameter. Loading. "Budget" is only contained in an Excel file data source. Each has a joining field with the same name. To blend on summary data, you can do the following: Create a. Cannot blend the secondary data source because one or more fields use an unsupported aggregation" when Data Blending. ) A LOD calc is also trying to do stuff at the row level. Fee" I want to plot Gross Profit (i. If there is another. . Another way to approach this is to do a join of the data outside Tableau via a federated data source. I get error: “Cannot blend the secondary data source because one or more fields use an unsupported aggregation. This type of bases does not allow for blend relationship, therefore, you cannot use a filter like this. Data > Edit Relationships . and tried to plot chart, the chart complains that "Data sources that contain logical tables cannot be used as secondary data sources for data binding". Blending runs a query on each data source and joins the aggregated results of those queries. With the release of Tableau 8. E make table 2 the primary. Option 2: Create a calculation for a more dynamic sort. To the Data pane, umschaltung in this [name of secondary data source] data source, real click at lowest one link icon to blend that data sources. FIXED requires that you have row-level access to the rows in the secondary source. 1 because it can cause Tableau to unexpectedly quit. All three options are demonstrated in the attached workbook using the sample data set Superstore. In this case the cross database join will effectively act like the. However, if you do a full outer join on [Dimension] = [Dimension] then we can know which records match up, and do a calculation like:I like to have the ability to swap a primary data source with a secondary data source for data blending in a workbook. When I do the join between the SSAS Tabular Model (primary data. Ambiente. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. During Data Blending in Tableau, if the secondary data source has any LOD (Level of Detail) Expressions, they are taken down after the data blending process is finished. Next, drag Category from the Orders data source onto the view, then select the Orders data source and click the chain icon to blend on Order ID. If one of those measures is brought into a view with a linking dimension not in the view, or a linking dimension is turned on that is not in the view, the pill will turn red, the view will turn grey, and hovering over the pill reveals a "Cannot blend the secondary data source because one or more fields use an unsupported aggregation. Fields cannot be used from the [name of secondary data source] data source, because there is no blend relationship to the primary data source. Expand Post. To overcome this, I've added a filter straight into the data source and not in the view. We have a calculated filed where an aggregation (COUNTD) is done on a filed of secondary data source. 4. Resolution. For more information, see Troubleshoot Data Blending; Blended data sources cannot be published as a unit. Data blending is particularly useful when the blend relationship—the linking fields—need to vary on a sheet-by-sheet. As you can see I have 2 different data sources using a blend on the blood type. Status, Stage, etc). Blending requires primary and secondary data sources. When trying to use COUNTD() it gives this error: cannot blend secondary data source because one or more fields use an unsupported aggregation when hovering over the Measures because it is now red. I can't do a join because they are two different file formats. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. ×Sorry to interrupt. Set up the primary and. I am using tableau 2020. I am confused, as I am not even trying to blend Data from both Data Sources. This means a data blend can’t be published as a data source for others to use. Tableau will throw an error: “Cannot blend the secondary data source because one or more fields use an unsupported aggregation. The aggregation is all on primary source data. Blending from a polygon-based map to an existing data source which uses 1-to-many joins. From what I understand, it's because the link variable must be present in the view, or else it does not work. I have three different data source . I've tried using COUNTD() ID First Last 1 Jim Carrey 1 Jim Carrey 2 Liam Neeson 3 Wynona Ryder COUNT([ID]) = 4 COUNTD([ID]) results in error I can add to filters from the data extracts. Expand Post. the count of claims I'm getting from the secondary data source, by counting distinctly a measure called claimid. Please post you twbx workbook so we can see if there a way . The concept of data blending is, for every match in the primary table there should be exactly one row item in your secondary table, in the view of this concept any aggregation on the secondary table will always be distinct by default. Data of any sort coming from a secondary source must come as an aggregate of some sort. png - Ben-Sullins's library "Cannot blend the secondary data source because one or more fields use an unsupported. In the Data pane, select the State data source (secondary). Create a “Blend Field” with a value of 1 in both your primary and secondary. This is indicated by the following icon: The view you are trying to build will function if you use the date from the primary data source (Shipped): Let us know if this is clear, or if more explanation is required! Cheers, TimothyCube data sources are used as primary data sources to blend data in Tableau and cannot be used as secondary data sources. "cannot blend the secondary data source because one or more fields use an unsupported aggregation" Attached is the workbook that could provide more clarity on my question. For example, when I try and pull in Cost per Order (cost coming from one source, and Orders coming from another) I get the "Cannot blend the secondary data source because one or more fields use and unsupported aggregation.