”. Data blending provides a way to combine data from more than one data source on a single worksheet. 3) COUNTD with Secondary DS (Blending) Thanks,. 4. I have two data sources which I have blended together on two fields: branch and date. 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". 2, users would define joins and unions between physical tables in which Tableau would create a singular, flat table for analysis. Loading. Hi everyone, my first attempt to blend 2 data sets was not successful (Sheet called 1st attempt - attached), because its appears the following message "Cannot blend the secondary data source because one or more fields use an unsupported aggregation". 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. Option 2: Join tables that are in the same data source, instead of blending them. We cannot publish a blended data source as a single data source on the server. 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. Thank you . Make the field(s) used to address the table calculation active linking fields. Does anyone have any Ideas how I can apply a universal filter. 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. Upvote Upvoted Remove Upvote Reply. while data blending is a great feature for exploratory analytics and data validation and incredibly useful to have as an extra tool when nothing else will meet the requirements I find that there's a tradeoff with added. If you create a quick filter on a field from data source 1 and apply this quick filter to. It is important to understand which is the primary source, it can impact your view. I get error: “Cannot blend the secondary data source because one or more fields use an unsupported aggregation. Blending with CountD and LODs. FIXED requires that you have row-level 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 portion. ×Sorry to interrupt. Upvote Upvoted Remove Upvote Reply. "Cannot blend the secondary data source because one or more fields use the == function, which cannot be computed locally. I can add to filters from the data extracts. With the release of Tableau 8. When blending in Tableau, there is always a primary source and a secondary data source. Data source filters. xls files). e. data source. You cannot filter data across secondary data sources. From my primary data source I have a measure in rows, say 'Measure, which is 'distinct count of Pol Number' or 'sum of Premium' depending on a boolean parameter's values (TRUE or FALSE) The unsupported aggregation happens when your aggregate requires row-level visibility to the secondary data source. ) A LOD calc is also trying to do stuff at the row level. 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. I noticed that when the spatial file is the secondary data source, I cannot area plot it by double clicking the geometry variable. This is interesting. Option 2: Create a calculation using WINDOW_SUM() Drag the linking field(s) from the secondary data source to. Unknown file type Total from Secondary Data Source. Excel . I have 2 data sources, A and B, they are linked by data blending with A. ). The date values you want to blend on must exist in both data sources. 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. We would like to show you a description here but the site won’t allow us. The date values you want to blend on must exist in both data sources. I am trying to determine the Average Revenue per User by country for which my calculation is total revenue/unique subscribers. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. In this case the cross database join will effectively act like the. To solve your issue you should ->go to Connections 2 , keep only facADP and remove all other relationships ->go to its physical layer (double click facADP)Two Data Sources A and B, one work sheet:W1 has used both this A and B to represent View. I have two data sets that are linked across Date and Product Category fields. As it is right now (version 8) if you add filters from a secondary data source, you can not cascade the filters based on what the user selects from one filter to the other - this is only. Owing to this, only those fields in the secondary data source which bear corresponding matches with the primary data source appear in the visualization pane. Then you can simply show one filter control on your dashboard and set it to apply to all related data sources. Drag the 2016 Population measure to the Columns. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. Data blending has some limitations regarding non-additive aggregates such as COUNTD, MEDIAN, and. You cannot filter data across secondary data sources. the branch field I'm using from the primary data source. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. Upvote Upvoted Remove Upvote Reply. Thanks for your help everyone! I've found what was happening: I had some filters on the secondary data source. Please attach. I am trying to . In a blend, the secondary data source can only contribute aggregated values using the level of detail defined by the linking fields that appear in the view, so when you remove them, the. " inner cross database join on BU Code with a data source filter set up on UPPER([ID])=UPPER(USERNAME()) on the DS2 source. 1) Vizible Difference: Getting around Count Distinct in a secondary data source. We use three kinds of cookies on our websites: required, functional, and advertising. Data blending; Table Calculations; Resolution Use one of the following workarounds: If possible, join instead of blend your data. I am trying to create a waffle chart. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. COUNTD is tough to work on while you. 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". Fields cannot be used from the [name of secondary data source] data source, because there is no blend relationship to the primary data source. [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. 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. then i added a secondary data source from google sheet , which has the fuel amount. Instead, the. Each has a joining field with the same name. 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. “Cannot blend the secondary data source because one or more fields use an unsupported aggregation. So, in the dummy data, there are two tables from two data sources. "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. We don't get row-level data from secondary sources on a blend. The value gets reduced based on filters@@@ from all 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. cannot blend secondary data source because one or more fields use an unsupported aggregation beacuse of LOD. I am blending (2) data sources based on the date. Relationships cannot be formed between tables from data sources published to Tableau Server or Tableau Online. Think of this layer as the Relationships canvas in the Data Source page. 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. 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 . In the secondary data source, select Data > Create Calculated Field. Fee - Cost) over time. 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 get error: “Cannot blend the secondary data source because one or more fields use an unsupported aggregation. Common Issue #1: Cannot blend the secondary data source because one or more fields use an unsupported aggregation The aggregation methods of COUNTD,. ×Sorry to interrupt. month([date])=month(Parameter. LOD expressions are used when running complex queries with multiple dimensions at the data source level. They cannot be used as secondary data sources. I have three different data source . You can use data blending when you have data in separate data sources that you want to analyze together on a single sheet. I am already using a Custom SQL query as an additional data source and trying to do blending based on the relationship on BU code field from RPT and AD. Some of the function doesn't work properly when we use blending like COUNTD(), LOD{} expression. 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. ×Sorry to interrupt. Cannot blend the secondary data source because one or more fields use an unsupported aggregation It’s cable reimagined No DVR space limits. I like to have the ability to swap a primary data source with a secondary data source for data blending in a workbook. Make the data source that contains the field that you want to use in the URL action the primary data source in. To fix this, we had to add the fields being used in the blending relationship onto the view: If attempting to use COUNTD in a secondary data source when blending, see the following additional workarounds: If Tableau Prep cannot be used, see: Getting around Count Distinct in a secondary data source (third party website) Creating a primary group: Bring a Field into the Primary Data Source in Tableau Help Sorted by: 2. Twbx and also the . 3) Select the now grey link next to the original field in. I am trying using { FIXED : SUM[(portfolioValue)]}. During Data Blending in Tableau, if the secondary data source has any LOD (Level of Detail) Expressions, they are taken down after the data blending process is finished. Common field is the employee ID. In the attached file, table shows the sum of sales and first order date correctly from both the. {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. ×Sorry to interrupt. I've attached my workbook that contains 2 data sources that are blended by invoice number. 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. unsupported aggregation. AUMTable (Secondary) 3. In your case, you're after the Total Cases by Employee, so just imagine Employee in place of Category. order_date = B. Observations : 1. BR, NBBlended data sources cannot be published as a unit. 4, I tried to blend products (secondary) to storefront (primary) based on Sku. It would be nice if when you blend two data sources, you could have the option to show "Only Relevant Values" on filters used from the secondary data source. Upvote Upvoted Remove Upvote Reply. 3 and I have created aggregates AGG for fields from data extract and excel file. 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. 4. Here is the sample. Blending requires primary and secondary data sources. Instead, publish each data. month([date])=month(Parameter. For more information,. 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 . I am blending dates in the secondary data source to dates from the primary source and looking to get a distinct count of the customer code from the secondary data source. Data blending is a good option when you have multiple data sources that cannot be combined through relationships. Make sure that you are blending on dimensions present in the view or on. 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. It's a technical limitation. 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. For more information, see Troubleshoot Data Blending; Blended data sources cannot be published as a unit. 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. Tableau automatically adds an aggregation (SUM) around the column from the secondary source. cannot blend aggregated data from secondary data source. The reason of the errors being unsupported calculation in blend. You can create a federated database using linked tables/worksheets. I am trying to blend the same data against the other because I wanted to show Same Period last Year. In this example, Superstore Sales is the primary data source and Coffee Chain is the secondary data source. You can also define the relationship manually by right-clicking on the data source name in the Data pane, and selecting Relationships. In this case the cross. I'm using a cube data source as my primary and am attempting to blend with. Build whatever calculated fields from the secondary that need to be used in in the primary. Which version of Desktop are you using? See attached the superstore workbook (. Fee" I want to plot Gross Profit (i. 2)Count Distinct from Secondary workaround. - Dataset 1, records the amount spent on ads as "Cost". If I cant go the above way then is there a possibility to do the duration calculation using table calculations or some other way. 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. please check the attached workbook. Hi. The data source with the KMs is the primary source. 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. But I cant add filter Month from the Budget Excel file. The blend is not activated meaning a field from secondary DS is not used in the view. 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. Data blending is a method for combining data from multiple 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. Instead, publish each data source separately (to the same server) and then blend the published data sources. Does the. Beyond that personally I tend to do the work necessary to avoid using data blending in production data sources & views. drag the secondary measures to measure values section . {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. Data blending is particularly useful when the blend relationship—the linking fields—need to vary on a sheet-by-sheet. (to which I am blending data from other sources Name and Spend) and it worked! Observe the ordering of numbers in the last column between the. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. General Information. Primary and Secondary sources in data blending. I can get all the fields into the view apart from the 'is vat exempt'. In your 2nd and 3rd data sources. Tableau will throw an error: “Cannot blend the secondary data source because one or more fields use an unsupported aggregation. Non-additive aggregates are generally not usable when a secondary dimension appears on any Shelf or there’s a linking dimension that is not in the view. While on a view, right click a data source, click replace data source. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. This is the response I received from Tableau Support:Cause. 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. Nitish Pamarty (Member) 7 years ago. The data in the primary data source is the main data on which Tableau defines graphs and charts. However, some days will have entries for "Cost" but not for "Proj. The success of BI projects depends on an organization's choice of BI solutions and the vendor’s ability to deliver relatively rapid and successful implementations, along with supportive. e. If if this is the case, you could try creating a calculation for DAY([Endtimestamp]) in both the primary and secondary data sources, and adding it to the blend. Another sheet:W2 is created with Data source A - taking Role in Row shelf. Does anyone know if there is a way around this or can you only create a blending whit datasources that were created the same way? I appreciate your help. 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. I have 2 published datasource and i think i cannot perform JOIN, LOD and COUNTD. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. Now we have to use W2 as Filter - to filter out the data. Yes - you can't bring COUNTD in data blending. Instead, publish each data source separately (to the same server) and then blend the published data sources. You cannot filter data across secondary data sources. For secondary data source you get same result by managing relationships in your case just Area and Qtr. The default view that you first see in the Data Source page canvas is the logical layer of the data source. Upvote. 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. You can choose whether functional and advertising cookies apply. since i want only offername from secondary source to the view and the measures are produced from primary datasource is pos_trn. All three options are demonstrated in the attached workbook using the sample data set Superstore. When you blend, you can only have aggregate access to the rows in the secondary source. Cannot blend the secondary data source since one or more search use certain unsupported aggregation. This type of bases does not allow for blend relationship, therefore, you cannot use a filter like this. Secondary Data Source: Contains data relating to the usage of a website (hits). "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. Please check the attached workbook for details. In the past, I've just changed my primary table to the one with the calculation. 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. One on table it was all upper case on the other one it was a mix of upper and lower case. Place Organisation Identifier on the level of detail shelf (from the primary source, or both sources) and the blend should work. 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". Beginning with Tableau Desktop 2020. I'm trying to show a distinct count of claims by branch. The version I am working with 10. And I use Join data source, after divide measures / row duplicate. Secondary Data Source: Extract W. "Cannot blend aggregated data from the secondary data source with the data on this sheet because there are no linking fields use din the view" I'm using 2 separate data sources connected to Oracle and published to the Tableau server. 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. 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. Advantages: Very easy to write and implement. Non-additive aggregates are generally not usable when a secondary dimension appears on any Shelf or there’s a linking dimension that is not in the view. Please see if it helps , here it says that problem is with COUNT & they have provided one alternative way as well . 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. If you want to make sure you don't lose any measures from the secondary source then either. Select Default Properties > Sort. Cube data sources can be used only as a primary data source to blend data in Tableau, and cannot be used as secondary data sources. Resolution. You combine data in the logical layer using relationships (or noodles). ) If only one of the tables requires row level information, consider making that the primary data source in the blend (I. Process for Creating the Dynamic “Parameter”. 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. In addition, you cannot blend Measure Values from a secondary data-source, so that rules out this approach as well. 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. Hello Jim, Thank You for your reply. 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. Here are the 7 major steps for putting this together: Set up your primary (main) and secondary (parameter) data sources. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. . 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 a Remaining Value calculation, but it is not correct. In the data window, the blue tick indicates the Primary data source (Sales in the image below). I tried data blending using the zip codes as a common field but I am facing very slow performance. Filtering data across a worksheet's secondary data source is not currently supported in Tableau Desktop. 1. 1 because it can cause Tableau to unexpectedly quit. We are blending two data sources. In the Add/Edit User Mapping dialog crate, do the following: Select a select by the primary your data. Excel 1 pc. For more information, see Deciding Between Joining Tables and Blending Data. 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. Open. Maxdate) There is one more way, make the datasource which is using the fixed calculation to primary data source. Error: Cannot Blend the secondary data source because one or more fields use an unsupported aggregation. Right-click in the Data window and then. Filtering data across a worksheet's secondary data source is not currently supported in Tableau Desktop. Hi All, I have blended primary and secondary data sources. Think of this layer as the Relationships canvas in the Data Source page. Tableau will throw an error: “Cannot blend the secondary data source because one or more fields use an unsupported aggregation. In the data window, switch to [name1] data source, and click at least one link icon to blend these data sources. In the calculation dialog box, do the following: In the name text box, enter Sales for Store - South. I have uploaded this dummy file since I cannot upload my real data here. In a blend, secondary data sources are aggregated and the StoreID dimension would be aggregated to "*". LoadingWhen you try to add URL actions to dashboards, fields from secondary data sources cannot be added to the URL. The. 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. For more information, see Troubleshoot Data Blending; Blended data sources cannot be published as a unit. 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. I have quick filters from the primary data source and I am trying to represent distinct. Are you talking about Tableau Prep or Tableau Desktop? Any chance you can share a sample of your data? Expand Post. When I calculate the average of a measure and use the filter, it works perfectly fine. Marked as. " I have seen a few posts on it and found an issue logged about it as far back as version 8. The unsupported aggregation happens when your aggregate requires row-level visibility to the secondary data source. 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. 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. Use blends when:. Select Custom in the relationships list, and then get Attach. on Rows, Columns, Pages, or the Marks Card. 💥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. you get all data from main data source and ONLY matching data from secondary data source. Identify your data sources for common data types: both data sources must have a string or date field for linking data sources. I have two data sources which I have blended together on two fields: branch and date. Expand Post. 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. 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. Expand Post. If you create a quick filter on a field from data source 1 and apply this. To alias field values. E make table 2 the primary. The default view that you first see in the Data Source page canvas is the logical layer of the data source. Chicken + Choice of Drink1 pc. Drag the State (group) dimension over the Region dimension on the Rows shelf to replace it. This feature would be really useful to ensure we can. To overcome this, I've added a filter straight into the data source and not in the view. Loading. The limitation with Tableau and secondary data sources stinks. Data blending is a method for combining data from multiple sources. I'm trying to blend two data sources on a single field, say 'Program Description'. Data blending is used when the linking fields need to vary on a sheet-by-sheet basis for different visualizations. Upvote Upvoted Remove Upvote Reply. When on the dashboard, click on the ‘Dashboard’ drop-down and select ‘Actions’. Some of my table calculation are the follow: RED FIELD Tableau Name of First Math Course= IF [Tableau Period of First Math Course]== [Academic Period] AND ( [Subject Desc]=='Mathematics' OR [Subject. cannot blend aggregated data from the secondary data source with data on this sheet. I'm noticing you are using the Date field from the secondary data source you are working with. Non-additive engine are entirety functions that errichten outcomes that cannot be aggregated along a dimension. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. I have been working on Blending feature for a while in different situations and. ×Sorry to interrupt. I have two datasets; one is a shape file that contains regions and locations. Jim. Date dimensions: For cube data sources, date dimensions are typically organized into hierarchies that contain levels such as year,. CSS ErrorHi Mavis Liu. 1. But I cant add filter Month from the Budget Excel file. And I want to add one of the field from secondary dataset to be in the filter. Now, in dashboard D1 : has two worksheets W1 and W2. From my primary data source I have a dimension in columns say 'Customer Segment'. Data. I cannot able to use as one connection since am using the data source filter in my first connection have data source filter. Data source A has Role Column and Data source B also has Role Column. The problem is when I try to calculate the median of that same measure. The Products set contain the individual products within an Opportunity whereas the Opportunities set contain Sales metrics (i. 3. If you want to filter data across secondary data sources, consider the following alternatives: Join tables that are in the same data source, instead of blending them. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. Then, after data blending, the final graph cannot show the data related to the South and East. [amount] into the view, it gives less than. [OIL DATE]) THEN MIN ( [KMs]) END. In the secondary (user rights sheet), create a "Verify Username" calculation that has the fmula:. Can anybody please help me with a solution. A datetime field in the primary data source, for example, will not blend with a date field in the secondary data source. Data & Connectivity. Please check the attached workbook for details. 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 . This is one of the disadvantages of data blending in Tableau. General Information. 3 and I have created aggregates AGG for fields from data extract and excel file. In the Data pane, select the State data source (secondary). Both Primary and Secondary data sources have duplicate rows due to multiple joins in data prep. If this aggregation is ATTR() then the grand totals may be blank. It takes advantage of the data collected from previous research and uses it to carry out new research. Cannot blend the secondary data source because one or more fields use the == function, which cannot be computed locally. targets. 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. Select Analysis > Create Calculated Field. Create a “Blend Field” with a value of 1 in both your primary and secondary. 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. Some examples include: cookies used to. In the Data window, right-click the relevant field. Since my Workbook is present inside Office premise. I am already using a Custom SQL query as an additional data source and trying to do blending based on the relationship on BU code field from RPT and AD.