With the release of Tableau 8. This functionality was available in versions 8. ”. Any existing, automatic blend kontakte is visible (and pot be deleted by suspend over the row and clicking the x). The two data sources are identical. Hi, I have a scenario where I have to use Data Blending option to get certain metric values from Secondary Data Source. I like to have the ability to swap a primary data source with a secondary data source for data blending in a workbook. Instead, publish each data source separately (to the same server) and then blend the published data sources. Filter each of the data sources independently on the more granular dimensions. General Information. I establish the blend relationships explicitly by going to Data -->Edit Blend Relationships, and selecting the fields that should be related. 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. I get error: “Cannot blend the secondary data source because one or more fields use an unsupported aggregation. Upvote Upvoted Remove Upvote Reply. . 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. You can create a federated database using linked tables/worksheets. In your 2nd and 3rd data sources. Call it [Start KM]: IF ATTR ( [KM Date])=ATTR ( [OIL]. Size() is a great choice for unique counts across data sources if you can create a view where every unique row is displayed. [tier] == 2 'Top Vendors' else 'Mid Vendors'. See the attached updated workbook. In the Data pane, select the State data source (secondary). The secondary data source need to be my transaction file and primary data source need to be my budget file. To overcome this, I've added a filter straight into the data source and not in the view. 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). 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. Credits to Jonathan Drummey for the below workaround Cannot blend the secondary data source because one or more fields use an unsupported aggregation . Drag the 2016 Population measure to the Columns. Data from secondary data sources must always be aggregated in calculations. 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. Primary Data Source: Extract S. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. Filter each of the data sources independently on the more granular dimensions. Step 2: Make it a context filter. 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. The problem is when I try to calculate the median of that same measure. 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. Cannot blend the secondary data source because one or more fields use an unsupported aggregation It’s cable reimagined No DVR space limits. This feature would be really useful to ensure we can. In addition, you cannot blend Measure Values from a secondary data-source, so that rules out this approach as well. To blend on summary data, you can do the following: Create a. I'm blending student data (primary) and staff data (second). 3 and I have created aggregates AGG for fields from data extract and excel file. When you blend, you can only have aggregate access to the rows in the secondary. Set up the primary and. Resolution. Upvote Upvoted Remove Upvote Reply. gov which displays certain regions in the US (a geometry field is auto created in tableau which allows me to create this map easily), the second data source is a data pull from a data warehouse holding lat/long coordinates of specific points (able to create a point via calculated tableau field using the make point function). Upvote. In the Data window, right-click the relevant field. order_date. Identify your data sources for common data types: both data sources must have a string or date field for linking data sources. You combine data in the logical layer using relationships (or noodles). SandhyaData from the secondary data source (via a data blend) can never be a dimension. " Expand Post. 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. From my primary data source I have a dimension in columns say 'Customer Segment'. CSS ErrorData blending is based on two key components- Primary data sources and Secondary data sources. 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 . But I cant add filter Month from the Budget Excel file. then i added a secondary data source from google sheet , which has the fuel amount. All Answers. My goal is to show CY Actuals as bars, with a line for PY Actuals and a line for Budget. This feature would be really useful to ensure we can. Overall LOD will show correct result in Primary datasource. Data blend is like a Left outer join. I am creating a couple of formulas to display the total booking from the second data source to the first data source. Blending with CountD and LODs. It takes advantage of the data collected from previous research and uses it to carry out new research. 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. From Primary Data Source drag the measure names and measure values . This means a data blend can’t be published as a data source for others to use. The chart should display: countd. I didn't realize this until now, but it appears you cannot use blending when one of your data sources uses the new(ish) relationship model. Resolution. Data blending have some limitations regarding non-additive total such like COUNTD, MEDIAN, and RAWSQLAGG. If this aggregation is ATTR() then the grand totals may be blank. One of the Dimension which is part of the Relationship between Primary and Secondary Data Source is being used in Filter and the same field cannot be displayed in Report as it changes the Level of grain of the reportIm using two data source to develop the workbook. Please check the attached workbook for details. Call it [Start KM]: IF ATTR ( [KM Date])=ATTR ( [OIL]. 1 because it can cause Tableau to unexpectedly quit. ” Causes and Workarounds for a Blending Limitation Errors. 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. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. Excel 1 pc. Blending takes place in the 6th step of the order of operation after the data table for the individual worksheet is set and the filters applied - data from the secondary source are aggregated at the level of the link and brought to the primary as. This means a data blend can’t be published as a data source for others to use. 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. ×Sorry to interrupt. Russell Christopher (Member) 10 years ago. 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. Common warnings and errors when blending data sources No relationship to the primary data source. So you don't get in the case of data blending. 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 . 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". If there is another. Drag the State (group) dimension over the Region dimension on the Rows shelf to replace it. "Cannot blend aggregated data from the secondary data source with the data on this sheet because there are no linking fields used in the view. 1 Connected to Tableau Server as Main DS and Live Connection to an excel file as secundary DSStep 2: Bring summary data from the secondary data source into the primary data source. Data blending is particularly useful when the blend relationship—the linking fields—need to vary on a sheet-by-sheet. The "Create Primary Group" operation is bringing the dimension from the secondary into the primary, but it is static, and does not update when your data updates. Primary and Secondary sources in data blending. The solution. Data blending: Cube data sources can only be used as the primary data source for blending data in Tableau. 4. 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. {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. 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. For example, COUNTD(). [OIL DATE]) THEN MIN ( [KMs]) END. " inner cross database join on BU Code with a data source filter set up on UPPER([ID])=UPPER(USERNAME()) on the DS2 source. Data blending works like a ___ join. In my primary, I define another calculated field to do the aggregation for each project by tier: VendorClass: if max [Secondary]. "Data Sources that contain logical tables cannot be used as secondary data sources for blending". Cannot blend the secondary data source because one or more fields use an unsupported aggregation. I am already using a Custom SQL query as an additional data source and trying to do blending based on the relationship on BU code field from RPT and AD. drag the secondary measures to measure values section . - Dataset 1, records the amount spent on ads as "Cost". If you are blending a cube data source, it must be the primary data source. Expand Post. Make sure that you are blending on dimensions present in the view or on all of the. Create a “Blend Field” with a value of 1 in both your primary and secondary. since i want only offername from secondary source to the view and the measures are produced from primary datasource is pos_trn. I thought about using a parameter but you cant search with a parameter in a prompt, on the other charts that are like this there are hundreds on items. 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. If I cant go the above way then is there a possibility to do the duration calculation using table calculations or some other way. I can add to filters from the data extracts. Step 1: Create the Parameter. This field works but when I want to add in my Fianl Dashboard I have this message "Cannot blend the secondary data source because one or more fields use an unsupported aggregation" Moreover my first and secondart data sources are linked by the "Sales ID", but this field is not displayed in the final Dashboard. You cannot filter data across secondary data sources. 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. 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'. In the past, I've just changed my primary table to the one with the calculation. Hi Justin, Thanks for your quick reply. Cube data sources can be used only as a primary data source to blend data in Tableau, and cannot be used as secondary data sources. This type of bases does not allow for blend relationship, therefore, you cannot use a filter like this. Each has a joining field with the same name. 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. 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. Make the data source that contains the field that you want to use in the URL action the primary data source in. I'm trying to create a frequency distribution as a percent of total for individual products in a single category on one chart, then dual axis a second chart with the frequency distribution of the category for comparison purposes. I have two data sources which I have blended together on two fields: branch and date. Another sheet:W2 is created with Data source A - taking Role in Row shelf. Assuming that's what's going on, there's the question of how to work around this. Data blending is a method for combining data from multiple sources. 2) Use this duplicate field in the view instead of the original. An orange tick indicates a secondary data source (Promotions). Effective visualization. To provide comparative data: Secondary data can be used to compare and contrast findings across different studies or datasets. 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 made a waffle chart grid using an excel data source that contains 3 fields: Rows, Columns and Percentage. the blend relationship is defined on driver Code, and working fine when adding both basicSalary (from main data source) and fuel (from secondary) to the sheet. Some of the function doesn't work properly when we use blending like COUNTD(), LOD{} expression. 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 HelpWhen I am using apply filter to related data sources, other data sources add this field as a secondary data source and the worksheets which uses that as a primary data source gives me errors. Ritesh Bisht (Member) 6 years ago. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. 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. Proj. The blend applies to that worksheet only. Data & Connectivity. This would be a great time saver, with all of the calculations and linking changing as well. For more information, see Deciding Between Joining Tables and Blending Data. We don't get row-level data from secondary sources on a blend. Good morning @Fred Yu (Customer) . Hi Data Modeler , I have an idea which I cannot test right away. I have two data sources and I have blended them together. I am just trying to filter every Data source, by choosing a field that every Data source has. Cube (multidimensional) data sources have certain characteristics that make them unique in Tableau. I can't do a join because they are two different file formats. I am trying to blend the same data against the other because I wanted to show Same Period last Year. Click oLoading. You can read details here: Logical Tables in Secondary data source. Loading. The data in the primary data source is the main data on which Tableau defines graphs and charts. 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. Unsupported aggregations in data blending Hello, I have a distributor dataset with product ships and returns (one report covering six months), and a retailer dataset with product retail sales and stock (covering the same six months but composed of. I get error: “Cannot blend the secondary data source because one or more fields use an unsupported aggregation. Hi Kurt! No, not really. [tier] == 0 then "Low vendors" elseif max [Secondary]. I am using tableau 2020. And I can't explain why it does that. 1) Vizible Difference: Getting around Count Distinct in a secondary data source. In data source A, I have COUNTD(Person ID) and in data source B, I have COUNTD(Person ID). Fields cannot be used from the [name of secondary data source] data source, because there is no blend relationship to the primary data source. Summary:. Whichever data source you "use first" in a view (by dragging in a field) becomes Primary. Because the question is related to how the data sources are being related, it would help to see the real data structure. 1. Any help would be appreciated!Also a data blend is only a LEFT join. 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. Thanks for your help everyone! I've found what was happening: I had some filters on the secondary data source. Twb, . A datetime field may be converted to a date field using a calculation to remove the time portion. 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". Currently, data sources that contain logical tables cannot be used as secondary data sources for data blending. Common Issue #1: Cannot blend the secondary data source because one or more fields use an unsupported aggregation The aggregation methods of COUNTD,. i. 0 but was disabled (greyed out) in 8. LOD expressions are used when running complex queries with multiple dimensions at the data source level. Cannot Blend Secondary Data Source - Unsupported Aggregation. CSS ErrorI want to blend data from two different sources but on blending the data the filters from primary data source do not work if the case is different in the secondary data source. I am trying to . newBranchProjection (Secondary) When I try to add COUNTD([DistrictId]) from my primary to text table. Left. I tried data blending keeping File C as primary and A & B as secondary data source with DD number as relationship. the count of claims I'm getting from the secondary data source, by counting distinctly a measure called claimid. “Cannot blend the secondary data source because one or more fields use an unsupported aggregation. 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". Now you see a new group field listed in the Population data source (primary) called State (group). Consider joining the two data sources together using Tableau Prep, and then you can use that data as a. 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. I've attached my workbook that contains 2 data sources that are blended by invoice number. 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. 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. Upvote Upvoted Remove Upvote Reply. Then you can simply show one filter control on your dashboard and set it to apply to all related data sources. I noticed that when the spatial file is the secondary data source, I cannot area plot it by double clicking the geometry variable. Fee". 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. Resolution. when I use A as primary data source and drag A. 3. Data coming from a secondary source is ALWAYS aggregated at the level of the link - even if there is 'no need to add anything' that's just the way blending works - it happens after the data table dimensions are set and you are loading values into the data table for the individual worksheet 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 relationship - not. In the Add/Edit User Mapping dialog crate, do the following: Select a select by the primary your data. In the Relationships dialog box, under Secondary data source select Custom, and then click Add. 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]). COUNTD is tough to work on while you. As 'Group' is from a secondary data source, I cannot simply use the sort buttons. 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. From what I understand, it's because the link variable must be present in the view, or else it does not work. For example, sheet A uses data source 1 as the primary data source; sheet B uses data source 1 as the secondary data source. In this case the cross database join will effectively act like the. Make sure that you are blending on dimensions present in the view or on. Case 1: If you are facing this issue before report is been developed then try to use data source filter to limit the data flow and finish the development. Upvote Upvoted Remove Upvote Reply. In the Add/Edit Field Mapping dialog box, select the date fields from the primary and secondary data sources, and then click OK twice. I have three different data source . 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). Here is the sample. 1. To blend on summary data, you can do the following: Create a. Observations : 1. Hello Ritish, You could use Size() and a Las() function as a filter and get the same output. I've blended on user ID. Data > Edit Relationships . " Is there a way to circumvent this issue? Or perhaps a different method entirely. Twbx and also the . 2 came the introduction of a brand-new data model. Currently, I have to rebuild the worksheet and bring in the secondary source first. The primary data source is just to filter for the invoices I want to look at. 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. You can choose whether functional and advertising cookies apply. Data source filters. So, basically, I am having issues with 2 calculations - the FIXED LOD and Remaining Value. Select Analysis > Create Calculated Field. * Supplemental data from a secondary data source is needed. How do I blend these data sources by year? - The Tableau Community. From what I understand, it's because the link variable must be present in the view, or else it does not work. The secondary data source just pulls in some names to associate with ID numbers in the primary and some filters for the staff data. 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. If we are working with one data source that is not relatable or joinable (such as Google Analytics) you are not able to blend a secondary data source with logical tables to it. 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. I'm using a cube data source as my primary and am attempting to blend with. You can create a federated database using linked tables/worksheets. But I cant add filter Month from the Budget Excel file. Secondary Data Source: Contains data relating to the usage of a website (hits). The relationship is on the facility ID. A key difference with blending is that data is aggregated before being "joined" - you'll notice this when you include a column from the secondary source in a calculation in the primary source. While on a view, right click a data source, click replace data source. Output - End output which I need is a table with a single row data for each country with 3 columns Country name, Total Count of DD, Total Cost for DD. an aggregated left join where the aggregation of the secondary data cannot be used to increase the level of detail of the primary data. Both fields are linked in worksheet. The only workaround I can think of is to put the course code onto the level of detail shelf, but that means that what appear to be solid bars are actually stacked bars. Blending runs a query on each data source and joins the aggregated results of those queries. For details, see Troubleshoot Data Blending. In the Data window, right-click the relevant field. Best solution. And I use Join data source, after divide measures / row duplicate. 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. The reason your blend breaks is that you're blending with Location as a linking field, so when you remove that from your view, Tableau can't blend any longer. "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. When I then published this to server as an extract, then tried to blend it with the first data set I get this error: 2013-10-15_15-03-01. Status, Stage, etc). We use three kinds of cookies on our websites: required, functional, and advertising. 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. I am trying to use the measures name filter functionality with two data sources. The date values must be in the same format. In the attached file, table shows the sum of sales and first order date correctly from both the. But since there are a few dates missing from the second data source i cannot blend on date as doing this will result in loosing data from Table 1. I have 2 data sources, A and B, they are linked by data blending with A. [OIL DATE]) THEN MIN ( [KMs]) END. Currently, data sources that contain logical tables cannot be used as secondary data sources for data blending. Mihai Constantinescu (Member) 6 years ago. e. 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. Remove all dimensions from the secondary data source and ensure that the primary data source’s. To alias field values. CSS ErrorLoading. (It is a field that contains account names (company) in the sample data. 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. This means that it forces the view to display only relevant data in the secondary data source. if you have blended data sources you can not use lods One of the drawbacks of blended sources . Now we have to use W2 as Filter - to filter out the data. I receive this error: "Cannot blend the data source because one or more fields uses an unsupported aggregation". CustomOverall (Primary) 2. Expand Post. General Information. 3. When I do the join between the SSAS Tabular Model (primary data. ) If only one of the tables requires row level information, consider making that the primary data source in the blend (I. 4. You combine data in the logical layer using relationships (or noodles). Data blending; Table Calculations; Resolution Use one of the following workarounds: If possible, join instead of blend your data. Chicken + Choice of DrinkBurger + Choice of DrinkSpaghetti + Choice of Drink . The two data sources are identical. Both Primary and Secondary data sources have duplicate rows due to multiple joins in data prep. Could please share me if there is a alternate solution for data source filter logic?Step 1: Place the required field into the Filter for a worksheet which sources the parent data. It throws me cannot blend secondary data source one or more becuase one or more fields use unsupported aggregation . The unsupported aggregation happens when your aggregate requires row-level visibility to the secondary data source. Non-additive aggregates are generally not usable when a secondary dimension appears on any Shelf or there’s a linking dimension that is not in the view. Does anyone have any Ideas how I can apply a universal filter. You cannot filter data across secondary data sources. The version I am working with 10. We use three kinds of cookies on our websites: required, functional, and advertising. 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. All three options are demonstrated in the attached workbook using the sample data set Superstore. In versions prior to 2020. Option 2: Join tables that are in the same data source, instead of blending them. Next, create a table calc using the [Start KM] to calculate the total KMs: from Primary data source from Secondary data source. 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. (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. 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. Select Default Properties > Sort. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. 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. E make table 2 the primary and table. 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. 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. Unknown file type Total from Secondary Data Source. First data source looks like below. With the recent release of Tableau Desktop 2020. In second data source i don;t have salesrep column. , it's difficult to determine; however, what you could do is click on each data source and if you see a chain link that is solid and not broken where fields might be related/blended in the tables below, then click the icon to unlink it. . This happens regardless if I drag it on the rows or on the Marks space as a 'text'. 3) Select the now grey link next to the original field in. 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. You can choose whether functional and advertising cookies apply. Community Manager update. " inner cross database join on BU Code with a data source filter set up on UPPER([ID])=UPPER(USERNAME()) on the DS2 source. Before I check Date filters, I got this results. I am getting Cannot blend secondary data source because one or more fields used an unsupported aggregation. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. It sounds like there might be some complications with a blend? Can’t speak to what’s happening there Are you blending on [Endtimestamp]? By using the formula DAY([Endtimestamp]), you're changing the dimensionality a little bit. Cannot blend the secondary data source because one or more fields use an unsupported aggregation" when Data Blending. I'm trying to show a distinct count of claims by branch. A Level of Detail (LOD) expression is being taken from the secondary data source. I am getting Cannot blend secondary data source because one or more fields used an unsupported aggregation. Also, in the attached I have added both Calc1 and Calc2 to the tooltip in Sheet 9. Data source A has Role Column and Data source B also has Role Column. Upvote. ×Sorry to interrupt. AUMTable (Secondary) 3. I can get all the fields into the view apart from the 'is vat exempt'. ×Sorry to interrupt. then i added a secondary data source from google sheet , which has the fuel amount. 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" Because of this, our overall. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. Fee" I want to plot Gross Profit (i. 2 and later.