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. I am getting Cannot blend secondary data source because one or more fields used an unsupported aggregation. For example, COUNTD(). 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. Size() is a great choice for unique counts across data sources if you can create a view where every unique row is displayed. Beyond that personally I tend to do the work necessary to avoid using data blending in production data sources & views. Secondary Data Source: Contains data relating to the usage of a website (hits). According to Tableau, this error can also appear when using a LOD expression in a blended view. Upvote. The reason of the errors being unsupported calculation in blend. Call it [Start KM]: IF ATTR ( [KM Date])=ATTR ( [OIL]. However, some days will have entries for "Cost" but not for "Proj. "Filtering Across Multiple Data Sources Using a Parameter; Cause A sheet cannot be filtered by a field from a secondary data source. In the attached file, table shows the sum of sales and first order date correctly from both the. Please check the attached workbook for details. Any existing, automatic blend kontakte is visible (and pot be deleted by suspend over the row and clicking the x). Seemingly simple task is getting complicated in Tableau . Verify if one of the measures coming from the cube data source has a default aggregation different than SUM, MIN, MAX, COUNT. ) A LOD calc is also trying to do stuff at the row level. Another way to approach this is to do a join of the data outside Tableau via a federated data source. e. 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. "Cannot blend the secondary data source because one or more fields use an unsupported aggregation" I have tried the following calculations but have not been able to figure this out. Cannot blend the secondary data source since one or more search use certain unsupported aggregation. 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. you are blending the 2 excel data sources - blending takes place after the structure for data table for the worksheet has been established - and that is done as you bring dimensions to the rows and columns and apply filters to those dimensions - you will not be able to filter across data sources except at the link after that pointđź’ˇ Ability to switch primary and secondary data sources. 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. 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. In this example, Superstore Sales is the primary data source and Coffee Chain is the secondary data source. Both fields are linked in worksheet. Are use of grouped fields not allowed in data blending? I have two data sources: Opportunities and Products. Upvote Upvoted Remove Upvote Reply. ”. Overall LOD will show correct result in Primary datasource. Data blending has some limitations regarding non-additive aggregates such as COUNTD, MEDIAN, and. 1. Resolution. Fee". 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. I noticed there was an issue using Data Blend from 3 different source. I've blended on user ID. Make sure that you are blending on dimensions present in the view or on all of the. Cannot blend the secondary data source because one or more fields use an unsupported aggregation issue. Change the default sort order of the field using the various options, and then click OK. 3. Select Analysis > Create Calculated Field. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. 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. 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 . Any help would be appreciated!Also a data blend is only a LEFT join. Current Year Actuals and Prior Year Actuals are housed in a corporate transnational data source. You have a nice example to use for filing a support case, and I recommend that you do that. Instead of using relationships, double-click into your table to get to the. I am trying to use the below formula instead of countd function because my data comes from Impala. 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. Status, Stage, etc). Instead, publish. The date values must be in the same format. "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. png - Ben-Sullins's library "Cannot blend the secondary data source because one or more fields use an unsupported. 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. blending takes place in step 6 of the Order of Operation after all the context and dimension filters have been applied - you will not be able to filter across the data sets after that point - you would need to have joined data or use a relationship The issue comes when I try and add a metric that is an aggregate of the two different sources. Fields cannot be used from the [name of secondary data source] data source, because there is no blend relationship to the primary data source. ) If only one of the tables requires row level information, consider making that the primary data source in the blend (I. That's probably your problem. Blending requires primary and secondary data sources. In order to create the waffle chart I am blending it with another datasource using the calculated field defined as [Week 5 (Week5Bond)]. 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. "Cannot blend the secondary data source because one or more fields use the == function, which cannot be computed locally. “Cannot blend the secondary data source because one or more fields use an unsupported aggregation. Currently, data sources that contain logical tables cannot be used as secondary data sources for data blending. Because the question is related to how the data sources are being related, it would help to see the real data structure. If there is another. 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. In the Relationships dialog box, under Secondary data source select Custom, and then click Add. Tableau has two inbuilt data sources named Sample-superstore and Sample coffee chain. Place Organisation Identifier on the level of detail shelf (from the primary source, or both sources) and the blend should work. 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. 2 came the introduction of a brand-new data model. 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. 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. * Blend in the summary of a large dataset to reduce query time. LOD will not work if it is from the secondary datasource. The data source with the KMs is the primary source. 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. I get error: “Cannot blend the secondary data source because one or more fields use an unsupported aggregation. There is a possibility that the values can be restricted from the secondary data. Try one of the following options, as appropriate for your workbook: It may be possible to cross database join instead of blending. 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. Viz cannot be filtered with secondary data source filter before loading the visualization so using "[DS_Name]. In the Data window, right-click the relevant field. 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. All customer IDs are under a dimension called "Global ID". AUMTable (Secondary) 3. ” We use three kinds of cookies on our websites: required,. 1. 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. For more information, see Troubleshoot Data Blending; Blended data sources cannot be published as a unit. Filtering data across a worksheet's secondary data source is not currently supported in Tableau Desktop. 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'. I get error: “Cannot blend the secondary data source because one or more fields use an unsupported aggregation. I am trying to blend the same data against the other because I wanted to show Same Period last Year. Additional Information While replacing ATTR() with MIN() will cause "Automatic" grand totals to show, the grand totals might not be the expected values. Filter each of the data sources independently on the more granular dimensions. Someone in the Community told me the following:A common use case for my analysis is blend a secondary data source then do a table calculation with various independent measures (thus I cannot apply filters). Cannot blend the secondary data source because one or more fields use an unsupported aggregation. 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. 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. The reason your blend breaks is that you're blending with Location as a linking field, so when you remove that from your view, Tableau can't blend any longer. Chicken + Choice of DrinkBurger + Choice of DrinkSpaghetti + Choice of Drink . You can choose whether functional and advertising cookies apply. This is a new complexity in Tableau v8: In v7 and earlier, to blend we had to have the linked dimensions in the view, i. 0 but was disabled (greyed out) in 8. Therefore it cannot display null data. 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. 1. From my primary data source I have a dimension in columns say 'Customer Segment'. For more information, see Troubleshoot Data Blending; Blended data sources cannot be published as a unit. A datetime field may be converted to a date field using a calculation to remove the time portion. If you want to filter data across secondary data sources, consider. Notice that Calc1 gives you an asterisk if there are multiple values returned from the secondary source. 1) Duplicate the field in primary datasource. A datetime field in the primary data source, for example, will not blend with a date field in the secondary data source. " I have seen a few posts on it and found an issue logged about it as far back as version 8. But there are few workaround for it. It takes advantage of the data collected from previous research and uses it to carry out new research. Expand Post. 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. Data sources can contain logical tables not be used as secondary data sources for data blending. Also, in the attached I have added both Calc1 and Calc2 to the tooltip in Sheet 9. 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. Status, Stage, etc). 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. Hello Ritish, You could use Size() and a Las() function as a filter and get the same output. Sometimes , it's automatically working but sometimes it says 'Unsupported Aggregation' . order_date. In this source create a calculated field to pull out the KMs on the date of oil change. If you create a quick filter on a field from data source 1 and apply this. Expand Post. Both Primary and Secondary data sources have duplicate rows due to multiple joins in data prep. 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. Good morning @Fred Yu (Customer) . The order in which fields are used determines which data source is the primary versus the secondary data source. To alias field values. 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. Hi All, Is there a way to use a parameter to work for secondary data source in blending. I'm blending the 2 data sources by Service_Id. See Troubleshoot Data Blending - Tableau for more information on this and other errors that may occur while using data blending. Loading. amount into the view, it gives me the correct sum. Next, create a table calc using the [Start KM] to calculate the total KMs:Error: Cannot blend the secondary data source because one or more fields use an unsupported aggregation. The version I am working with 10. 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". I am trying to use the measures name filter functionality with two data sources. 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. id, A. How to calculate Delta value. A datetime field in the primary data source, for example, will not blend with a date field in 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:. Process for Creating the Dynamic “Parameter”. 1. Chicken + Choice of Drink1 pc. Currently, data sources that contain logical tables cannot be used as secondary data sources for data blending. However, when the linking dimension is not in the view, non-additive aLoading. Functional cookies enhance functions, performance, and services on the website. Instead, publish each data. This. E make table 2 the primary. There's no way to "swap. We don't get row-level data from secondary sources on a. Community Manager update. 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. To overcome this, I've added a filter straight into the data source and not in the view. 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. Select Default Properties > Sort. I tried data blending using the zip codes as a common field but I am facing very slow performance. Data blending is a method for combining data from multiple sources. Some examples include: cookies used to. This can restrict many values from the secondary data source. I have two data sets that are linked across Date and Product Category fields. A data blend cannot filter on dimensions that do not exist in the Primary data source. I have quick filters from the primary data source and I am trying to represent distinct. The two data sources are identical. I'm blending the 2 data sources by Service_Id. [Cash PTM]) Else [Null] ENDIn your example, this doesn't work, because your primary data source needs to be Master Store List, because you want to list all the store IDs. The data are sorted, but each row only shows one month of data with the other five columns blank. I want to do a basic data listing showing customer, order no, postcode & vat exempt. Selected as Best Selected as Best Upvote Upvoted Remove Upvote 1 upvote. You can use data blending when you have data in separate data sources that you want to analyze together on a single sheet. Data coming from a secondary source is ALWAYS aggregated at the level of the link - even if there is 'no need to add anything' that's just the way blending works - it happens after the data table dimensions are set and you are loading values into the data table for the individual worksheet additionally, data coming from the secondary source are always aggregated at the level of the link when brought to the primary source - the individual records are no longer available and you are not able to filter across the various data sources at that point - that is the long way of saying you will have to join or use a relationship - not. . Beginning with Tableau Desktop 2020. I am trying to create a waffle chart. Now you see a new group field listed in the Population data source (primary) called State (group). This means a data blend can’t be published as a data source for others to use. As 'Group' is from a secondary data source, I cannot simply use the sort buttons. CSS ErrorHi Mavis Liu. From Primary Data Source drag the measure names and measure values . Resolution. I receive this error: "Cannot blend the data source because one or more fields uses an unsupported aggregation". I am using blending and created Relationship but i am having problem in terms of getting distinct count from one of the data sources. The limitation with Tableau and secondary data sources stinks. 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. 0 and 7. Nitish Pamarty (Member) 7 years ago. I have two data sources and I have blended them together. Data blending is a method for combining data from multiple sources. Unsupported aggregations in data blending Hello, I have a distributor dataset with product ships and returns (one report covering six months), and a retailer dataset with product retail sales and stock (covering the same six months but composed of. The date values you want to blend on must exist in both data sources. Date dimensions: For cube data sources, date dimensions are typically organized into hierarchies that contain levels such as year,. The blend applies to that worksheet only. Does the. The concept of data blending is, for every match in the primary table there should be exactly one row item in your secondary table, in the view of this concept any aggregation on the secondary table will always be distinct by default. In your case, you're after the Total Cases by Employee, so just imagine Employee in place of Category. When blending in Tableau, there is always a primary source and a secondary data source. But seems we cannot blend 2 secondary data source with same field. "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. 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. Thank you . When I make the data source as Primary, I am able to see the respective values, Kindly see the below screenshot:-  But, when I consider this data source as secondary and then try to use it in primary data source sheet, I get this error:- Cannot blend the secondary data source because one or more fields use an unsupported aggregation. Become a Better Analyst in Just 5 Minutes a Week. It is important to understand which is the primary source, it can impact. 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). And I want to add one of the field from secondary dataset to be in the filter. 3 and I have created aggregates AGG for fields from data extract and excel file. I would like to ask for your help, I do have two data sources: BI Cube (primary source) & Excel file (secondary) BI Cube Data 1 pc. Use a parameter with a calculated field to filter the secondary data source at the row level. While on a view, right click a data source, click replace data source. So you need to create a Date field in your Master Data Source, which is why I usedAlternative to CountD function in Blending. BR, NBBlended data sources cannot be published as a unit. Step 2: Make it a context filter. Some examples include: session cookies needed to transmit the website, authentication cookies, and security cookies. month([date])=month(Parameter. Another way to approach this is to do a join of the data outside Tableau via a federated data source. Just aggregates (like SUM, MIN, MAX. 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. . Cannot blend the secondary data source because one or more fields use an unsupported aggregation. With the recent release of Tableau Desktop 2020. Advantages: Very easy to write and implement. The default view of Data Source canvas is the logical layer in Tableau version 2020. Ritesh Bisht (Member) 6 years ago. I have two data sets: the first data set is a shp file from data. As we know the link cant be established unless we use this common dimension (Region Filter) in the view, we can mimic the view by adding the Region Filter Dimension to rows/Columns shelf and uncheck the show header. 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". So, to do Data Blending, the steps that I would suggest would be: - Connect to the data sources that you need to use. Option 2: Join tables that are in the same data source, instead of blending them. If I cant go the above way then is there a possibility to do the duration calculation using table calculations or some other way. I'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. Best solution. Now, in dashboard D1 : has two worksheets W1 and W2. The solution. 4. 4, I tried to blend products (secondary) to storefront (primary) based on Sku. 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. ” Causes and Workarounds for a Blending Limitation Errors 1. Secondary data source: (excel) master zip file with ~40k rows (all US zips) - each zip is tied to a territory I am looking to add the territories from the master zip to territory file as a filter. If this aggregation is ATTR() then the grand totals may be blank. Left. Identify your data sources for common data types: both data sources must have a string or date field for linking data sources. Think of this layer as the Relationships canvas in the Data Source page. "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. ×Sorry to interrupt. Instead, the. I noticed that when the spatial file is the secondary data source, I cannot area plot it by double clicking the geometry variable. 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. 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. Upvote Upvoted Remove Upvote Reply. They cannot be used as secondary data sources. 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. Modify the calculation to not use table functions;. 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. The unsupported aggregation happens when your aggregate requires row-level visibility to the secondary data source. 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). 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". you will get 5/22 date. See Join your Data for instructions. Option 1: Join the data sources with a cross-database join instead of blending. This type of bases does not allow for blend relationship, therefore, you cannot use a filter like this. Because data blending is an ad-hoc LEFT join that aggregates data from the secondary data source, Tableau cannot always perform aggregations that require the full domain. "Cannot blend the secondary data source because one or more fields use the / function, which cannot be computed locally. drag the secondary measures to measure values section . 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". I've attached my workbook that contains 2 data sources that are blended by invoice number. Filter each of the data sources independently on the more granular dimensions. Hello Tableau world!! Am running into the strangest problem when data blending with V8. 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. Aggregate the date fields at the MY. However, if you do a full outer join on [Dimension] = [Dimension] then we can know which records match up, and do a calculation like:I like to have the ability to swap a primary data source with a secondary data source for data blending in a workbook. The primary data source will be identified automatically from any metrics you put on the worksheet first. The relationship is on the facility ID. an aggregated left join where the aggregation of the secondary data cannot be used to increase the level of detail of the primary data. the branch field I'm using from the primary 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. Make the data source that contains the field that you want to use in the URL action the primary data source in. IF ATTR([Offer Status]) = "Hired" Then AVG([Comp_File]. Hello Jim, Thank You for your reply. But I cant add filter Month from the Budget Excel file. General Information. 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. Tableau will throw an error: “Cannot blend the secondary data source because one or more fields use an unsupported aggregation. Also I see that if you put [Corrected Date] from the primary source instead of the secondary source, it behaves with the group (and the calc. Twbx and also the . "Budget" is only contained in an Excel file data source. Change the default sort order of the field using the various options, and then click OK. Common warnings and errors when blending data sources No relationship to the primary 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 syntax for calling secondary data source field is not. We use three kinds of cookies on our websites: required, functional, and advertising. 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. Each has a joining field with the same name. since i want only offername from secondary source to the view and the measures are produced from primary datasource is pos_trn. THEN add this total to the SUM of the projected_users from today's date through month X. cannot blend aggregated data from secondary data source. We cannot use ATTR if trying to create an LOD type calculation if blending data sources. Data blending: Cube data sources can only be used as the primary data source for blending data in Tableau. COUNTD is tough to work on while you. This link might help you: Cannot blend the secondary data source because one or more fields use an unsupported aggregation. Please find the complete blog here ----> COUNTD with secondary DS Tableau(Blending) Workbook is attached. The Products set contain the individual products within an Opportunity whereas the Opportunities set contain Sales metrics (i. Complex as the problem may be, the solution is comfortingly simple. Expand Post. I have been working on Blending feature for a while in different situations and. However, I still get that message saying cannot blend the secondary data source because one or more fields use an unsupported aggregation". Whichever data source you "use first" in a view (by dragging in a field) becomes Primary. * Supplemental data from a secondary data source is needed. For details, see Troubleshoot Data Blending. When Bugs History is a live connection to Vertica living inside my workbook all is well. Cube data sources do not support pass-through connections. gov which displays certain regions in the US (a geometry field is auto created in tableau which allows me to create this map easily), the second data source is a data pull from a data warehouse holding lat/long coordinates of specific points (able to create a point via calculated tableau field using the make point function). . This means that when a cube data source is published, you cannot make a connection from Tableau Server using the data source. 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 . For example, select Analysis > Create Calculated Field, and in the Formula text box, type the. Does anyone have any Ideas how I can apply a universal filter. Hi . Both Primary and Secondary data sources have duplicate rows due to multiple joins in data prep. We can see these by activating secondary data source and looking at the dimensions window, the linking dimensions will have an orange chain icon. " Is there a way to circumvent this issue? Or perhaps a different method entirely. Make the field(s) used to address the table calculation active linking fields. 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. Here is situation I am facing, I have blended two data sources and created a worksheet. I have two data sets that are linked across Date and Product Category fields. Resolution. The secondary data source consists of 1 Fact table (Agg_ActualVsExpected) and 4 Dim tables, one of the Dim tables is Dim_Service, whose primary key is Service_Id, which appears also in the Fact table. Ambiente. However, when I follow your advice, each group splits into 6 rows (one for each month - January through June). I have two data sources which I have blended together on two fields: branch and date. 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. Maxdate) There is one more way, make the datasource which is using the fixed calculation to. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. To blend on summary data, you can do the following: Create a. Data blend is like a Left outer join. In versions prior to 2020. 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". Fee - Cost) over time. Hi, I have a scenario where I have to use Data Blending option to get certain metric values from Secondary Data Source. COUNTD is not possible with Secondary datasource at Tableau (BLENDING) , below is one of the workaround that I would like to share (Maybe there are Many * Many ) I got one query at Tableau forum recently & below is based on the same . with blends, we are only able to support aggregates (like SUM, MIN, MAX. 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. g. Data of any sort coming from a secondary source must come as an aggregate of some sort. đź’Ą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. Maxdate) There is one more way, make the datasource which is using the fixed calculation to primary 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 have three different data source . In data blending, there is a primary data source and a secondary data source. While using blending data source some of the function doesn't perform well in calculation like COUNTD(), LOD{}, MEDIAN() etc. I was now trying to use both calculations you did on a different sheet through data blending. When I calculate the average of a measure and use the filter, it works perfectly fine. 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. Loading. 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 . 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 trying to determine the Average Revenue per User by country for which my calculation is total revenue/unique subscribers. I ended up purchasing an Alteryx license for our company (we now have a lot. Another sheet:W2 is created with Data source A - taking Role in Row shelf. It is important to understand which is the primary source, it can impact your view. Are use of grouped fields not allowed in data blending? I have two data sources: Opportunities and Products. Data blending works like a ___ join. xls files). In the actual data I get the error: Cannot blend the secondary data source because one or more fields use an unsupported aggregation. Which version of Desktop are you using? See attached the superstore workbook (. Mihai Constantinescu (Member) 6 years ago. 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. Loading. 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. I have uploaded this dummy file since I cannot upload my real data here. SandhyaData from the secondary data source (via a data blend) can never be a dimension. You cannot filter data across secondary data sources. Blending Data Issue: "Data sources that contain logical tables cannot be used as secondary data sources for data blending" Hi All, new to Tableau (learning through Udemy) and have run into an issue trying to blend. 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. thanks. Here is the sample. 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. All the data is in the secondary/blended data source.