I have uploaded this dummy file since I cannot upload my real data here. 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. Upvote. 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. Option 2: Create a calculation for a more dynamic sort. 5 3 . In the Data window, right-click the relevant field. 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. Aside from consulting the primary origin or source, data can also be collected through a third party, a process common with secondary data. Can't see what you are actually doing but Blending data has its limits. ×Sorry to interrupt. Cannot blend the secondary data source because one or more fields use the == function, which cannot be computed locally. Loading. 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. 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. E make table 2 the primary. Now try to recreate the sheet and link the 2nd and 3rd data. The date values you want to blend on must exist in both data sources. Data blending works only as a left join. IF ATTR([Offer Status]) = "Hired" Then AVG([Comp_File]. " And after that I can't make my workbook work at all. Filter each of the data sources independently on the more granular dimensions. Make the data source that contains the field that you want to use in the URL action the primary data source in. According to Tableau, this error can also appear when using a LOD expression in a blended view. Resolution. Cannot blend the secondary data source because one or more fields use an unsupported aggregation" when Data Blending. No long-term contract. 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. Step 1: Connect to your data and set up. Select Default Properties > Sort. unsupported aggregation. I've attached my workbook that contains 2 data sources that are blended by invoice number. [% age]>=SUM([Percentage]) . Sometimes , it's automatically working but sometimes it says 'Unsupported Aggregation' . Cannot blend the secondary data source because one or more fields use an unsupported aggregation. Dominic Laird(Member) 5 years ago. Unfortunately can't share the data, and can't come up with a mock cause I can't figure out what's not/is working as expected. 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. Expand Post. Are use of grouped fields not allowed in data blending? I have two data sources: Opportunities and Products. The data are sorted, but each row only shows one month of data with the other five columns blank. 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. Error: Cannot Blend the secondary data source because one or more fields use an unsupported aggregation. I'm noticing you are using the Date field from the secondary data source you are working with. 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. This is interesting. Option 2: Join tables that are in the same data source, instead of blending them. Instead of using relationships, double-click into your table to get to the. 3. Credits to Jonathan Drummey for the below workaround Cannot blend the secondary data source because one or more fields use an unsupported aggregation . ”. So the only way, it was possible was to connect one of the data sources with a calendar table joined with previous year and then blend it against the same data to get the Current Year and Same Period Last Year values in a single view. 3) COUNTD with Secondary DS (Blending) Thanks,. In the Data window, right-click the relevant field. Maxdate) There is one more way, make the datasource which is using the fixed calculation to. Better collaboration. 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. "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. Filtering data across a worksheet's secondary data source is not currently supported in Tableau Desktop. In addition, you cannot blend Measure Values from a secondary data-source, so that rules out this approach as well. " Is there a way to circumvent this issue? Or perhaps a different method entirely. "Cannot blend data from the secondary data source with the data on this sheet because there are no linking fields used in the view" Expand Post. " inner cross database join on BU Code with a data source filter set up on UPPER([ID])=UPPER(USERNAME()) on the DS2 source. Both Primary and Secondary data sources have duplicate rows due to multiple joins in data prep. 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. Excel . Filter each of the data sources independently on the more granular dimensions. In data source A, I have COUNTD(Person ID) and in data source B, I have COUNTD(Person ID). Tableau Desktop & Web Authoring. 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. I tried to recreate the data as close as possible. Step 2: Make it a context filter. Beginning with Tableau Desktop 2020. 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 aggregated data from secondary data source. Click oField cannot breathe used from the [name by secondary data source] data original, because there is no mixed relationship to the primary data original. It says, "fields cannot be used from [data name] data source, because there is no relationship to the primary. 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. Right-click in the Data window and then. 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. There's a set of views/calcs that show a metric, (metric C) counting distinct number of accounts contacted per person per week (e. Option 1: Include all linking fields in the view, and aggregate secondary fields Data blending will work when the secondary data source uses logical tables, as long as the following conditions are met: All active linking fields from the primary data source must be included in the view on a shelf other than the Filters shelf Link Primary Source and all other secondary source on this Field Created from step 3- 4 using Edit Data blend Relationships 6. General Information. Can anybody please help me with a solution. Data sources can contain logical tables not be used as secondary data sources for data blending. Fields from the secondary data source used in the view have an orange tick. 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. e. (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. cannot blend aggregated data from the secondary data source with data on this sheet. 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. In the Relationships dialog box, under Secondary data source select Custom, and then click Add. Thanks for your help everyone! I've found what was happening: I had some filters on the secondary data source. 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. Seemingly simple task is getting complicated in Tableau . Both Primary and Secondary data sources have duplicate rows due to multiple joins in data prep. I am blending dates in the secondary data source to dates from the primary source and looking to get a distinct count of the customer code from the secondary data source. Primary and Secondary sources in 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. Currently, I have to rebuild the worksheet and bring in the secondary source first. In a blend, secondary data sources are aggregated and the StoreID dimension would be aggregated to "*". See Join Your Data for more information. 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. Hi Andy, Following up on this - Tableau has been promoting the jump to relationships, in place of joins. One data source has some values, the other one has different values. Some of my table calculation are the follow: RED FIELD Tableau Name of First Math Course= IF [Tableau Period of First Math Course]== [Academic Period] AND ( [Subject Desc]=='Mathematics' OR [Subject. xls files). Verify if one of the measures coming from the cube data source has a default aggregation different than SUM, MIN, MAX, COUNT. Data blending tools can present their findings as visualizations, such as infographics and charts, after querying data sources and aggregating relevant information. How to rewrite my calculation to fix the error: cannot blend the secondary data source because one or more fields are use and unsupported aggregation. I can add to filters from the data extracts. newBranchProjection (Secondary) When I try to add COUNTD([DistrictId]) from my primary to text table. [tier] == 0 then "Low vendors" elseif max [Secondary]. How do I blend these data sources by year? - The Tableau Community. I have two data sources which I have blended together on two fields: branch and date. 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. If there is another. 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. Using Tableau; Upvote; Answer. Fixed, countd functions won't work with the secondary datasources. If I cant go the above way then is there a possibility to do the duration calculation using table calculations or some other way. blending [cannot blend Measure Values from a secondary data source] -----> this approach failed . 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'. CSS ErrorBy default Tableau Desktop wraps fields from a secondary data source in an aggregation in calculated fields. But I cant add filter Month from the Budget Excel file. When you blend, you can only have aggregate access to the rows in the secondary. 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. To provide comparative data: Secondary data can be used to compare and contrast findings across different studies or datasets. The syntax for calling secondary data source field is not. Loading. Then try using the LOD expression from a secondary data source. We use three kinds of cookies on our websites: required, functional, and advertising. (I created calculated fields "Fiscal Year" and "Fiscal Month" on my secondary Superstore example to simulate this. Secondary Data Source: Contains data relating to the usage of a website (hits). 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). 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). It also means you cannot create a workbook using the. Hi . 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. Primary and Secondary Data Sources in Tableau: To perform blending in a Tableau sheet, there should be at least one secondary data source. 4. In your 2nd and 3rd data sources. I get error: “Cannot blend the secondary data source because one or more fields use an unsupported aggregation. Please post you twbx workbook so we can see if there a way . Secondary data sources cannot have logical tables (except when they satisfy specific conditions). I'm trying to show a distinct count of claims by branch. For example, when I try and pull in Cost per Order (cost coming from one source, and Orders coming from another) I get the "Cannot blend the secondary data source because one or more fields use and unsupported aggregation. LOD will not work if it is from the secondary datasource. Consider joining the two data sources together using Tableau Prep, and then you can use that data as a. I am using tableau 2020. 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. 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 . I have two data sets that are linked across Date and Product Category fields. All Answers. Please check the attached workbook for details. - Dataset 1, records the amount spent on ads as "Cost". I can't do a join because they are two different file formats. For more information, see Use Relationships for Multi-table Data Analysis. The problem is when I try to calculate the median of that same measure. I am trying to determine the Average Revenue per User by country for which my calculation is total revenue/unique subscribers. There are a few possibilities: 1) Flip the blend so the primary is secondary and vice versa. Hi All, Is there a way to use a parameter to work for secondary data source in blending. Final Words. A datetime field in the primary data source, for example, will not blend with a date field in the secondary data source. 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. It throws me cannot blend secondary data source one or more becuase one or more fields use unsupported aggregation . e. The primary data source will be identified automatically from any metrics you put on the worksheet first. In Tableau Desktop, navigate to Data > Edit Relationships. 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. 2)Count Distinct from Secondary workaround. So you need to create a Date field in your Master Data Source, which is why I usedAlternative to CountD function in Blending. The two values you mentioned, 5315 - Radio and 5345 - Public Relations, do not appear in your primary data source for 2012, but do appear in the secondary data source, so they cannot be included in the data. As 'Group' is from a secondary data source, I cannot simply use the sort buttons. The unsupported aggregation happens when your aggregate requires row-level visibility to the secondary data source. I receive this error: "Cannot blend the data source because one or more fields uses an unsupported aggregation". 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. Twbx and also the . The blend is not activated meaning a field from secondary DS is not used in the view. I like to have the ability to swap a primary data source with a secondary data source for data blending in a workbook. Currently, it's not working, the filter I try to add in the dashboard appears red in my spreadsheet and tells me that : "Data sources containing logical tables cannot be used as a secondary data source for data blending". 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. My goal is to show CY Actuals as bars, with a line for PY Actuals and a line for Budget. Good morning . However, when I follow your advice, each group splits into 6 rows (one for each month - January through June). For more information, see Use Relationships for Multi-table Data Analysis. Tableau has two inbuilt data sources named Sample-superstore and Sample coffee chain. The default view that you first see in the Data Source page canvas is the logical layer of the data source. In the formula text box, type the ZN function, the SUM. I think I need to define the relationship between the data sources. Any existing, automatic blend kontakte is visible (and pot be deleted by suspend over the row and clicking the x). 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. Just aggregates (like SUM, MIN, MAX. Hi Justin, Thanks for your quick reply. A datetime field in the primary data source, for example, will not blend with a date field in the secondary data source. 2) Use this duplicate field in the view instead of the original. AUMTable (Secondary) 3. 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". Data blending is a good option when you have multiple data sources that cannot be combined through relationships. This is the response I received from Tableau Support:Cause. 2 and later. - Dataset 1, records the amount spent on ads as "Cost" - Dataset 2 records the revenue generated by orders as "Proj. So, to do Data Blending, the steps that I would suggest would be: - Connect to the data sources that you need to use. Upvote Upvoted Remove Upvote Reply. Then, after data blending, the final graph cannot show the data related to the South and East. 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. Process for Creating the Dynamic “Parameter”. Maxdate) There is one more way, make the datasource which is using the fixed calculation to primary data source. A Level of Detail (LOD) expression is being taken from the secondary data source. ×Sorry to interrupt. Use the geographic role in the primary data source on detail instead of the dimension from the secondary data source. Resolution. AUMTable (Secondary) 3. With the release of Tableau 8. Viz cannot be filtered with secondary data source filter before loading the visualization so using "[DS_Name]. Chicken + Choice of Drink1 pc. 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. I noticed there was an issue using Data Blend from 3 different source. LOD expressions are used when running complex queries with multiple dimensions at the data source level. 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. [amount] into the view, it gives less than. Here is an example of what I am trying to accomplish:Data blending is a method for combining data from multiple sources. Common Issue #1: Cannot blend the secondary data source because one or more fields use an unsupported aggregation The aggregation methods of COUNTD,. 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. The secondary data source need to be my transaction file and primary data source need to be my budget file. Primary Data Source: Contains a list of all employees and their role. Community Manager update. Blending requires primary and secondary data sources. Are you talking about Tableau Prep or Tableau Desktop? Any chance you can share a sample of your data? Expand Post. You cannot filter data across secondary data sources. A secondary data source can be used to re-alias the field values in a primary data source. Non-additive engine are entirety functions that errichten outcomes that cannot be aggregated along a dimension. 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. order_date = B. Expand Post. ). I am trying to use the below formula instead of countd function because my data comes from Impala. Filtering data across a worksheet's secondary data source is not currently supported in Tableau Desktop. 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. If you have to have row-level access on a. 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. You can choose whether functional and advertising cookies apply. The relationship is on the facility ID. Chicken + Choice of DrinkBurger + Choice of DrinkSpaghetti + Choice of Drink . For more information,. In the calculation dialog box, do the following: In the name text box, enter Sales for Store - South. Since my Workbook is present inside Office premise. In data blending, there is a primary data source and a secondary data source. 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. We can see these by activating secondary data source and looking at the dimensions window, the linking dimensions will have an orange chain icon. For example, COUNTD(). It is important to understand which is the primary source, it can impact your view. 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. This happens only when the data sources are impala. First data source looks like below. Moreover, blending is a kind of left join, not exactly a join. 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. when I use A as primary data source and drag A. Data source A has Role Column and Data source B also has Role Column. Resolution. Common warnings and errors when blending data sources No relationship to the primary data source. Please attach. - Data to Map from - Data to Map to . So, basically, I am having issues with 2 calculations - the FIXED LOD and Remaining Value. I am blending (2) data sources based on the date. In the actual data I get the error: Cannot blend the secondary data source because one or more fields use an unsupported aggregation. But the source calc is a countD. I have two datasets; one is a shape file that contains regions and locations. However, when I follow your advice, each group splits into 6 rows (one for each month - January through June). You can also define the relationship manually by right-clicking on the data source name in the Data pane, and selecting Relationships. Each has a joining field with the same name. General Information. All the data is in the secondary/blended data source. The date values must be in the same format. I'm blending student data (primary) and staff data (second). 2, users would define joins and unions between physical tables in which Tableau would create a singular, flat table for analysis. CSS ErrorLoading. data source. the blended data cannot be published to Tableau Online or Tableau Server. Fee". I've blended on user ID. Tableau Desktop 2018. Marked as. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. Community Manager update. Upvote Upvoted Remove Upvote Reply. When I put category on either the row or column shelf I am getting the erro r "Cannot blend the secondary data source because one or more field use an unsupported aggregation". Remove all dimensions from the secondary data source and ensure that the primary data source’s linking field is in view. A datetime field may be converted to a date field using a calculation to remove the time portion. Data blending has some limitations regarding non-additive aggregates such as COUNTD, MEDIAN, and. The limitation with Tableau and secondary data sources stinks. E make table 2 the primary and table. Few things you need to keep in mind while blending data sources in tableau. You combine data in the logical layer using relationships (or noodles). Data blending brings in additional information from a secondary data source and. 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. We use three kinds of cookies on our websites: required, functional, and advertising. But I cant add filter Month from the Budget Excel file. This feature would be really useful to ensure we can. Use a parameter with a calculated field to filter the secondary data source at the row level. I tried data blending using the zip codes as a common field but I am facing very slow performance. We cannot publish a blended data source as a single data source on the server. 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. Another way to approach this is to do a join of the data outside Tableau via a federated data source. I'm trying to show a distinct count of claims by branch. A datetime field in the primary data source, for example, will not blend with a date field in the secondary data source. How to tackle “Cannot blend the secondary data source because one or more fields use an… How to tackle “Cannot blend the secondary data source because one or more fields use an unsupported aggregation” while blending Multiple data sources. Here is situation I am facing, I have blended two data sources and created a worksheet. Here's the data blend view with the secondary data source selected so we can see what blend fields are used:. Resolution. In your case, you're after the Total Cases by Employee, so just imagine Employee in place of Category. This didn't work alas, "cannot blend secondary data source because one or more fields use an unsupported aggregation" I am using a filter from a different datasource to filter by region . 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. In the Add/Edit User Mapping dialog crate, do the following: Select a select by the primary your data. I am trying to create a waffle chart. 0 and 7. Expand Post. Twb, . 1. I'm blending the 2 data sources by Service_Id. 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. 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". Loading. This can restrict many values from the secondary data source. Secondary Data Source: Extract W. (It is a field that contains account names (company) in the sample data. Observations : 1. " Filtering Across Multiple Data Sources Using a Parameter; Cause A sheet cannot be filtered by a field from a secondary data source. Hello Jim, Thank You for your reply. This means that when a cube data source is published, you cannot make a connection from Tableau Server using the data source. The Products set contain the individual products within an Opportunity whereas the Opportunities set contain Sales metrics (i. We are blending two data sources. For more information, see Troubleshoot Data Blending; Blended data sources cannot be published as a unit. CustomOverall (Primary) 2. Loading. In the data window, the blue tick indicates the Primary data source (Sales in the image below). 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. They both share a common field (State), and that is what I'm filtering on. THEN add this total to the SUM of the projected_users from today's date through month X. Tableau automatically adds an aggregation (SUM) around the column from the secondary source. 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. 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. Pick the secondary data source in of Secondary data source pane. 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. 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. In blending data source, I try to slove problem but I can't. I have 2 separate data sources that have similar fields. Cannot Blend Secondary Data Source - Unsupported Aggregation. I'm using a cube data source as my primary and am attempting to blend with. id, A. Please see if it helps , here it says that problem is with COUNT & they have provided one alternative way as well . with blends, we are only able to support aggregates (like SUM, MIN, MAX. I noticed that when the spatial file is the secondary data source, I cannot area plot it by double clicking the geometry variable. 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. Next, create a table calc using the [Start KM] to calculate the total KMs: from Primary data source from Secondary data source. 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. I get error: “Cannot blend the secondary data source because one or more fields use an unsupported aggregation. 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. Hi there, I got a question about how can I count distinct customer ID? I have 10k customer IDs, some of them appear more than once. I am trying to . Make the field(s) used to address the table calculation active linking fields. 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. e. Place Organisation Identifier on the level of detail shelf (from the primary source, or both sources) and the blend should work.