I am blending (2) data sources based on the date. I can add to filters from the data extracts. A data blend cannot filter on dimensions that do not exist in the Primary data source. Call it [Start KM]: IF ATTR ( [KM Date])=ATTR ( [OIL]. e. Option 2: Join tables that are in the same data source, instead of blending them. "Filtering Across Multiple Data Sources Using a Parameter; Cause A sheet cannot be filtered by a field from a secondary data source. One approach that succeeds in adding another measure is to add the measure in question to your. Become a Better Analyst in Just 5 Minutes a Week. I am just trying to filter every Data source, by choosing a field that every Data source has. In the data window, switch to [name1] data source, and click at least one link icon to blend these data sources. 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. In your workbook sheet2 does not contain 5/22 date. The two data sources are identical. General Information. “Cannot blend the secondary data source because one or more fields use an unsupported aggregation. Primary and Secondary sources in data blending. Cube data sources do not support pass-through connections. 1, the ability to "Show Empty Rows" (or columns) was removed when you use a secondary data source. 2 came the introduction of a brand-new data model. This will be identified with a blue checkmark. Secondary data source has Order Date represented as separate Year and Month fields. with blends, we are only able to support aggregates (like SUM, MIN, MAX. 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. Status, Stage, etc). I am trying to blend the same data against the other because I wanted to show Same Period last Year. Ritesh Bisht (Member) 6 years ago. Tableau will throw an error: “Cannot blend the secondary data source because one or more fields use an unsupported aggregation. 1. Overall LOD will show correct result in Primary datasource. However, it gives me following error: "Cannot blend the secondary data source because one or more fields use an unsupported aggregation"We have an enterprise data source that is an SSAS Tabular model. I use the Opp ID to relate them. A datetime field may be converted to a date field using a calculation to remove the time portion. 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. I have uploaded this dummy file since I cannot upload my real data here. There are a few possibilities: 1) Flip the blend so the primary is secondary and vice versa. 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. I have two data sources and doing a data blend. Resolution. There's no way to "swap. Tableau has two inbuilt data sources named Sample-superstore and Sample coffee chain. Pick the secondary data source in of Secondary data source pane. Tableau will throw an error: “Cannot blend the secondary data source because one or more fields use an unsupported aggregation. Community Manager update. We have a calculated filed where an aggregation (COUNTD) is done on a filed of secondary data source. 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. Also, data blending is useful for combining data from published. Then, after data blending, the final graph cannot show the data related to the South and East. Cannot blend the secondary data source because one or more fields use an unsupported aggregation It’s cable reimagined No DVR space limits. ×Sorry to interrupt. Please attach. IF ATTR([Offer Status]) = "Hired" Then AVG([Comp_File]. Using existing secondary data sources can save researchers time and resources by providing access to pre-existing data that has already been collected and organized. This means that when a cube data source is published, you cannot make a connection from Tableau Server using the data source. I am using tableau 2020. [Field_Name]":"Value_to_filter" in the Options will not work. LoadingWhen you try to add URL actions to dashboards, fields from secondary data sources cannot be added to the URL. Viz cannot be filtered with secondary data source filter before loading the visualization so using "[DS_Name]. However, when I follow your advice, each group splits into 6 rows (one for each month - January through June). Data. No. 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. Assuming that's what's going on, there's the question of how to work around this. Effective visualization. I am confused, as I am not even trying to blend Data from both Data Sources. COUNTD is tough to work on while you. The attached workbook and the following steps illustrate the process. Another way to approach this is to do a join of the data outside Tableau via a federated data source. Primary and Secondary Data Sources in Tableau: To perform blending in a Tableau sheet, there should be at least one secondary data source. But I cant add filter Month from the Budget Excel file. Upvote Upvoted Remove Upvote Reply. 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. I am trying to determine the Average Revenue per User by country for which my calculation is total revenue/unique subscribers. Since my Workbook is present inside Office premise. Expand Post. Maxdate) There is one more way, make the datasource which is using the fixed calculation to primary data source. 1) Vizible Difference: Getting around Count Distinct in a secondary data source. Cannot blend the secondary data source because one or more fields use an unsupported aggregation . From my primary data source I have a dimension in columns say 'Customer Segment'. While using blending data source some of the function doesn't perform well in calculation like COUNTD(), LOD{}, MEDIAN() etc. id, A. The blend applies to that worksheet only. " inner cross database join on BU Code with a data source filter set up on UPPER([ID])=UPPER(USERNAME()) on the DS2 source. Now you see a new group field listed in the Population data source (primary) called State (group). This happens regardless if I drag it on the rows or on the Marks space as a 'text'. 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. Call it [Start KM]: IF ATTR ( [KM Date])=ATTR ( [OIL]. Additional Information While replacing ATTR() with MIN() will cause "Automatic" grand totals to show, the grand totals might not be the expected values. I am trying to blend the same data against the other because I wanted to show Same Period last Year. 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. Open. Create a “Blend Field” with a value of 1 in both your primary and secondary. The data source with the KMs is the primary source. It sounds like there might be some complications with a blend? Can’t speak to what’s happening there Are you blending on [Endtimestamp]? By using the formula DAY([Endtimestamp]), you're changing the dimensionality a little bit. Currently, I have to rebuild the worksheet and bring in the secondary source first. 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. The limitation with Tableau and secondary data sources stinks. Expand Post. A datetime field may be converted to a date field using a calculation to remove the time portion. Resolution. Data blending; Table Calculations; Resolution Use one of the following workarounds: If possible, join instead of blend your data. 2) DB2 blending doesn't support non-additive aggregates like COUNTD() from secondary sources. Common Issue #1: Cannot blend the secondary data source because one or more fields use an unsupported aggregation The aggregation methods of COUNTD,. Non-additive aggregates are aggregate functions that produce results that cannot be aggregated along a dimension. When you blend, you can only have aggregate access to the rows in the secondary source. A datetime field may be converted to a date field using a calculation to remove the time. Tableau Desktop Resolution Try one of the following options, as appropriate for your workbook: It may be possible to cross database join instead of blending. ) If only one of the tables requires row level information, consider making that the primary data source in the blend (I. data source. Loading. 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. Make sure that you are blending on dimensions present in the view or on. The data is blended on customer. ×Sorry to interrupt. When blending in Tableau, there is always a primary source and a secondary data source. newBranchProjection (Secondary) When I try to add COUNTD([DistrictId]) from my primary to text table. FIXED ID, WEEK: CountD (accounts)). In the secondary data source, select Data > Create Calculated Field. I'm trying to blend two data sources on a single field, say 'Program Description'. Fee - Cost) over time. Step 1: Create the Parameter. If the user select May 2018. I'm blending the 2 data sources by Service_Id. I'm noticing you are using the Date field from the secondary data source you are working with. blending [cannot blend Measure Values from a secondary data source] -----> this approach failed . I get error: “Cannot blend the secondary data source because one or more fields use an unsupported aggregation. 3 and I have created aggregates AGG for fields from data extract and excel file. Verify if one of the measures coming from the cube data source has a default aggregation different than SUM, MIN, MAX, COUNT. Here are the 7 major steps for putting this together: Set up your primary (main) and secondary (parameter) data sources. Process for Creating the Dynamic “Parameter”. E make table 2 the primary and table. Expand Post. I have three different data source . 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. They must be in the same format. Click oLoading. Blended data sources. drag the secondary measures to measure values section . I'm using a cube data source as my primary and am attempting to blend with. I am getting Cannot blend secondary data source because one or more fields used an unsupported aggregation. 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. The version I am working with 10. In the Add/Edit Field Mapping dialog box, select the date fields from the primary and secondary data sources, and then click OK twice. Hi, Because we can't see the entire picture, no detail in the view of the connected data sources, the workbook, etc. Seemingly simple task is getting complicated in Tableau . Nitish Pamarty (Member) 7 years ago. E make table 2 the primary. Think of this layer as the Relationships canvas in the Data Source page. General Information. 0 and 7. 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. 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. I read that this is not possible. 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. Excel 1 pc. "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. But seems we cannot blend 2 secondary data source with same field. 3. You want to apply a filter to related data sources - which is an option if multiple data sources have a field with the same name and data type, or if you define explicit relationships between data sources from the Data menu. 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). All three options are demonstrated in the attached workbook using the sample data set Superstore. If this aggregation is ATTR() then the grand totals may be blank. Data source filters. To alias field values. Please find the complete blog here ----> COUNTD with secondary DS Tableau(Blending) Workbook is attached. Case 2: If you are done with the dashboard development then create a empty extract and publish it on server and run the refresh so that data gets loaded. Jim. Hello Ritish, You could use Size() and a Las() function as a filter and get the same output. 3. AUMTable (Secondary) 3. Expand Post. ×Sorry to interrupt. 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. I am trying to use the below formula instead of countd function because my data comes from Impala. 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. ”. [OIL DATE]) THEN MIN ( [KMs]) END. 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. ×Sorry to interrupt. In the past, I've just changed my primary table to the one with the calculation. The default view of Data Source canvas is the logical layer in Tableau version 2020. then i added a secondary data source from google sheet , which has the fuel amount. 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. Right-click in the Data window and then. I am getting Cannot blend secondary data source because one or more fields used an unsupported aggregation. Required cookies are necessary for basic website functionality. Here is an example of what I am trying to accomplish:Data blending is a method for combining data from multiple 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. 1. LOD will not work if it is from the secondary datasource. For more information,. When you data changes, you need to redo the. It says, "fields cannot be used from [data name] data source, because there is no relationship to the primary. 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. You can choose whether functional and advertising cookies apply. 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. 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. Resolution. Data blending is particularly useful when the blend relationship—the linking fields—need to vary on a sheet-by-sheet. Tableau Desktop & Web Authoring. It takes advantage of the data collected from previous research and uses it to carry out new research. 3 and I have created aggregates AGG for fields from data extract and excel file. This would be a great time saver, with all of the calculations and linking changing as well. the branch field I'm using from the primary data source. In data source A, I have COUNTD(Person ID) and in data source B, I have COUNTD(Person ID). Build whatever calculated fields from the secondary that need to be used in in the primary. Because in Tableau, you don't use COUNTD function when Blending data source. Functional cookies enhance functions, performance, and services on the website. Filter each of the data sources independently on the more granular dimensions. Relationships cannot be formed between tables from data sources published to Tableau Server or Tableau Online. Data blending works only as a left join. 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. 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. CSS ErrorBy default Tableau Desktop wraps fields from a secondary data source in an aggregation in calculated fields. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. For more information, see Troubleshoot Data Blending; Blended data sources cannot be published as a unit. As 'Group' is from a secondary data source, I cannot simply use the sort buttons. " And after that I can't make my workbook work at all. I am just trying to filter every Data source, by choosing a field that every Data source has. Aside from consulting the primary origin or source, data can also be collected through a third party, a process common with secondary data. Please post you twbx workbook so we can see if there a way . 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. What does this mean? I want to create a city filter and apply it both to the SAS data source as well as the pivoted CSV file. Cannot blend the secondary data source because one or more fields use an unsupported aggregation issue. Use blends when:. 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. Verify if one of the measures coming from the cube data source has a default aggregation different than SUM, MIN, MAX, COUNT. According to Tableau, this error can also appear when using a LOD expression in a blended view. I noticed there was an issue using Data Blend from 3 different source. All the data is in the secondary/blended data source. In the attached file, table shows the sum of sales and first order date correctly from both the. i will try to build some moke up data in excel and reproduce the same but before that could you please explain me in detail what calculation i need to perform in secondary source. Loading. 2)Count Distinct from Secondary workaround. You can choose whether functional and advertising cookies apply. 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. Limitations of Data Blending in Tableau. 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. The. Help would be much. No long-term contract. since i want only offername from secondary source to the view and the measures are produced from primary datasource is pos_trn. Data blending is a method for combining data from multiple sources. We cannot publish a blended data source as a single data source on the server. The aggregation is all on primary source data. Consider joining the two data sources together using Tableau Prep, and then you can use that data as a. General Information. So you need to create a Date field in your Master Data Source, which is why I usedAlternative to CountD function in Blending. Option 2: Create a calculation for a more dynamic sort. I'm blending student data (primary) and staff data (second). Name: Distinct Count. Step 3: Blend the fields with the target data source using simple blending method (clicking those broken links into red)Hi Saukarsha, The linking fields need to be somewhere on the view in order for the blend to work. In the secondary (user rights sheet), create a "Verify Username" calculation that has the fmula:. Data blending have some limitations regarding non-additive total such like COUNTD, MEDIAN, and RAWSQLAGG. Tableau automatically adds an aggregation (SUM) around the column from the secondary source. * Blend in the summary of a large dataset to reduce query time. I'm trying to show a distinct count of claims by branch. Identify your data sources for common data types: both data sources must have a string or date field for linking data sources. 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. Show moreA workbook or mock data would be a sure thing to comment and try upon it. Fields cannot be used from the [name of secondary data source] data source, because there is no blend relationship to the primary data source. 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 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. A key difference with blending is that data is aggregated before being "joined" - you'll notice this when you include a column from the secondary source in a calculation in the primary source. 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). Cannot blend the secondary data source because one or more fields use an unsupported aggregation. 3) Select the now grey link next to the original field in. Blending requires primary and secondary data sources. My goal is to show CY Actuals as bars, with a line for PY Actuals and a line for Budget. Filtering data across a worksheet's secondary data source is not currently supported in Tableau Desktop. (I created calculated fields "Fiscal Year" and "Fiscal Month" on my secondary Superstore example to simulate this. Unknown file type Total from Secondary Data Source. We use three kinds of cookies on our websites: required, functional, and advertising. I have three different data source . They cannot be used as secondary data sources. So, basically, I am having issues with 2 calculations - the FIXED LOD and Remaining Value. ) A LOD calc is also trying to do stuff at the row level. . 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. This is a dynamic way to make data in sets stand out and gain greater real-world context for users. I. you get all data from main data source and ONLY matching data from secondary data source. 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. 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. Fields cannot be used from the [name of secondary data source] data source, because there is no blend relationship to the primary data source. Cube (multidimensional) data sources have certain characteristics that make them unique in Tableau. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. like below . A secondary data source can be used to re-alias the field values in a primary data source. This is a table calculation equivalent of the COUNTD() database function, which may be required either because the result needs to be used in a calculation at a different level of detail to the level at which it is calculated, or because the datasouce. I have quick filters from the primary data source and I am trying to represent distinct. 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 can't do a join because they are two different file formats. Fee" I want to plot Gross Profit (i. Think of this layer as the Relationships canvas in the Data Source page. I'm using a data blending method, where: Primary data source: Contains the ID I'm trying to count. From what I understand, it's because the link variable must be present in the view, or else it does not work. 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. Fee". I have the same issue, but Primary Data Source is a Tableau Server Data Source (I do not have direct access to the database), and Secondary Data Source is an excel flat file. ×Sorry to interrupt. A datetime field in the primary data source, for example, will not blend with a date field in the secondary data source. 1) Duplicate the field in primary datasource. Data blending is particularly useful when the blend relationship—the linking fields—need to vary on a sheet-by-sheet. This feature would be really useful to ensure we can. e. All customer IDs are under a dimension called "Global ID". SandhyaData from the secondary data source (via a data blend) can never be a dimension. Sometimes , it's automatically working but sometimes it says 'Unsupported Aggregation' . Community Manager update. Twbx and also the . As you can see I have 2 different data sources using a blend on the blood type. Click on the ‘Add Action’ button and choose ‘Change Set Values’. I ended up purchasing an Alteryx license for our company (we now have a lot. I am creating a couple of formulas to display the total booking from the second data source to the first data source. Hi Data Modeler , I have an idea which I cannot test right away. [amount] into the view, it gives less than. Thanks bharat ! but i think client column is common to both the source so i would able to blend the data. Step 1: Connect to your data and set up. Filter each of the data sources independently on the more granular dimensions. Regards. 3. The date values you want to blend on must exist in both data sources. Hi . 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. This field works but when I want to add in my Fianl Dashboard I have this message "Cannot blend the secondary data source because one or more fields use an unsupported aggregation" Moreover my first and secondart data sources are linked by the "Sales ID", but this field is not displayed in the final Dashboard. This functionality was available in versions 8. However, when I follow your advice, each group splits into 6 rows (one for each month - January through June). Just aggregates (like SUM, MIN, MAX. To the Data pane, umschaltung in this [name of secondary data source] data source, real click at lowest one link icon to blend that data sources. Thank you. 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. I made a waffle chart grid using an excel data source that contains 3 fields: Rows, Columns and Percentage. Hi . Remove all dimensions from the secondary data source and ensure that the primary data source’s. 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". Current Year Actuals and Prior Year Actuals are housed in a corporate transnational data source. This means a data blend can’t be published as a data source for others to use. Russell Christopher (Member) 10 years ago. 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. From Primary Data Source drag the measure names and measure values . I have two data sets that are linked across Date and Product Category fields. cannot blend aggregated data from secondary data source. Better collaboration. It is important to understand which is the primary source, it can impact. I would like to visualize number of distinct hardware. Hi Kurt! No, not really. 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. I've attached my workbook that contains 2 data sources that are blended by invoice number. This can help researchers identify. Hello Jim, Thank You for your reply. I am trying using { FIXED : SUM[(portfolioValue)]}. We can see these by activating secondary data source and looking at the dimensions window, the linking dimensions will have an orange chain icon. From what I can tell, joining on Tableau Server Data Sources has been a requested feature for 6 years (Idea: Ability to join Tableau Server data sources). Use the geographic role in the primary data source on detail instead of the dimension from the secondary data source. This feature would be really useful to ensure we can. Option 1: Join the data sources with a cross-database join instead of blending. One data source has some values, the other one has different values. ×Sorry to interrupt. Does anyone have any Ideas how I can apply a universal filter. How to calculate Delta value. order_date = B. 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. , 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. ×Sorry to interrupt. Proj. I want to display all values for all different data sources, and use them as filters, and filter the relevant records from both datasources at the same time. 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 only fields used in the view are the date fields, to which I did a . 5 3 . I use the Opp ID to relate them. How ever # no of changes and # of Problems are calculating entire database values. You will need a common column between the two tables in order to blend. 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. In the secondary data source, select Data > Create Calculated Field. Hi All, I have blended primary and secondary data sources.