Cannot blend the secondary data source because one or more fields use the == function, which cannot be computed locally. Tableau Desktop & Web Authoring. General Information. 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. You can also define the relationship manually by right-clicking on the data source name in the Data pane, and selecting Relationships. Blending requires primary and secondary data sources. when I use A as primary data source and drag A. Blending your Data in Tableau. The limitation with Tableau and secondary data sources stinks. For more information, see Use Relationships for Multi-table Data Analysis. E make table 2 the primary. A data blend cannot filter on dimensions that do not exist in the Primary data source. Data blending is particularly useful when the blend relationship—the linking fields—need to vary on a sheet-by-sheet. order_date. I have two data sources which I have blended together on two fields: branch and date. Beginning with Tableau Desktop 2020. You want to apply a filter to related data sources - which is an option if multiple data sources have a field with the same name and data type, or if you define explicit relationships between data sources from the Data menu. cannot blend aggregated data from secondary data source. If you create a quick filter on a field from data source 1 and apply this. Option 2: Join tables that are in the same data source, instead of blending them. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. From Primary Data Source drag the measure names and measure values . General Information. Some examples include: cookies used to. In this case, I use Last() as a filter to hide the other rows except the last one and each LOD calculation and blended data sources. From my primary data source I have a measure in rows, say 'Measure, which is 'distinct count of Pol Number' or 'sum of Premium' depending on a boolean parameter's values (TRUE or FALSE) The unsupported aggregation happens when your aggregate requires row-level visibility to the secondary data source. An orange tick indicates a secondary data source (Promotions). When you drag a field from a secondary data source to the view, you might see a warning that says: Fields cannot be used from the [name of secondary data source] data source, because there is no blend relationship to the primary data source. Russell Christopher (Member) 10 years ago. THEN add this total to the SUM of the projected_users from today's date through month X. Upvote Upvoted Remove Upvote Reply. Complex as the problem may be, the solution is comfortingly simple. When I do the join between the SSAS Tabular Model (primary data. Additional Information While replacing ATTR() with MIN() will cause "Automatic" grand totals to show, the grand totals might not be the expected values. Data source filters. Instead of using relationships, double-click into your table to get to the. 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. So, basically, I am having issues with 2 calculations - the FIXED LOD and Remaining Value. The data source with the KMs is the primary source. Hello Everyone, I am using one data source which is a LIVE connection and I have duplicated same data source , the reason behind duplication is i want to have total of category which will be constant and it will not. I cannot change the case of the data to upper or lower. png - Ben-Sullins's library "Cannot blend the secondary data source because one or more fields use an unsupported. newBranchProjection (Secondary) When I try to add COUNTD([DistrictId]) from my primary to text table. 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. From what I understand, it's because the link variable must be present in the view, or else it does not work. Go to Data menu on top and go to Edit Relationships (Data -> Edit Relationships) Create a custom relationship between the 2 new created in 2nd and 3rd source. To overcome this, I've added a filter straight into the data source and not in the view. Change the default sort order of the field using the various options, and then click OK. As 'Group' is from a secondary data source, I cannot simply use the sort buttons. The value gets reduced based on filters@@@ from all data source. In the data window, switch to [name1] data source, and click at least one link icon to blend these data sources. 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. Error: Cannot Blend the secondary data source because one or more fields use an unsupported aggregation. 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. Thanks for your help everyone! I've found what was happening: I had some filters on the secondary data source. Create a “Blend Field” with a value of 1 in both your primary and secondary. You can choose whether functional and advertising cookies apply. Regards. Marked as. e. Some examples include: session cookies needed to transmit the website, authentication cookies, and security cookies. COUNTD - Blended data. 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. Secondary Data Source: Contains data relating to the usage of a website (hits). i will try to build some moke up data in excel and reproduce the same but before that could you please explain me in detail what calculation i need to perform in secondary source. Chicken + Choice of DrinkBurger + Choice of DrinkSpaghetti + Choice of Drink . In the attached file, table shows the sum of sales and first order date correctly from both the. To fix this, we had to add the fields being used in the blending relationship onto the view: Aside from a few of these, we didn’t need to combine the data in very complicated ways. Observations : 1. Try one of the following options, as appropriate for your workbook: It may be possible to cross database join instead of blending. This is the response I received from Tableau Support:Cause. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. I use the Opp ID to relate them. I have a calculated field in the Excel data source that returns a binary 1 if the username matches the list in Excel for the facility ID and a 0. Data blending works only as a left join. Select Default Properties > Sort. Please find the complete blog here ----> COUNTD with secondary DS Tableau(Blending) Workbook is attached. Are use of grouped fields not allowed in data blending? I have two data sources: Opportunities and Products. 2)Count Distinct from Secondary workaround. ×Sorry to interrupt. Here's the data blend view with the secondary data source selected so we can see what blend fields are used:. Data blending is particularly useful when the blend relationship—the linking fields—need to vary on a sheet-by-sheet. AUMTable (Secondary) 3. BR, NBBlended data sources cannot be published as a unit. 1) Vizible Difference: Getting around Count Distinct in a secondary data source. Filtering data across a worksheet's secondary data source is not currently supported in Tableau Desktop. the blended data cannot be published to Tableau Online or Tableau Server. I am creating a couple of formulas to display the total booking from the second data source to the first data source. This type of bases does not allow for blend relationship, therefore, you cannot use a filter like this. I noticed that when the spatial file is the secondary data source, I cannot area plot it by double clicking the geometry variable. 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. The unsupported aggregation happens when your aggregate requires row-level visibility to the secondary data source. Data blending tools can present their findings as visualizations, such as infographics and charts, after querying data sources and aggregating relevant information. The Products set contain the individual products within an Opportunity whereas the Opportunities set contain Sales metrics (i. 1, the ability to "Show Empty Rows" (or columns) was removed when you use a secondary data source. What steps do I need to do to do this?It shows the next message: "Cannot blend the secondary data source because one or more fields use an unsupported aggregation". " Filtering Across Multiple Data Sources Using a Parameter; Cause A sheet cannot be filtered by a field from a secondary data source. Identify your data sources for common data types: both data sources must have a string or date field for linking data sources. I get error: “Cannot blend the secondary data source because one or more fields use an unsupported aggregation. Primary and Secondary sources in data blending. I was now trying to use both calculations you did on a different sheet through data blending. Loading. " And after that I can't make my workbook work at all. Cannot blend the secondary data source because one or more fields use an unsupported aggregation" when Data Blending. Option 2: Join tables that are in the same data source, instead of blending them. I have some extra supplemental data in a CSV file that I would like to join to one of the common fields between the two so I can pull some of the SSAS measures by the supplemental data's dimensions that I've blended. Tableau automatically adds an aggregation (SUM) around the column from the secondary source. newBranchProjection (Secondary) When I try to add COUNTD([DistrictId]) from my primary to text table. I am just trying to filter every Data source, by choosing a field that every Data source has. Call it [Start KM]: IF ATTR ( [KM Date])=ATTR ( [OIL]. The secondary data source need to be my transaction file and primary data source need to be my budget file. Data blending have some limitations regarding non-additive total such like COUNTD, MEDIAN, and RAWSQLAGG. I receive this error: "Cannot blend the data source because one or more fields uses an unsupported aggregation". Currently, data sources that contain logical tables cannot be used as secondary data sources for data blending. . 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. ×Sorry to interrupt. Calculates the number of distinct values of a field within a partition. LOD calculation and blended data sources. The date values must be in the same format. Just aggregates (like SUM, MIN, MAX. Hi . In Tableau Desktop, navigate to Data > Edit Relationships. This is interesting. * Supplemental data from a secondary data source is needed. Tableau v8 added a new style of data blending (DB2) where the linking field does not have to be in the view. I have two data sources and doing a data blend. Filter each of the data sources independently on the more granular dimensions. [tier] == 2 'Top Vendors' else 'Mid Vendors'. What I'm trying to do is, create a new column in the 'data to map to' table, saying I only want to see 'PY Sales' numbers where the 'Period' column is equal to the MAXIMUM of 'Sales Cycle' column from 'Data to Map from' table, which is from. This happens regardless if I drag it on the rows or on the Marks space as a 'text'. 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. 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. 3 and I have created aggregates AGG for fields from data extract and excel file. I am using tableau 2020. Notice that Calc1 gives you an asterisk if there are multiple values returned from the secondary source. the branch field I'm using from the primary data source. Cannot blend the secondary data source because one or more fields use an unsupported aggregation issue. This feature would be really useful to ensure we can. Step 1: Create the Parameter. It takes advantage of the data collected from previous research and uses it to carry out new research. Then, after data blending, the final graph cannot show the data related to the South and East. 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). . Using existing secondary data sources can save researchers time and resources by providing access to pre-existing data that has already been collected and organized. Currently, data sources that contain logical tables cannot be used as secondary data sources for data blending. ” Causes and Workarounds for a Blending Limitation Errors 1. The order in which fields are used determines which data source is the primary versus the secondary data source. The data source with the KMs is the primary source. In this case the cross. 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". Upvote Upvoted Remove Upvote Reply. Better collaboration. I have two data sets: the first data set is a shp file from data. Also, after I get the total per PO Number, I want to get a remaining value that subtracts the Total Cost (from the secondary data source) from the Total per PO Number. 1. Applies to: Tableau Cloud, Tableau Desktop, Tableau Server Data blending is a method for combining data from multiple sources. If this aggregation is ATTR() then the grand totals may be blank. In the Data pane, switch to the [name of secondary data source] data source, and click at least one link icon to blend these data sources. In the Data pane, switch to the [name of secondary data source] data source, and click at least one link icon to blend these data. Common field is the employee ID. 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. In a blend, the secondary data source can only contribute aggregated values using the level of detail defined by the linking fields that appear in the view, so when you remove them, the. Hope this helps kindly mark this answer as correct or helpful so that it will help others . In the secondary data source, select Data > Create Calculated Field. g. See Join Your Data for more information. " inner cross database join on BU Code with a data source filter set up on UPPER([ID])=UPPER(USERNAME()) on the DS2 source. While on a view, right click a data source, click replace data source. You have a nice example to use for filing a support case, and I recommend that you do that. 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. Hi All, Is there a way to use a parameter to work for secondary data source in blending. please check the attached workbook. The version I am working with 10. twbx. Expand Post. Cannot blend the secondary data source because one or more fields use an unsupported aggregation It’s cable reimagined No DVR space limits. See the attached updated workbook. Currently, I have to rebuild the worksheet and bring in the secondary source first. month([date])=month(Parameter. Functional cookies enhance functions, performance, and services on the website. After blending, CountD works fine on primary datasource, but when I try to use CountD on secondary datasource tableau gives error: "Cannot blend secondary data source as one or more fields use an unsupported aggregation". It does exactly what I need and I'm able to filter no problem at all using a different data source when working to a financial period level. So if you drag Category from the Orders data source, it will automatically mark Orders as the primary data source. Community Manager update. I establish the blend relationships explicitly by going to Data -->Edit Blend Relationships, and selecting the fields that should be related. However, I still get that message saying cannot blend the secondary data source because one or more fields use an unsupported aggregation". targets. What does this mean? I want to create a city filter and apply it both to the SAS data source as well as the pivoted CSV file. A secondary data source can be used to re-alias the field values in a primary data source. How ever # no of changes and # of Problems are calculating entire database values. Data blending is particularly useful when the blend relationship—the linking fields—need to vary on a sheet-by-sheet. “Cannot blend the secondary data source because one or more fields use an unsupported aggregation. Show moreA workbook or mock data would be a sure thing to comment and try upon it. See. Cannot blend the secondary data source because one or more fields use an unsupported aggregation . It is important to understand which is the primary source, it can impact. The default view that you first see in the Data Source page canvas is the logical layer of the data source. blending takes place in step 6 of the Order of Operation after all the context and dimension filters have been applied - you will not be able to filter across the data sets after that point - you would need to have joined data or use a relationship The issue comes when I try and add a metric that is an aggregate of the two different sources. Next, create a table calc using the [Start KM] to calculate the total KMs: from Primary data source from Secondary data source. It has data from 2003-2012. " Expand Post. Right-click in the Data window and then. ” Causes and Workarounds for a Blending Limitation Errors. The default view that you first see in the Data Source page canvas is the logical layer of the data source. Data blend is like a Left outer join. [OIL DATE]) THEN MIN ( [KMs]) END. Chicken + Choice of Drink1 pc. 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. Mihai Constantinescu (Member) 6 years ago. Secondary data source: (excel) master zip file with ~40k rows (all US zips) - each zip is tied to a territory I am looking to add the territories from the master zip to territory file as a filter. 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. 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. Drag the State (group) dimension over the Region dimension on the Rows shelf to replace it. 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. Place Organisation Identifier on the level of detail shelf (from the primary source, or both sources) and the blend should work. 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. When blending in Tableau, there is always a primary source and a secondary data source. I have two data sets that are linked across Date and Product Category fields. Proj. 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. 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. 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. [Work Hours]) So you have to make. 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). So you need to create a Date field in your Master Data Source, which is why I usedAlternative to CountD function in Blending. 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. With the release of Tableau 8. Because data blending is an ad-hoc LEFT join that aggregates data from the secondary data source, Tableau cannot always perform aggregations that require the full domain. FIXED requires that you have row-level access to the rows in the secondary source. One on table it was all upper case on the other one it was a mix of upper and lower case. month([date])=month(Parameter. Both Primary and Secondary data sources have duplicate rows due to multiple joins in data prep. Secondary data is one of the two main types of data, where the second type is the. This is the final step and will result in filtering between the blended data sources at your desired level of granularity. ) A LOD calc is also trying to do stuff at the row level. Alternate names:. In the actual data I get the error: Cannot blend the secondary data source because one or more fields use an unsupported aggregation. I am able to achieve the desired results but I am getting a warning ' Fields cannot be used from the [name of secondary data source] data source, because there is no blend relationship to the primary data source. Blended data sources. I am just trying to filter every Data source, by choosing a field that every Data source has. The unsupported aggregation happens when your aggregate requires row-level visibility to the secondary data source. Loading. In the secondary data source, select Data > Create Calculated Field. The secondary data source will have an orange checkmark on it. I am blending 2 data sets by employee id and when i am trying to group a field from the primary database, it is showing me below error: Cannot blend the secondary data source because one or more fields use an unsupported aggregation. the 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 - JimClick OK to close the Edit Group dialog box. Since my Workbook is present inside Office premise. Primary Data Source: Contains a list of all employees and their role. But seems we cannot blend 2 secondary data source with same field. 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. A datetime field may be converted to a date field using a calculation to remove the time. Then try using the LOD expression from a secondary data source. . 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. In data blending, there is a primary data source and a secondary data source. When on the dashboard, click on the ‘Dashboard’ drop-down and select ‘Actions’. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. We've adjusted our data strategy accordingly so using joins in all of our workbooks that need to leverage this functionality is not a sustainable solution. Credits to Jonathan Drummey for the below workaround Cannot blend the secondary data source because one or more fields use an unsupported aggregation . [tier] == 0 then "Low vendors" elseif max [Secondary]. The attached workbook and the following steps illustrate the process. The primary data source is just to filter for the invoices I want to look at. Expand Post. 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 . Name: Distinct Count. Excel . Required cookies are necessary for basic website functionality. With the recent release of Tableau Desktop 2020. Data blending is particularly useful when the blend relationship—the linking fields—need to vary on a sheet-by-sheet. In the past, I've just changed my primary table to the one with the calculation. Please check the attached workbook for details. I have 2 separate data sources that have similar fields. Twb, . This feature would be really useful to ensure we can. The date values you want to blend on must exist in both data sources. All customer IDs are under a dimension called "Global ID". Hi, I'll expand a bit on what @Chris wrote: There are some fundamental limits to what can be done with data blending and while there are workarounds that can get us the desired results in some circumstances those workarounds will not work in all circumstances (because Tableau never built out data blending to handle every. Fee - Cost) over time. Upvote Upvoted Remove Upvote Reply. A Level of Detail (LOD) expression is being taken from the secondary data source. We are blending two data sources. If I cant go the above way then is there a possibility to do the duration calculation using table calculations or some other way. In short, Tableau connects to multiple data sources, sends independent queries to those data sources, and then combines (or “blends”) the aggregated results of the independent queries on a single worksheet. " Is there a way to circumvent this issue? Or perhaps a different method entirely. Thanks. Yes - you can't bring COUNTD in data blending. E make table 2 the primary and table. {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. I have two data sources which I have blended together on two fields: branch and date. 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. In the Data pane, switch until the [name of subsidiary datas source] data root, and click at least one link icon to blend these datas sourcing. 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. [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. If I remove the blend, I cannot use/filter the secondary data source, and If I use the blend, it will display only the values for the first data source, but not from the second one, excluding. While it’s possible to aggregate the 1-to-many data source in the custom SQL, this can be time consuming and will require more edits when data sources change. Tableau will throw an error: “Cannot blend the secondary data source because one or more fields use an unsupported aggregation. LOD will not work if it is from the secondary datasource. Now you see a new group field listed in the Population data source (primary) called State (group). The aggregation is all on primary source data. One approach that succeeds in adding another measure is to add the measure in question to your. Let say from DS1 if i am making it as primary datasource then i can get the. 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. Chicken + Choice of DrinkBurger + Choice of DrinkSpaghetti + Choice of Drink . Upvote. 3 and I have created aggregates AGG for fields from data extract and excel file. Data blending is a method for combining data from multiple sources. I am trying to determine the Average Revenue per User by country for which my calculation is total revenue/unique subscribers. I am trying to blend the same data against the other because I wanted to show Same Period last Year. They both share a common field (State), and that is what I'm filtering on. Solution in the image 📌 Non-additive aggregates from the primary data source 📌 Non-additive aggregates from the secondary data source 📌 Non-additive aggregates from a multi-connection. Some of the function doesn't work properly when we use blending like COUNTD(), LOD{} expression. This can help researchers identify. For more information,. We cannot use ATTR if trying to create an LOD type calculation if blending data sources. Your secondary data source does not have the blend activated, you'll need to click on the link and turn it red to activate:. Currently, I have to rebuild the worksheet and bring in the secondary source first. 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. Data blending brings in additional information from a secondary data source and. One small workaround which you can do is: 1) Create a calculation as {Max([Date])} 2) Create a parameter as follows: 3) Create a calculation as . I am trying to use the below formula instead of countd function because my data comes from Impala {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 out my sheet i. It also means you cannot create a workbook using the. e. ”. In the Add/Edit Field Mapping dialog box, select the date fields from the primary and secondary data sources, and then click OK twice. A datetime field may be converted to a date field using a calculation to remove the time portion. I have two data sets that are linked across Date and Product Category fields. data source. Click on the ‘Add Action’ button and choose ‘Change Set Values’. From what I understand, it's because the link variable must be present in the view, or else it does not work. Verify if one of the measures coming from the cube data source has a default aggregation different than SUM, MIN, MAX, COUNT. The reason of the errors being unsupported calculation in blend. Good morning @Fred Yu (Customer) . “Cannot blend the secondary data source because one or more fields use an unsupported aggregation. Option 2: Create a calculation for a more dynamic sort. 1 because it can cause Tableau to unexpectedly quit. CSS ErrorBy default Tableau Desktop wraps fields from a secondary data source in an aggregation in calculated fields. Any existing, automatic blend kontakte is visible (and pot be deleted by suspend over the row and clicking the x). Please attach. Cube data sources do not support pass-through connections. Tableau Community (Tableau)Data blending creates a link on common dimensions--where those commonalities do not exist in the two data sources, values will be excluded. However, when I follow your advice, each group splits into 6 rows (one for each month - January through June). The data in the primary data source is the main data on which Tableau defines graphs and charts. an aggregated left join where the aggregation of the secondary data cannot be used to increase the level of detail of the primary data. Select Analysis > Create Calculated Field. I can't do a join because they are two different file formats. For more information, see Troubleshoot Data Blending; Blended data sources cannot be published as a unit. 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. I'm trying to show a distinct count of claims by branch. As you can see I have 2 different data sources using a blend on the blood type. Loading. I've attached my workbook that contains 2 data sources that are blended by invoice number. Loading. Loading. While on a view, right click a data source, click replace data source. The relationship is on the facility ID. I think I need to define the relationship between the data sources. Maxdate) There is one more way, make the datasource which is using the fixed calculation to. "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. {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. order_date = B.