I am trying to create a waffle chart. In the data window, the blue tick indicates the Primary data source (Sales in the image below). Cannot blend the secondary data source because one or more fields use an unsupported aggregation. Marked as. I have been working on Blending feature for a while in different situations and. I am trying to . THEN add this total to the SUM of the projected_users from today's date through month X. 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. Excel . CSS ErrorBy default Tableau Desktop wraps fields from a secondary data source in an aggregation in calculated fields. I am using tableau 2020. 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 . Resolution. [OIL DATE]) THEN MIN ( [KMs]) END. 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 change that. Expand Post. Credits to Jonathan Drummey for the below workaround 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. I am getting Cannot blend secondary data source because one or more fields used an unsupported aggregation. 2 and later. So, in the dummy data, there are two tables from two data sources. Hi. the branch field I'm using from the primary data source. Hi there, I got a question about how can I count distinct customer ID? I have 10k customer IDs, some of them appear more than once. If you have to have row-level access on a. Data of any sort coming from a secondary source must come as an aggregate of some sort. This feature would be really useful to ensure we can. Use the geographic role in the primary data source on detail instead of the dimension from the secondary data source. Upvote. So yes, in [Actual Hrs] you can only use the value from the secondary as an aggregate, and that's why you see: SUM([Networkdays (Test blend data calculation)]. Also, data blending is useful for combining data from published. Data blending works like a ___ join. Applies to: Tableau Cloud, Tableau Desktop, Tableau Server Data blending is a method for combining data from multiple sources. 1 because it can cause Tableau to unexpectedly quit. 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. Thanks. 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. CSS ErrorIF user chooses month X and parameters/filters like gender/age/etc, THEN count all distinct users from data set #2 where the date of data set #2 is from 2017-08-01 through today's date. Ken Flerlage (Member) 5 years ago. Let say from DS1 if i am making it as primary datasource then i can get the. This would be a great time saver, with all of the calculations and linking changing as well. And I can't explain why it does that. newBranchProjection (Secondary) When I try to add COUNTD([DistrictId]) from my primary to text table. Unknown file type Total from Secondary Data Source. Instead, publish each data source separately (to the same server) and then blend the published data sources. 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. 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. Because in Tableau, you don't use COUNTD function when Blending data source. on Rows, Columns, Pages, or the Marks Card. CSS ErrorAfter Blending, Now it is showing this error: Cannot blend the secondary data source because one or more fields use an unsupported aggregation. This can restrict many values from the secondary data source. Secondary data source: spatial file containing the geometry. An orange tick indicates a secondary data source (Promotions). Error: Cannot blend the secondary data source because one or more fields use an unsupported aggregation I have a primary data source coming from a published data extract blending with a secondary data source coming from an Oracle Database. A datetime field may be converted to a date field using a calculation to remove the time portion. Remove all dimensions from the secondary data source and ensure that the primary data source’s linking field is in view. There's no way to "swap. Instead, publish each data source separately (to the same server) and then blend the published data sources. All data from a secondary source comes back as an aggregate -- even if there is only one value from the secondary source. I have two data sources which I have blended together on two fields: branch and date. [OIL DATE]) THEN MIN ( [KMs]) END. This is interesting. Fields from the secondary data source used in the view have an orange check mark. Seemingly simple task is getting complicated in Tableau . Another way to approach this is to do a join of the data outside Tableau via a federated data source. Not able to share for time being. Step 1: Create the Parameter. 1. This can help researchers identify. I'm using a cube data source as my primary and am attempting to blend with. I've created the first chart with no problem, but I. Fee - Cost) over time. You will need a common column between the two tables in order to blend. A data blend cannot filter on dimensions that do not exist in the Primary data source. 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. Does anyone have any Ideas how I can apply a universal filter to 5 different unrelated data sources? Applies to: Tableau Cloud, Tableau Desktop, Tableau Server. The secondary data source just pulls in some names to associate with ID numbers in the primary and some filters for the staff data. For more information,. 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. LOD will not work if it is from the secondary datasource. Data blending has some limitations regarding non-additive aggregates such as COUNTD, MEDIAN, and RAWSQLAGG. A datetime field may be converted to a date field using a calculation to remove the time portion. I have uploaded this dummy file since I cannot upload my real data here. In the attached file, table shows the sum of sales and first order date correctly from both the. I establish the blend relationships explicitly by going to Data -->Edit Blend Relationships, and selecting the fields that should be related. ” Causes and Workarounds for a Blending Limitation Errors. "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. You can read details here: Logical Tables in Secondary data source. IF ATTR([Offer Status]) = "Hired" Then AVG([Comp_File]. General Information. Cannot blend the secondary data source because one or more fields use an unsupported aggregation issue. For more information, see Use Relationships for Multi-table Data Analysis. Secondary Data Source: Contains data relating to the usage of a website (hits). Expand Post. 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. Your secondary data source does not have the blend activated, you'll need to click on the link and turn it red to activate:. Upvote Upvoted Remove Upvote Reply. I can get all the fields into the view apart from the 'is vat exempt'. 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". In data source A, I have COUNTD(Person ID) and in data source B, I have COUNTD(Person ID). g. However, when I follow your advice, each group splits into 6 rows (one for each month - January through June). The date values must be in the same format. Maxdate) There is one more way, make the datasource which is using the fixed calculation to. Please find the complete blog here ----> COUNTD with secondary DS Tableau(Blending) Workbook is attached. Please see if it helps , here it says that problem is with COUNT & they have provided one alternative way as well . 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'. 3 and I have created aggregates AGG for fields from data extract and excel file. There's a set of views/calcs that show a metric, (metric C) counting distinct number of accounts contacted per person per week (e. Help would be much. Chicken + Choice of DrinkBurger + Choice of DrinkSpaghetti + Choice of Drink . No. 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. "Budget" is only contained in an Excel file data source. Data blending have some limitations regarding non-additive total such like COUNTD, MEDIAN, and RAWSQLAGG. Please attach. I tried data blending keeping File C as primary and A & B as secondary data source with DD number as relationship. Primary and Secondary sources in data blending. Data sources can contain logical tables not be used as secondary data sources for data blending. Good morning . Then you can simply show one filter control on your dashboard and set it to apply to all related data sources. If that does not help,. But I cant add filter Month from the Budget Excel file. For more information, see Troubleshoot Data Blending; Blended data sources cannot be published as a unit. Any help would be appreciated!Also a data blend is only a LEFT join. As 'Group' is from a secondary data source, I cannot simply use the sort buttons. Now we have to use W2 as Filter - to filter out the data. 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. 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. 2. However, when the linking dimension is not in the view, non-additive aLoading. In this case the cross database join will effectively act like the. The default view that you first see in the Data Source page canvas is the logical layer of the data source. then i added a secondary data source from google sheet , which has the fuel amount. I cannot able to use as one connection since am using the data source filter in my first connection have data source filter. So you don't get in the case of data blending. From my primary data source I have a dimension in columns say 'Customer Segment'. 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. 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. The primary data source will be identified automatically from any metrics you put on the worksheet first. 1, the ability to "Show Empty Rows" (or columns) was removed when you use a secondary data source. The condition is offer status = hired, but offer status can contain my different response types. This happens regardless if I drag it on the rows or on the Marks space as a 'text'. Resolution. For more information, see Use Relationships for Multi-table Data Analysis. 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". 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). The concept of data blending is, for every match in the primary table there should be exactly one row item in your secondary table, in the view of this concept any aggregation on the secondary table will always be distinct by default. Data blending is particularly useful when the blend relationship—the linking fields—need to vary on a sheet-by-sheet. I am confused, as I am not even trying to blend Data from both Data Sources. , 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. According to Tableau, this error can also appear when using a LOD expression in a blended view. I can add to filters from the data extracts. 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. Does anyone have any Ideas how I can apply a universal filter. I have two data sources which I have blended together on two fields: branch and date. The data is tracked at the subsite level, so I've utilized LOD calculations to determine the min login time and the max logout time fixed on the site level. This is one of the disadvantages of data blending in Tableau. Why are values from the secondary data source not appearing in a blended data source view? They did not exist in the primary data source. CSS ErrorHi Mavis Liu. This feature would be really useful to ensure we can. I have some extra supplemental data in a CSV file that I would like to join to one of the common fields between the two so I can pull some of the SSAS measures by the supplemental data's dimensions that I've blended. - Dataset 1, records the amount spent on ads as "Cost" - Dataset 2 records the revenue generated by orders as "Proj. You must double-click a logical table in the Data Source page canvas to go to the physical layer of the canvas. 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. Cannot blend the secondary data source because one or more fields use the == function, which cannot be computed locally. A datetime field in the primary data source, for example, will not blend with a date field in the secondary data source. I'm blending the 2 data sources by Service_Id. 4, I tried to blend products (secondary) to storefront (primary) based on Sku. (It is a field that contains account names (company) in the sample data. Some of the function doesn't work properly when we use blending like COUNTD(), LOD{} expression. Upvote Upvoted Remove Upvote Reply. The version I am working with 10. I have two datasets; one is a shape file that contains regions and locations. When you data changes, you need to redo the. Dominic Laird(Member) 5 years ago. This happens only when the data sources are 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. But the source calc is a countD. This means a data blend can’t be published as a data source for others to use. The Products set contain the individual products within an Opportunity whereas the Opportunities set contain Sales metrics (i. CSS ErrorCannot blend the secondary data source because one or more fields use an unsupported aggregationFollow this link for more information:the secondary data source always has to be aggregated, there's no way to do a row level check to filter out any dimension members that match between the two data sources. You cannot filter data across secondary data sources. - Data to Map from - Data to Map to . ×Sorry to interrupt. 1) Duplicate the field in primary datasource. Resolution. 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. 4. We can see these by activating secondary data source and looking at the dimensions window, the linking dimensions will have an orange chain icon. Option 2: Join tables that are in the same data source, instead of blending them. 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. Here is situation I am facing, I have blended two data sources and created a worksheet. This is the final step and will result in filtering between the blended data sources at your desired level of granularity. Since my Workbook is present inside Office premise. I'm trying to show a distinct count of claims by branch. Proj. In second data source i don;t have salesrep column. Verify if one of the measures coming from the cube data source has a default aggregation different than SUM, MIN, MAX, COUNT. Another way to approach this is to do a join of the data outside Tableau via a federated data source. One small workaround which you can do is: 1) Create a calculation as {Max([Date])} 2) Create a parameter as follows: 3) Create a calculation as . The limitation with Tableau and secondary data sources stinks. So if you drag Category from the Orders data source, it will automatically mark Orders as the primary data source. I am trying to determine the Average Revenue per User by country for which my calculation is total revenue/unique subscribers. drag the secondary measures to measure values section . 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. In the past, I've just changed my primary table to the one with the calculation. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. Input cannot become used from the [name are secondary data source] data source, because there is no blend relationship to the primary data source. you get all data from main data source and ONLY matching data from secondary data source. Beginning with Tableau Desktop 2020. "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. This means a data blend can’t be published as a data source for others to use. Before I check Date filters, I got this results. Please check the attached workbook for details. A datetime field may be converted to a date field using a calculation to remove the time. I am confused, as I am not even trying to blend Data from both Data Sources. The primary data source is just to filter for the invoices I want to look at. 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. See Join your Data for instructions. 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. They must be in the same format. If there is another. Resolution. 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. The unsupported aggregation happens when your aggregate requires row-level visibility to the secondary data source. I have two data sources to be used but need the count distinct of users from both the data sources. I have a primary data source coming from a published data extract blending with a secondary data source coming from an Oracle Database. 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. You can choose whether functional and advertising cookies apply. The version I am working with 10. 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. Tableau has two inbuilt data sources named Sample-superstore and Sample coffee chain. Ritesh Bisht (Member) 6 years ago. FIXED requires that you have row-level access to the rows in the secondary source. Right-click in the Data window and then. I have two data sources and doing a data blend. I can add to filters from the data extracts. How do I blend these data sources by year? - The Tableau Community. 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. " Filtering Across Multiple Data Sources Using a Parameter; Cause A sheet cannot be filtered by a field from a secondary data source. The secondary data source need to be my transaction file and primary data source need to be my budget file. 3 and I have created aggregates AGG for fields from data extract and excel file. Expand Post. We are blending two data sources. If multiple logical tables are related in a Tableau data source that source cannot be used as the secondary data source in a Tableau data blend, it can only be used as the primary Therefore one workaround is the Create Primary Group function that you described which "copies" the field from B into A as a group. If this aggregation is ATTR() then the grand totals may be blank. Status, Stage, etc). Blending with CountD and LODs. 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. Left. The secondary data source is indicated with an orange tick on the data source and an orange bar down the side of the Data pane. 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. I'm noticing you are using the Date field from the secondary data source you are working with. xls files). Both fields are linked in worksheet. Common Issue #1: Cannot blend the secondary data source because one or more fields use an unsupported aggregation The aggregation methods of COUNTD,. Data blending is particularly useful when the blend relationship. Make the field(s) used to address the table calculation active linking fields. Hi . I think I need to define the relationship between the data sources. 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. Instead of using relationships, double-click into your table to get to the. If you create a quick filter on a field from data source 1 and apply this quick filter to. 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. Consider joining the two data sources together using Tableau Prep, and then you can use that data as a. The date values you want to blend on must exist in both data sources. Set up the primary and. We cannot publish a blended data source as a single data source on the server. I have two data sets: the first data set is a shp file from data. The problem is when I try to calculate the median of that same measure. I receive this error: "Cannot blend the data source because one or more fields uses an unsupported aggregation". Data blending is a method for combining data from multiple sources. 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". Can't see what you are actually doing but Blending data has its limits. Data & Connectivity. Good morning @Fred Yu (Customer) . please check the attached workbook. Option 1: Join the data sources with a cross-database join instead of blending. 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. There is a possibility that the values can be restricted from the secondary data. No long-term contract. Click on the ‘Add Action’ button and choose ‘Change Set Values’. E make table 2 the primary. 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. Data > Edit Relationships . The relationship is on the facility ID. 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. Drag the 2016 Population measure to the Columns. The reason of the errors being unsupported calculation in blend. Fields cannot be used from the [name of secondary data source] data source, because there is no blend relationship to the primary data source. Few things you need to keep in mind while blending data sources in tableau. Primary and Secondary sources in data blending. 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. However, when I follow your advice, each group splits into 6 rows (one for each month - January through June). Jim. ) If only one of the tables requires row level information, consider making that the primary data source in the blend (I. In your case, you're after the Total Cases by Employee, so just imagine Employee in place of Category. And I want to add one of the field from secondary dataset to be in the filter. Because the question is related to how the data sources are being related, it would help to see the real data structure. ×Sorry to interrupt. Loading. For example, sheet A uses data source 1 as the primary data source; sheet B uses data source 1 as the secondary data source. I've tried using COUNTD() ID First Last 1 Jim Carrey 1 Jim Carrey 2 Liam Neeson 3 Wynona Ryder COUNT([ID]) = 4 COUNTD([ID]) results in error I can add to filters from the data extracts. (I created calculated fields "Fiscal Year" and "Fiscal Month" on my secondary Superstore example to simulate this. Now, in dashboard D1 : has two worksheets W1 and W2. Data blending is particularly useful when the blend relationship—the linking fields—need to vary on a sheet-by-sheet. the count of claims I'm getting from the secondary data source, by counting distinctly a measure called claimid. 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. Overall LOD will show correct result in Primary datasource. "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. If you create a quick filter on a field from data source 1 and apply this. I am getting Cannot blend secondary data source because one or more fields used an unsupported aggregation. Advantages: Very easy to write and implement. I ended up purchasing an Alteryx license for our company (we now have a lot. 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. See Troubleshoot Data Blending - Tableau for more information on this and other errors that may occur while using data blending. I have 2 separate data sources that have similar fields. In this case, I use Last() as a filter to hide the other rows except the last one and each LOD calculation and blended data sources. 2, users would define joins and unions between physical tables in which Tableau would create a singular, flat table for analysis. Data source filters. I have two data sets that are linked across Date and Product Category fields. Next, create a table calc using the [Start KM] to calculate the total KMs: from Primary data source from Secondary data source. Fields from the secondary data source used in the view have an orange tick. You can choose whether functional and advertising cookies apply. I tried data blending using the zip codes as a common field but I am facing very slow performance. We cannot use ATTR if trying to create an LOD type calculation if blending data sources. 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. 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. targets. If you want to filter data across secondary data sources, consider. 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. Make sure that you are blending on dimensions present in the view or on. In my primary, I define another calculated field to do the aggregation for each project by tier: VendorClass: if max [Secondary]. Change the default sort order of the field using the various options, and then click OK. Current Year Actuals and Prior Year Actuals are housed in a corporate transnational data source. Blending runs a query on each data source and joins the aggregated results of those queries. Data blending is particularly useful when the blend relationship—the linking fields—need to vary on a sheet-by-sheet. 2)Count Distinct from Secondary workaround. I am able to achieve the desired results but I am getting a warning ' Fields cannot be used from the [name of secondary data source] data source, because there is no blend relationship to the primary data source. 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. 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. I am trying using { FIXED : SUM[(portfolioValue)]}. Data blending is a method for combining data from multiple sources. I made a waffle chart grid using an excel data source that contains 3 fields: Rows, Columns and Percentage. To overcome this, I've added a filter straight into the data source and not in the view. 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. month([date])=month(Parameter. [Work Hours]) So you have to make. "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. " inner cross database join on BU Code with a data source filter set up on UPPER([ID])=UPPER(USERNAME()) on the DS2 source. But there are few workaround for it. i. Cannot blend the secondary data source because one or more fields use an unsupported aggregation" when Data Blending. 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. if you have blended data sources you can not use lods One of the drawbacks of blended sources . In this source create a calculated field to pull out the KMs on the date of oil change. order_date. Hello Jim, Thank You for your reply. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. Also, in the attached I have added both Calc1 and Calc2 to the tooltip in Sheet 9. 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. How to calculate Delta value. Primary and Secondary Data Sources in Tableau: To perform blending in a Tableau sheet, there should be at least one secondary data source. Viz cannot be filtered with secondary data source filter before loading the visualization so using "[DS_Name]. 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. Resolution. ×Sorry to interrupt. I have two data sources and I have blended them together. Size() is a great choice for unique counts across data sources if you can create a view where every unique row is displayed. While on a view, right click a data source, click replace data source. Loading. 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. Name: Distinct Count. 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. When you blend, you can only have aggregate access to the rows in the secondary source. Data blending tools can present their findings as visualizations, such as infographics and charts, after querying data sources and aggregating relevant information. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. Are you talking about Tableau Prep or Tableau Desktop? Any chance you can share a sample of your data? Expand Post. I'm trying to show a distinct count of claims by branch. All the data is in the secondary/blended data source. The unsupported aggregation happens when your aggregate requires row-level visibility to the secondary data source. I am trying to blend the same data against the other because I wanted to show Same Period last Year. 2) DB2 blending doesn't support non-additive aggregates like COUNTD() from secondary sources. In the Data pane, switch to the [name of secondary data source] data source, and click at least one link icon to blend these data. "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. And I use Join data source, after divide measures / row duplicate. Mihai Constantinescu (Member) 6 years ago. It also means you cannot create a workbook using the. Data blending brings in additional information from a secondary data source and displays it with data from the primary data source directly in the view. I am using tableau 2020. 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. 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.