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. {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. 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. 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 data source A, I have COUNTD(Person ID) and in data source B, I have COUNTD(Person ID). 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. That's probably your problem. There is a possibility that the values can be restricted from the secondary data. [OIL DATE]) THEN MIN ( [KMs]) END. Resolution. For more information,. I am trying to . 3) COUNTD with Secondary DS (Blending) Thanks,. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. I have two data sources to be used but need the count distinct of users from both the data sources. I've read through the various posts on here, plus the general troubleshooting posts on the Tableau page on blending data, but can't find a solution. I get around it by adding "max" in front of the first one again, and it says calculation is valid, but once I try to add it to the view it gives the error "Cannot blend the secondary data. If if this is the case, you could try creating a calculation for DAY([Endtimestamp]) in both the primary and secondary data sources, and adding it to the blend. But the source calc is a countD. I get error: “Cannot blend the secondary data source because one or more fields use an unsupported aggregation. Think of this layer as the Relationships canvas in the Data Source page. 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]). Jim. 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). 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. Observations : 1. Fixed, countd functions won't work with the secondary datasources. Pick the secondary data source in of Secondary data source pane. Consider joining the two data sources together using Tableau Prep, and then you can use that data as a. And I use Join data source, after divide measures / row duplicate. 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. 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. This feature would be really useful to ensure we can. cannot blend aggregated data from secondary data source. A data blend cannot filter on dimensions that do not exist in the Primary data source. When you blend, you can only have aggregate access to the rows in the secondary source. Next, create a table calc using the [Start KM] to calculate the total KMs: from Primary data source from Secondary data source. In the secondary data source, select Data > Create Calculated Field. In this case the cross. Tableau will throw an error: “Cannot blend the secondary data source because one or more fields use an unsupported aggregation. Regards. Data source A has Role Column and Data source B also has Role Column. IF min([Current Period ]) = true then [Display Sum Media Cost] end / sum(IF [Current Period ] = true then. Please check the attached workbook for details. 2, users would define joins and unions between physical tables in which Tableau would create a singular, flat table for analysis. Modify the calculation to not use table functions;. I have uploaded this dummy file since I cannot upload my real data here. This happens only when the data sources are impala. Expand Post. When I try to graph the distinct count of project ids vs the VendorClass, however, I see every project getting the. Beyond that personally I tend to do the work necessary to avoid using data blending in production data sources & views. Notice that Calc1 gives you an asterisk if there are multiple values returned from the secondary source. You can choose whether functional and advertising cookies apply. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. Maxdate) There is one more way, make the datasource which is using the fixed calculation to. When you blend, you can only have aggregate access to the rows in the secondary. You can read details here: Logical Tables in Secondary data source. 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. This link might help you: Cannot blend the secondary data source because one or more fields use an unsupported aggregation. 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. We can see these by activating secondary data source and looking at the dimensions window, the linking dimensions will have an orange chain icon. ) So the issue is really the introduction of the group on the sheet. I've attached my workbook that contains 2 data sources that are blended by invoice number. Remove all dimensions from the secondary data source and ensure that the primary data source’s linking field is in view. When blending in Tableau, there is always a primary source and a secondary data source. Show moreA workbook or mock data would be a sure thing to comment and try upon it. The data are sorted, but each row only shows one month of data with the other five columns blank. I've created the first chart with no problem, but I. I can add to filters from the data extracts. Expand Post. E make table 2 the primary. 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. Common warnings and errors when blending data sources No relationship to the primary data source. id, A. I have two data sources and doing a data blend. Are you talking about Tableau Prep or Tableau Desktop? Any chance you can share a sample of your data? Expand Post. 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. I can get all the fields into the view apart from the 'is vat exempt'. Currently, data sources that contain logical tables cannot be used as secondary data sources for data blending. I noticed there was an issue using Data Blend from 3 different source. We don't get row-level data from secondary sources on a blend. Here are the 7 major steps for putting this together: Set up your primary (main) and secondary (parameter) data sources. In your workbook sheet2 does not contain 5/22 date. * Supplemental data from a secondary data source is needed. 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. LOD will not work if it is from the secondary datasource. 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. You cannot filter data across secondary data sources. 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. ) If only one of the tables requires row level information, consider making that the primary data source in the blend (I. 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. So, basically, I am having issues with 2 calculations - the FIXED LOD and Remaining Value. Aside from consulting the primary origin or source, data can also be collected through a third party, a process common with secondary data. Let say from DS1 if i am making it as primary datasource then i can get the. ×Sorry to interrupt. You can create a federated database using linked tables/worksheets. 1, the ability to "Show Empty Rows" (or columns) was removed when you use a secondary data source. when I use A as primary data source and drag A. I am getting Cannot blend secondary data source because one or more fields used an unsupported aggregation. I have the total number of headcounts on one data set, and the number of attritions on the other so I am trying to write number of records (datasource1)/total headcounts (datasource2) and i get the red pill telling me "cannot blend the secondary datasource because one or more fields use an unsupported aggregation". The aggregation is all on primary source data. Secondary data source has Order Date represented as separate Year and Month fields. on Rows, Columns, Pages, or the Marks Card. Here is an example of what I am trying to accomplish:Data blending is a method for combining data from multiple sources. 💥Check my Website💥 Troubleshoot Data Blending in Tableau Part 2 here SHOP After you have used the secondary data source to provide aliases for the primary data source, you no longer need the secondary data source and can close it. I am working with two Data Bases that are essentially the same, but I use the second one to "fake" dates (basically the same date +1 year) in order to use it for the YoY comparison that aligns with the different filters I set. Because the question is related to how the data sources are being related, it would help to see the real data structure. Please find the complete blog here ----> COUNTD with secondary DS Tableau(Blending) Workbook is attached. 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. One data source has some values, the other one has different values. 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 in Tableau, you don't use COUNTD function when Blending data source. Option 2: Join tables that are in the same data source, instead of blending them. I can add to filters from the data extracts. Data > Edit Relationships . When Bugs History is a live connection to Vertica living inside my workbook all is well. 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. Data source filters. 0 but was disabled (greyed out) in 8. 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. 0, but I imagine someone has been able to identify what is causing the issue. the blended data cannot be published to Tableau Online or Tableau Server. It says, "fields cannot be used from [data name] data source, because there is no relationship to the primary. The Products set contain the individual products within an Opportunity whereas the Opportunities set contain Sales metrics (i. I am trying using { FIXED : SUM[(portfolioValue)]}. I am just trying to filter every Data source, by choosing a field that every Data source has. ” Causes and Workarounds for a Blending Limitation Errors. unsupported aggregation. From Primary Data Source drag the measure names and measure values . My problem happens when I go to the dashboard, I want to filter on FW (fiscal week) and have crosstab. I have the same issue, but Primary Data Source is a Tableau Server Data Source (I do not have direct access to the database), and Secondary Data Source is an excel flat file. Data blending: Cube data sources can only be used as the primary data source for blending data in Tableau. data source. I am trying to determine the Average Revenue per User by country for which my calculation is total revenue/unique subscribers. I'm blending the 2 data sources by Service_Id. ×Sorry to interrupt. 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. Call it [Start KM]: IF ATTR ( [KM Date])=ATTR ( [OIL]. the count of claims I'm getting from the secondary data source, by counting distinctly a measure called claimid. Click on the ‘Add Action’ button and choose ‘Change Set Values’. The order in which fields are used determines which data source is the primary versus the secondary data source. Option 2: Create a calculation for a more dynamic sort. Currently, data sources that contain logical tables cannot be used as secondary data sources for data blending. ” We use three kinds of cookies on our websites: required,. For more information, see Troubleshoot Data Blending; Blended data sources cannot be published as a unit. 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. We cannot publish a blended data source as a single data source on the server. 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. 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. Now we have to use W2 as Filter - to filter out the data. 1. you will get 5/22 date. (It is a field that contains account names (company) in the sample data. month([date])=month(Parameter. {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. 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. To blend on summary data, you can do the following: Create a. Click oLoading. 2 came the introduction of a brand-new data model. 1. Hello Tableau world!! Am running into the strangest problem when data blending with V8. 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'. The syntax for calling secondary data source field is not. CustomOverall (Primary) 2. ×Sorry to interrupt. For example, sheet A uses data source 1 as the primary data source; sheet B uses data source 1 as the secondary data source. As you can see I have 2 different data sources using a blend on the blood type. Size() is a great choice for unique counts across data sources if you can create a view where every unique row is displayed. "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. Try one of the following options, as appropriate for your workbook: It may be possible to cross database join instead of blending. IF ATTR([Offer Status]) = "Hired" Then AVG([Comp_File]. 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. I'm trying to show a distinct count of claims by branch. Moreover, blending is a kind of left join, not exactly a join. 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. 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. Maxdate) There is one more way, make the datasource which is using the fixed calculation to primary data source. 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. In second data source i don;t have salesrep column. 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. See Join your Data for instructions. 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. 2. This feature would be really useful to ensure we can. [OIL DATE]) THEN MIN ( [KMs]) END. - Dataset 1, records the amount spent on ads as "Cost". e. 4. 3 and I have created aggregates AGG for fields from data extract and excel file. Select Default Properties > Sort. 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. See Join Your Data for more information. Option 2: Create a calculation using WINDOW_SUM() Drag the linking field(s) from the secondary data source to. 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. For more information, see Troubleshoot Data Blending; Blended data sources cannot be published as a unit. 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. The version I am working with 10. Select Analysis > Create Calculated Field. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. Data blending is particularly useful when the blend relationship—the linking fields—need to vary on a sheet-by-sheet. The two data sources are identical. Make the data source that contains the field that you want to use in the URL action the primary data source in. An orange tick indicates a secondary data source (Promotions). Filter not recognizing blend relationship. However, when I follow your advice, each group splits into 6 rows (one for each month - January through June). 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. If you are blending a cube data source, it must be the primary data source. As 'Group' is from a secondary data source, I cannot simply use the sort buttons. 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. T or F: Blends, unlike relationships or joins, never truly combine the data. This functionality was available in versions 8. Verify if one of the measures coming from the cube data source has a default aggregation different than SUM, MIN, MAX, COUNT. CSS ErrorHi Mavis Liu. COUNTD - Blended data. 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. [tier] == 0 then "Low vendors" elseif max [Secondary]. Fields from the secondary data source used in the view have an orange tick. Some examples include: session cookies needed to transmit the website, authentication cookies, and security cookies. No long-term contract. Status, Stage, etc). A datetime field in the primary data source, for example, will not blend with a date field in the secondary data source. This happens regardless if I drag it on the rows or on the Marks space as a 'text'. Hello Ritish, You could use Size() and a Las() function as a filter and get the same output. 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. Error “Cannot blend the secondary data source because one or more fields use an unsupported aggregation. 1) Vizible Difference: Getting around Count Distinct in a secondary data source. 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. Not able to share for time being. I have three different data source . Secondary data is one of the two main types of data, where the second type is the. Cannot blend the secondary data source since one or more search use certain unsupported aggregation. Change the default sort order of the field using the various options, and then click OK. Process for Creating the Dynamic “Parameter”. Because there are no linking fields in this view. In order to create the waffle chart I am blending it with another datasource using the calculated field defined as [Week 5 (Week5Bond)]. Left. tds and . " I have seen a few posts on it and found an issue logged about it as far back as version 8. 1) When we add fields from secondary data sources to a view Tableau “joins” the data as part of the blend on one or more linking dimensions. 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. 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. No. Answer. Are use of grouped fields not allowed in data blending? I have two data sources: Opportunities and Products. Secondary data sources cannot have logical tables (except when they satisfy specific conditions). 3. Instead, publish each data source separately (to the same server) and then blend the published data sources. We use three kinds of cookies on our websites: required, functional, and advertising. Seemingly simple task is getting complicated in Tableau . The attached workbook and the following steps illustrate the process. 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. 3 and I have created aggregates AGG for fields from data extract and excel file. The data in the primary data source is the main data on which Tableau defines graphs and charts. Tableau v8 added a new style of data blending (DB2) where the linking field does not have to be in the view. Please refer the below link and let me know if this helps to you. From my primary data source I have a dimension in columns say 'Customer Segment'. The date values must be in the same format. But I cannot for the life of me comprehend why the data blending would behave differently based solely on the chart type that was selected. LOD will not work if it is from the secondary datasource. I am blending (2) data sources based on the date. "Cannot blend aggregated data from the secondary data source with the data on this sheet because there are no linking fields use din the view" I'm using 2 separate data sources connected to Oracle and published to the Tableau server. The blend is not activated meaning a field from secondary DS is not used in the view. In your 2nd and 3rd data sources. Which version of Desktop are you using? See attached the superstore workbook (. Marked as. Cannot blend the secondary data source because one or more fields use an unsupported aggregation . I tried data blending keeping File C as primary and A & B as secondary data source with DD number as relationship. g. Data blending is a good option when you have multiple data sources that cannot be combined through relationships. Instead, publish each data. . 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". It is important to understand which is the primary source, it can impact. 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. 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. Tableau will throw an error: “Cannot blend the secondary data source because one or more fields use an unsupported aggregation. In my primary, I define another calculated field to do the aggregation for each project by tier: VendorClass: if max [Secondary]. Dominic Laird(Member) 5 years ago. 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. 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. 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. The primary data source is just to filter for the invoices I want to look at. Now try to recreate the sheet and link the 2nd and 3rd data. I. Tableau Desktop & Web Authoring. CSS ErrorAfter Blending, Now it is showing this error: Cannot blend the secondary data source because one or more fields use an unsupported aggregation. To provide comparative data: Secondary data can be used to compare and contrast findings across different studies or datasets. Another sheet:W2 is created with Data source A - taking Role in Row shelf. e. "Filtering Across Multiple Data Sources Using a Parameter; Cause A sheet cannot be filtered by a field from a secondary data source. 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. Data blending has some limitations regarding non-additive aggregates such as COUNTD, MEDIAN, and. 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. See the attached updated workbook. Drag the 2016 Population measure to the Columns. Does anyone know if there is a way around this or can you only create a blending whit datasources that were created the same way? I appreciate your help. This happens only when the data sources are impala. Primary Data Source: Extract S. Use the geographic role in the primary data source on detail instead of the dimension from the secondary data source. 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. I've blended on user ID. Hi Data Modeler , I have an idea which I cannot test right away. So, in the dummy data, there are two tables from two data sources. All three options are demonstrated in the attached workbook using the sample data set Superstore. Primary and Secondary sources in data blending. But seems we cannot blend 2 secondary data source with same field. order_date = B. CSS ErrorData blending is based on two key components- Primary data sources and Secondary data sources. Few things you need to keep in mind while blending data sources in tableau. 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. Some of the function doesn't work properly when we use blending like COUNTD(), LOD{} expression. Fee - Cost) over time. Help would be much. Place Organisation Identifier on the level of detail shelf (from the primary source, or both sources) and the blend should work. Loading. 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. When I calculate the average of a measure and use the filter, it works perfectly fine. png - Ben-Sullins's library "Cannot blend the secondary data source because one or more fields use an unsupported. I have two data sources and I have blended them together. Advantages: Very easy to write and implement. I like to have the ability to swap a primary data source with a secondary data source for data blending in a workbook. , 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. I read that this is not possible. We would like to show you a description here but the site won’t allow us. [Field_Name]":"Value_to_filter" in the Options will not work. FIXED ID, WEEK: CountD (accounts)). I am using tableau 2020. Data sources can contain logical tables not be used as secondary data sources for data blending. Input cannot become used from the [name are secondary data source] data source, because there is no blend relationship to the primary data source. Upvote Upvoted Remove Upvote Reply. Option 2: Join tables that are in the same data source, instead of blending them. In your case, you're after the Total Cases by Employee, so just imagine Employee in place of Category. the count of claims I'm getting from the secondary data source, by counting distinctly a measure called claimid. THEN add this total to the SUM of the projected_users from today's date through month X. However, some days will have entries for "Cost" but not for "Proj. LoadingWhen you try to add URL actions to dashboards, fields from secondary data sources cannot be added to the URL. 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. 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. "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. 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. 2. [Work Hours]) So you have to make. As it is right now (version 8) if you add filters from a secondary data source, you can not cascade the filters based on what the user selects from one filter to the other - this is only. The two data sources are identical. Make the field(s) used to address the table calculation active linking fields. I can't do a join because they are two different file formats. I have three different data source . The data is blended on customer. The point is to do row-level work in the secondary source, so that when the blend pulls data it doesn't have to do the row-level work. Instead, publish. 4, I tried to blend products (secondary) to storefront (primary) based on Sku. Aggregate the date fields at the MY. Loading. Step 1: Create the Parameter. 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. amount into the view, it gives me the correct sum. 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. Expand Post. 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. This means a data blend can’t be published as a data source for others to use. To overcome this, I've added a filter straight into the data source and not in the view. They must be in the same format. e. month([date])=month(Parameter. 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. 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. . Cannot blend the secondary data source because one or more fields use the == function, which cannot be computed locally. Selected as Best Selected as Best Upvote Upvoted Remove Upvote 1 upvote. While on a view, right click a data source, click replace data source. 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. 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. Cannot blend the secondary data source because one or more fields use an unsupported aggregation issue. Expand Post. AUMTable (Secondary) 3. Overall LOD will show correct result in Primary datasource.