Selected as Best Selected as Best Upvote Upvoted Remove Upvote 1 upvote. This can help researchers identify. Consider joining the two data sources together using Tableau Prep, and then you can use that data as a. "Cannot blend the secondary data source because one or more fields use the == function, which cannot be computed locally. Step 1: Connect to your data and set up. Instead, publish each data source separately (to the same server) and then blend the published data sources. Because there are no linking fields in this view. 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. General Information. Another way to approach this is to do a join of the data outside Tableau via a federated data source. Seemingly simple task is getting complicated in Tableau . unsupported aggregation. They cannot be used as 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. (I created calculated fields "Fiscal Year" and "Fiscal Month" on my secondary Superstore example to simulate this. 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. Whichever data source you "use first" in a view (by dragging in a field) becomes Primary. 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. Data sources can contain logical tables not be used as secondary data sources for data blending. 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. then i added a secondary data source from google sheet , which has the fuel amount. I noticed there was an issue using Data Blend from 3 different source. 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. Expand Post. Aggregate the date fields at the MY. Data of any sort coming from a secondary source must come as an aggregate of some sort. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. Non-additive aggregates are aggregate functions that produce results that cannot be aggregated along a dimension. Then, after data blending, the final graph cannot show the data related to the South and East. I cannot change the case of the data to upper or lower. If this aggregation is ATTR() then the grand totals may be blank. After blending, CountD works fine on primary datasource, but when I try to use CountD on secondary datasource tableau gives error: "Cannot blend secondary data source as one or more fields use an unsupported aggregation" Because of this, our overall. I am trying to . Currently, data sources that contain logical tables cannot be used as secondary data sources for data blending. Some examples include: session cookies needed to transmit the website, authentication cookies, and security cookies. 1. 1) Duplicate the field in primary datasource. Because the question is related to how the data sources are being related, it would help to see the real data structure. " Is there a way to circumvent this issue? Or perhaps a different method entirely. I have just realised why the blending was not working. Are you talking about Tableau Prep or Tableau Desktop? Any chance you can share a sample of your data? Expand Post. 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. To alias field values. 1. . data source. Now try to recreate the sheet and link the 2nd and 3rd data. Secondary data source: spatial file containing the geometry. 3 and I have created aggregates AGG for fields from data extract and excel file. Non-additive engine are entirety functions that errichten outcomes that cannot be aggregated along a dimension. Ambiente. 2) DB2 blending doesn't support non-additive aggregates like COUNTD() from secondary 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. 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. Russell Christopher (Member) 10 years ago. 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. And I can't explain why it does that. Hello Jim, Thank You for your reply. Loading. 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]). Secondary data source has Order Date represented as separate Year and Month fields. Currently, data sources that contain logical tables cannot be used as secondary data sources for data blending. " Expand Post. you get all data from main data source and ONLY matching data from secondary data source. There's no way to "swap. We use three kinds of cookies on our websites: required, functional, and advertising. These latter two situations trigger a different style of data blending (DB2) inside Tableau to ensure an accurate blend and that makes computation of non-additive aggregates much more. 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. 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. newBranchProjection (Secondary) When I try to add COUNTD([DistrictId]) from my primary to text table. good morning you have blended your data sources - data from the secondary source always comes to the primary and an aggregate so Budg_date needs to be aggregate with min max or attr but that will probably not give you the result you expect the data from the secondary source will come over as an * if there is more than one date filtered from that. 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. 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. We don't get row-level data from secondary sources on a. The date values you want to blend on must exist in both data sources. with blends, we are only able to support aggregates (like SUM, MIN, MAX. 3. In data blending, there is a primary data source and a secondary data source. Think of this layer as the Relationships canvas in the Data Source page. I am creating a couple of formulas to display the total booking from the second data source to the first data source. Create a “Blend Field” with a value of 1 in both your primary and secondary. I'm using a cube data source as my primary and am attempting to blend with. Data blending works only as a left join. In the actual data I get the error: Cannot blend the secondary data source because one or more fields use an unsupported aggregation. I would like to visualize number of distinct hardware. “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. Pick the secondary data source in of Secondary data source pane. Moreover, blending is a kind of left join, not exactly a join. 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. I have two datasets; one is a shape file that contains regions and locations. Primary and Secondary Data Sources in Tableau: To perform blending in a Tableau sheet, there should be at least one secondary data source. Cannot blend the secondary data source because one or more fields use an unsupported aggregation It’s cable reimagined No DVR space limits. I read that this is not possible. 5 3 . 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. Data > Edit Relationships . "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. 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. I want to do a basic data listing showing customer, order no, postcode & vat exempt. ×Sorry to interrupt. I was now trying to use both calculations you did on a different sheet through data blending. Current Year Actuals and Prior Year Actuals are housed in a corporate transnational data source. This means that when a cube data source is published, you cannot make a connection from Tableau Server using the data source. I've blended on user ID. Hi All, I have blended primary and secondary data sources. I'm able to successfully connect to both data sources and set up the relationship, with the Teradata extract being primary and the Excel sheet being secondary. Tableau has two inbuilt data sources named Sample-superstore and Sample coffee chain. Here's the data blend view with the secondary data source selected so we can see what blend fields are used:. Remove all dimensions from the secondary data source and ensure that the primary data source’s. If that does not help,. Filter each of the data sources independently on the more granular dimensions. 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. From my primary data source I have a dimension in columns say 'Customer Segment'. Applies to: Tableau Cloud, Tableau Desktop, Tableau Server Data blending is a method for combining data from multiple sources. For more information, see Use Relationships for Multi-table Data Analysis. Since my Workbook is present inside Office premise. Instead, the. please check the attached workbook. Any help would be appreciated!Also a data blend is only a LEFT join. You can choose whether functional and advertising cookies apply. Both fields are linked in worksheet. Data blending is a method for combining data from multiple sources. Name: Distinct Count. ×Sorry to interrupt. Cannot blend the secondary data source because one or more fields use an unsupported aggregation . Beyond that personally I tend to do the work necessary to avoid using data blending in production data sources & views. Credits to Jonathan Drummey for the below workaround Cannot blend the secondary data source because one or more fields use an unsupported aggregation . when I use A as primary data source and drag A. I tried data blending keeping File C as primary and A & B as secondary data source with DD number as relationship. I'm trying to show a distinct count of claims by branch. 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. The value gets reduced based on filters@@@ from all 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. The unsupported aggregation happens when your aggregate requires row-level visibility to the secondary data source. "Budget" is only contained in an Excel file data source. 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. I have three different data source . Community Manager update. I have quick filters from the primary data source and I am trying to represent distinct. So you don't get in the case of data blending. So you need to create a Date field in your Master Data Source, which is why I usedAlternative to CountD function in Blending. 2, Tableau introduces relationships and splits. Regards. like below . All three options are demonstrated in the attached workbook using the sample data set Superstore. I'm using a data blending method, where: Primary data source: Contains the ID I'm trying to count. mdb which will be used to illustrate data blending. Data source A has Role Column and Data source B also has Role Column. 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. Hi All, Is there a way to use a parameter to work for secondary data source in blending. You can use data blending when you have data in separate data sources that you want to analyze together on a single sheet. [Field_Name]":"Value_to_filter" in the Options will not work. Now when I drag and drop the transaction data, everything works just fine, but if I try to use the "Add all Subtotals" option to get the AVG Transactions value for each Market then I am getting the dreaded "Cannot blend the secondary data source because one or more fields use an unsupported aggregation" on my worksheet when I change the "Total. Secondary Data Source: Extract W. You can create a federated database using linked tables/worksheets. 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. [OIL DATE]) THEN MIN ( [KMs]) END. Answer. Option 1: Join the data sources with a cross-database join instead of blending. However, when I follow your advice, each group splits into 6 rows (one for each month - January through June). 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. Please find the complete blog here ----> COUNTD with secondary DS Tableau(Blending) Workbook is attached. No long-term contract. CSS ErrorBy default Tableau Desktop wraps fields from a secondary data source in an aggregation in calculated fields. In the Data window, right-click the relevant field. Primary and Secondary sources in data blending. The syntax for calling secondary data source field is not. Data blending is a method for combining data from multiple sources. As 'Group' is from a secondary data source, I cannot simply use the sort buttons. ×Sorry to interrupt. Twb, . For more information,. When you blend, you can only have aggregate access to the rows in the secondary source. For details, see Troubleshoot Data Blending. Please check the attached workbook for details. Expand Post. Secondary data is one of the two main types of data, where the second type is the. With the release of Tableau 8. 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. In the Relationships dialog box, under Secondary data source select Custom, and then click Add. This is a dynamic way to make data in sets stand out and gain greater real-world context for users. I have two data sources which I have blended together on two fields: branch and date. 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. This will be identified with a blue checkmark. Remove all dimensions from the secondary data source and ensure that the primary data source’s linking field is in view. Fee" I want to plot Gross Profit (i. Call it [Start KM]: IF ATTR ( [KM Date])=ATTR ( [OIL]. twbx. A datetime field in the primary data source, for example, will not blend with a date field in the secondary data source. 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. Tableau automatically adds an aggregation (SUM) around the column from the secondary source. Option 2: Join tables that are in the same data source, instead of blending them. Loading. Right-click in the Data window and then. 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. Therefore it cannot display null data. These latter two situations trigger a different style of data blending (DB2) inside Tableau to ensure an accurate blend and that makes computation of non-additive aggregates much more difficult. "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. I'm blending student data (primary) and staff data (second). [tier] == 2 'Top Vendors' else 'Mid Vendors'. month([date])=month(Parameter. The unsupported aggregation happens when your aggregate requires row-level visibility to the secondary data source. 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. FIXED requires that you have row-level access to the rows in the secondary source. 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. 3) COUNTD with Secondary DS (Blending) Thanks,. Excel 1 pc. Fee". order_date = B. The version I am working with 10. This type of bases does not allow for blend relationship, therefore, you cannot use a filter like this. month([date])=month(Parameter. That's probably your problem. 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. Hi Data Modeler , I have an idea which I cannot test right away. Data blending works like a ___ join. amount into the view, it gives me the correct sum. Fields from the secondary data source used in the view have an orange check mark. LOD (exclude) - Filtering using a different data source I've used LOD (exclude) to create a % of total calc field (and then created a moving average off that). LOD will not work if it is from the secondary datasource. 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. 0, but I imagine someone has been able to identify what is causing the issue. 3 and I have created aggregates AGG for fields from data extract and excel file. It's a technical limitation. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. - Go to Data > Edit Relationships to create the define primary and secondary data sources and the links - Drag and drop the linked field from the primary data source to use this field on the visualisation. You cannot filter data across secondary data sources. {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. I get error: “Cannot blend the secondary data source because one or more fields use an unsupported aggregation. Chicken - VMBurger + Choice of DrinkBurger - VMSpaghetti + Choice of DrinkSpaghetti - VM Trying to do a COUNTD() from a secondary data source and got this dreaded error: > Cannot blend the secondary data source because one or more fields use an unsupported aggregation . But 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. ×Sorry to interrupt. 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. When blending in Tableau, there is always a primary source and a secondary data source. Next, drag Category from the Orders data source onto the view, then select the Orders data source and click the chain icon to blend on Order ID. Data blending is particularly useful when the blend relationship—the linking fields—need to vary on a sheet-by-sheet. See Join Your Data for more information. ” We use three kinds of cookies on our websites: required,. 1. This functionality was available in versions 8. e. Filtering data across a worksheet's secondary data source is not currently supported in Tableau Desktop. 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. Another way to approach this is to do a join of the data outside Tableau via a federated data source. This is the final step and will result in filtering between the blended data sources at your desired level of granularity. We cannot publish a blended data source as a single data source on the server. 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. 3) Select the now grey link next to the original field in. You can create a federated database using linked tables/worksheets. CSS ErrorAfter Blending, Now it is showing this error: Cannot blend the secondary data source because one or more fields use an unsupported aggregation. Fixed, countd functions won't work with the secondary datasources. 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. Become a Better Analyst in Just 5 Minutes a Week. Because in Tableau, you don't use COUNTD function when Blending data source. However when I use B as primary data source, drag [A]. Filter each of the data sources independently on the more granular dimensions. When you blend, you can only have aggregate access to the rows in the secondary. For secondary data source you get same result by managing relationships in your case just Area and Qtr. However, when I follow your advice, each group splits into 6 rows (one for each month - January through June). What steps do I need to do to do this?It shows the next message: "Cannot blend the secondary data source because one or more fields use an unsupported aggregation". Dominic Laird(Member) 5 years ago. targets. Hello Ritish, You could use Size() and a Las() function as a filter and get the same output. This means a data blend can’t be published as a data source for others to use. I tried to recreate the data as close as possible. "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. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. 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. Some of the function doesn't work properly when we use blending like COUNTD(), LOD{} expression. 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. For example, sheet A uses data source 1 as the primary data source; sheet B uses data source 1 as the secondary data source. Resolution. Resolution. You can read details here: Logical Tables in Secondary data source. 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. The problem is when I try to calculate the median of that same measure. 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. We don't get row-level data from secondary sources on a blend. You are trying to bring fields from a second data source into a calculation that is being created in the primary (first) data source and aggregations are not consistent - data from the second source comes over as an aggregate - look into what the aggregation is on and how does that relate to what you have in the primary data baseI'm trying to blend two data sources on a single field, say 'Program Description'. In second data source i don;t have salesrep column. 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. Another table is a a table that contains key fields such as date, region, location and hardware id (dimension). "Data Sources that contain logical tables cannot be used as secondary data sources for blending". The default view that you first see in the Data Source page canvas is the logical layer of the data source. It does exactly what I need and I'm able to filter no problem at all using a different data source when working to a financial period level. 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. on Rows, Columns, Pages, or the Marks Card. Upvote. Hi Kurt! No, not really. In the past, I've just changed my primary table to the one with the calculation. Which version of Desktop are you using? See attached the superstore workbook (. Resolution. Expand Post. Advantages: Very easy to write and implement. I am using tableau 2020. - Dataset 1, records the amount spent on ads as "Cost". " inner cross database join on BU Code with a data source filter set up on UPPER([ID])=UPPER(USERNAME()) on the DS2 source. Yes - you can't bring COUNTD in data blending. Blending takes place in the 6th step of the order of operation after the data table for the individual worksheet is set and the filters applied - data from the secondary source are aggregated at the level of the link and brought to the primary as. When on the dashboard, click on the ‘Dashboard’ drop-down and select ‘Actions’. I am trying to create a waffle chart. Hi, I have a scenario where I have to use Data Blending option to get certain metric values from Secondary Data Source. CustomOverall (Primary) 2. This feature would be really useful to ensure we can. Chicken + Choice of DrinkBurger + Choice of DrinkSpaghetti + Choice of Drink . AUMTable (Secondary) 3. And I want to add one of the field from secondary dataset to be in the filter. 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. newBranchProjection (Secondary) When I try to add COUNTD([DistrictId]) from my primary to text table. 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. I'm trying to show a distinct count of claims by branch. 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). " inner cross database join on BU Code with a data source filter set up on UPPER([ID])=UPPER(USERNAME()) on the DS2 source. Change the default sort order of the field using the various options, and then click OK. 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. I am trying to blend the same data against the other because I wanted to show Same Period last Year. I receive this error: "Cannot blend the data source because one or more fields uses an unsupported aggregation". When you data changes, you need to redo the. I noticed that when the spatial file is the secondary data source, I cannot area plot it by double clicking the geometry variable. However, some days will have entries for "Cost" but not for "Proj. 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. 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. Step 2: Make it a context filter. 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. Data blending provides a way to combine data from more than one data source on a single worksheet. Show moreA workbook or mock data would be a sure thing to comment and try upon it. Hi . Effective visualization. If you are blending a cube data source, it must be the primary data source. 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. Please attach. It takes advantage of the data collected from previous research and uses it to carry out new research. I'm blending the 2 data sources by Service_Id. ) A LOD calc is also trying to do stuff at the row level. See Join your Data for instructions. 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. ×Sorry to interrupt. 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 . 0 and 7. Alternate names:. You will need a common column between the two tables in order to blend. Chicken + Choice of DrinkBurger + Choice of DrinkSpaghetti + Choice of Drink . Cannot blend the secondary data source because one or more fields use an unsupported aggregation. 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. Functional cookies enhance functions, performance, and services on the website. Use a parameter with a calculated field to filter the secondary data source at the row level. If you create a quick filter on a field from data source 1 and apply this. 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 cannot filter data across secondary data sources. Blending your Data in Tableau. Hey all, I'm trying to create a filter in my dashboard such as my two spreadsheets are linked with this filter. [Work Hours]) So you have to make. Few things you need to keep in mind while blending data sources in tableau. Drag the 2016 Population measure to the Columns.