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. Secondary Data Source: Extract W. Upvote. (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. Instead, we need to publish the two data sources separately on the same server and then. CSS ErrorLoading. However, when I follow your advice, each group splits into 6 rows (one for each month - January through June). This is a dynamic way to make data in sets stand out and gain greater real-world context for users. 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. 3) COUNTD with Secondary DS (Blending) Thanks,. When you data changes, you need to redo the. 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 HelpWhen I am using apply filter to related data sources, other data sources add this field as a secondary data source and the worksheets which uses that as a primary data source gives me errors. I use the Opp ID to relate them. Fee - Cost) over time. 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. 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. Currently, data sources that contain logical tables cannot be used as secondary data sources for data blending. I have two data sets: the first data set is a shp file from data. When blending in Tableau, there is always a primary source and a secondary data source. This type of bases does not allow for blend relationship, therefore, you cannot use a filter like this. Hello Jim, Thank You for your reply. You cannot filter data across secondary data sources. ×Sorry to interrupt. I cannot able to use as one connection since am using the data source filter in my first connection have data source filter. 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. Hello Everyone, I am using one data source which is a LIVE connection and I have duplicated same data source , the reason behind duplication is i want to have total of category which will be constant and it will not. Secondary data is one of the two main types of data, where the second type is the. Since my Workbook is present inside Office premise. 5 3 . Data blending is a good option when you have multiple data sources that cannot be combined through relationships. I'm trying to create a frequency distribution as a percent of total for individual products in a single category on one chart, then dual axis a second chart with the frequency distribution of the category for comparison purposes. Currently, data sources that contain logical tables cannot be used as secondary data sources for data blending. In the secondary data I have a LOD field called Total_Category_Response defined as { FIXED [Category]: SUM([Respose_ValI am working on a dashboard where I am using the data blending feature to visualize the data from different data sources in to a single view. 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. [tier] == 0 then "Low vendors" elseif max [Secondary]. Hey all, I'm trying to create a filter in my dashboard such as my two spreadsheets are linked with this filter. And I want to add one of the field from secondary dataset to be in the filter. When I try to graph the distinct count of project ids vs the VendorClass, however, I see every project getting the. From my primary data source I have a dimension in columns say 'Customer Segment'. 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". 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. 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. Tableau Desktop; Blended data; Soluzione Use the following workaround: Create a new worksheet. i. You can read details here: Logical Tables in Secondary data source. 4, I tried to blend products (secondary) to storefront (primary) based on Sku. In Tableau Desktop, navigate to Data > Edit Relationships. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. 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. LOD expressions are used when running complex queries with multiple dimensions at the data source level. [Work Hours]) So you have to make. This can restrict many values from the secondary data source. The problem I'm running into is when I use another data source as the primary source and attempt to bring over the LOD calculation from a secondary source. Make the data source that contains the field that you want to use in the URL action the primary data source in. I have 2 data sources, A and B, they are linked by data blending with A. I tried data blending keeping File C as primary and A & B as secondary data source with DD number as relationship. Now we have to use W2 as Filter - to filter out the data. 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. 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. Step 2: Make it a context filter. ). The syntax for calling secondary data source field is not. See Join Your Data for more information. Then, after data blending, the final graph cannot show the data related to the South and East. Common warnings and errors when blending data sources No relationship to the primary data source. Data blending is a method for combining data from multiple sources. CSS ErrorI am trying to put my LOD calculation (below) on the rows shelf but encountering "cannot blend the secondary data source because one or more fields use an unsupported aggregation" {include [DATE. CustomOverall (Primary) 2. Give the action a sensible name and configure the action. I'm blending the 2 data sources by Service_Id. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. Use blends when:. Any help would be appreciated!Also a data blend is only a LEFT join. You can choose whether functional and advertising cookies apply. So make sure you're not using such function while blending. AUMTable (Secondary) 3. All customer IDs are under a dimension called "Global ID". All data from a secondary source comes back as an aggregate -- even if there is only one value from the secondary source. The. Common field is the employee ID. 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. Good morning . Here are the 7 major steps for putting this together: Set up your primary (main) and secondary (parameter) data sources. In order to create the waffle chart I am blending it with another datasource using the calculated field defined as [Week 5 (Week5Bond)]. 1) Duplicate the field in primary datasource. 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". A secondary data source can be used to re-alias the field values in a 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. COUNTD - Blended data. Data blending has some limitations regarding non-additive aggregates such as COUNTD, MEDIAN, and. with blends, we are only able to support aggregates (like SUM, MIN, MAX. Are use of grouped fields not allowed in data blending? I have two data sources: Opportunities and Products. " Expand Post. 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. 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. 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. {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. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. Data sources can contain logical tables not be used as secondary data sources for data blending. id, A. I ended up purchasing an Alteryx license for our company (we now have a lot. Tableau will throw an error: “Cannot blend the secondary data source because one or more fields use an unsupported aggregation. ”. cannot blend secondary data source because one or more fields use an unsupported aggregation beacuse of LOD. Please refer the below link and let me know if this helps to you. 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. ×Sorry to interrupt. Viz cannot be filtered with secondary data source filter before loading the visualization so using "[DS_Name]. 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. According to Tableau, this error can also appear when using a LOD expression in a blended view. 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. The two data sources are identical. Advantages: Very easy to write and implement. 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. 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". For more information,. Sometimes , it's automatically working but sometimes it says 'Unsupported Aggregation' . For more information, see Use Relationships for Multi-table Data Analysis. When you drag a field from a secondary data source to the view, you might see a warning that says: Fields cannot be used from the [name of secondary data source] data source, because there is no blend relationship to the primary data source. For example, COUNTD(). . All Answers. Loading. Thanks for your help everyone! I've found what was happening: I had some filters on the secondary data source. 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. Cannot blend the secondary data source because one or more fields use an unsupported aggregation" when Data Blending. Make sure that you are blending on dimensions present in the view or on. Hi, I'll expand a bit on what @Chris wrote: There are some fundamental limits to what can be done with data blending and while there are workarounds that can get us the desired results in some circumstances those workarounds will not work in all circumstances (because Tableau never built out data blending to handle every. Loading. In this example, Superstore Sales is the primary data source and Coffee Chain is the secondary data source. Now you see a new group field listed in the Population data source (primary) called State (group). Resolution. ×Sorry to interrupt. Expand Post. If that does not help,. Also, in the attached I have added both Calc1 and Calc2 to the tooltip in Sheet 9. Expand Post Using TableauThe secondary data source is indicated with an orange check mark on the data source and an orange bar down the side of the Data pane. Option 2: Create a calculation for a more dynamic sort. 3 and I have created aggregates AGG for fields from data extract and excel file. Each has a joining field with the same name. Tableau will throw an error: “Cannot blend the secondary data source because one or more fields use an unsupported aggregation. CSS ErrorHi Mavis Liu. ×Sorry to interrupt. 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 data sources and doing a data blend. Data blending: Cube data sources can only be used as the primary data source for blending data in Tableau. A COUNTD of Order ID should be all I need to show this data but it always results in a "Cannot blend the secondary data source because one or more of the fields use an unsupported aggregation". When you blend, you can only have aggregate access to the rows in the secondary. Now, in dashboard D1 : has two worksheets W1 and W2. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. an aggregated left join where the aggregation of the secondary data cannot be used to increase the level of detail of the primary data. The problem is when I try to calculate the median of that same measure. Beginning with Tableau Desktop 2020. The reason of the errors being unsupported calculation in blend. Resolution. Assuming that's what's going on, there's the question of how to work around this. I have my primary data source with dimensions customer and order no and a secondary data source with customer, postcode and an 'is vat exempt' boolean field. Try one of the following options, as appropriate for your workbook: It may be possible to cross database join instead of blending. Blending requires primary and secondary data sources. They cannot be used as secondary data sources. I think I need to define the relationship between the data sources. It also means you cannot create a workbook using the. Pick the secondary data source in of Secondary data source pane. For more information, see Deciding Between Joining Tables and Blending Data. 💥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. This happens only when the data sources are impala. 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. Aside from consulting the primary origin or source, data can also be collected through a third party, a process common with secondary data. In your 2nd and 3rd data sources. Upvote Upvoted Remove Upvote Reply. There is a possibility that the values can be restricted from the secondary data. Create a “Blend Field” with a value of 1 in both your primary and secondary. Data & Connectivity. This can help researchers identify. e. I made a waffle chart grid using an excel data source that contains 3 fields: Rows, Columns and Percentage. I tried to recreate the data as close as possible. Good morning @Fred Yu (Customer) . Someone in the Community told me the following: "MAX isn't supported in. In second data source i don;t have salesrep column. If you create a quick filter on a field from data source 1 and apply this. Help would be much. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. In this source create a calculated field to pull out the KMs on the date of oil change. I have two data sets that are linked across Date and Product Category fields. Please post you twbx workbook so we can see if there a way . The primary data source is just to filter for the invoices I want to look at. In the Data pane, select the State data source (secondary). (I created calculated fields "Fiscal Year" and "Fiscal Month" on my secondary Superstore example to simulate this. 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. Because in Tableau, you don't use COUNTD function when Blending data source. Select Default Properties > Sort. 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. It sounds like there might be some complications with a blend? Can’t speak to what’s happening thereAre you blending on [Endtimestamp]? By using the formula DAY([Endtimestamp]), you're changing the dimensionality a little bit. 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. Observations : 1. You combine data in the logical layer using relationships (or noodles). You can choose whether functional and advertising cookies apply. Credits to Jonathan Drummey for the below workaround Cannot blend the secondary data source because one or more fields use an unsupported aggregation . I am trying to blend the same data against the other because I wanted to show Same Period last Year. Complex as the problem may be, the solution is comfortingly simple. 3. Excel . I am just trying to filter every Data source, by choosing a field that every Data source has. Data of any sort coming from a secondary source must come as an aggregate of some sort. Another table is a a table that contains key fields such as date, region, location and hardware id (dimension). Cannot blend the secondary data source because one or more fields use an unsupported aggregation It’s cable reimagined No DVR space limits. Call it [Start KM]: IF ATTR ( [KM Date])=ATTR ( [OIL]. Then you can simply show one filter control on your dashboard and set it to apply to all related data sources. Data blending provides a way to combine data from more than one data source on a single worksheet. Yes - you can't bring COUNTD in data blending. Option 2: Join tables that are in the same data source, instead of blending them. In addition, you cannot blend Measure Values from a secondary data-source, so that rules out this approach as well. But the source calc is a countD. Current Year Actuals and Prior Year Actuals are housed in a corporate transnational data source. ”. Hello Jim, Thank You for your reply. - Data to Map from - Data to Map to . I have quick filters from the primary data source and I am trying to represent distinct. If you make sheet 1 as the primary data source and do the data blending with sheet 2. 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 need to get a count distinct of Patient ID from the Primary data source, as well as count distinct of Patient ID from the Secondary data source in one worksheet. Data source filters. Use the geographic role in the primary data source on detail instead of the dimension from the secondary data source. I can add to filters from the data extracts. The solution. We use three kinds of cookies on our websites: required, functional, and advertising. Community Manager update. I have a calculated field in the Excel data source that returns a binary 1 if the username matches the list in Excel for the facility ID and a 0. The unsupported aggregation happens when your aggregate requires row-level visibility to the secondary data source. Thank you. We use three kinds of cookies on our websites: required, functional, and advertising. Show moreA workbook or mock data would be a sure thing to comment and try upon it. Tableau v8 added a new style of data blending (DB2) where the linking field does not have to be in the view. like below . Data blending is a method for combining data from multiple sources. Also, data blending is useful for combining data from published. 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). You must double-click a logical table in the Data Source page canvas to go to the physical layer of the canvas. 1 because it can cause Tableau to unexpectedly quit. Hi, Because we can't see the entire picture, no detail in the view of the connected data sources, the workbook, etc. I get error: “Cannot blend the secondary data source because one or more fields use an unsupported aggregation. In your workbook sheet2 does not contain 5/22 date. You combine data in the logical layer using relationships (or noodles). Answer. you get all data from main data source and ONLY matching data from secondary data source. ) So the issue is really the introduction of the group on the sheet. I get error: “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. I. The relationship is on the facility ID. Cannot blend the secondary data source because one or more fields use the == function, which cannot be computed locally. For example, sheet A uses data source 1 as the primary data source; sheet B uses data source 1 as the secondary data source. Russell Christopher (Member) 10 years ago. 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. 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. 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. Verify if one of the measures coming from the cube data source has a default aggregation different than SUM, MIN, MAX, COUNT. I noticed that when the spatial file is the secondary data source, I cannot area plot it by double clicking the geometry variable. In the formula text box, type the ZN function, the SUM. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. Please check the attached workbook for details. - 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. Nitish Pamarty (Member) 7 years ago. LOD will not work if it is from the secondary datasource. Before I check Date filters, I got this results. 2 came the introduction of a brand-new data model. 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. 2) Use this duplicate field in the view instead of the original. 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. T or F: Blends, unlike relationships or joins, never truly combine the data. 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. While it’s possible to aggregate the 1-to-many data source in the custom SQL, this can be time consuming and will require more edits when data sources change. ×Sorry to interrupt. * Blend in the summary of a large dataset to reduce query time. Data from a secondary source is displayed along with the primary source data. 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. 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. 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. I am getting Cannot blend secondary data source because one or more fields used an unsupported aggregation. Please attach. To blend on summary data, you can do the following: Create a. The data are sorted, but each row only shows one month of data with the other five columns blank. e. tds and . 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. order_date. 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. The secondary data source just pulls in some names to associate with ID numbers in the primary and some filters for the staff data. Cube data sources do not support pass-through connections. Ritesh Bisht (Member) 6 years ago. Effective visualization. I want to do a basic data listing showing customer, order no, postcode & vat exempt. 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. This would be a great time saver, with all of the calculations and linking changing as well. 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. Data blending is particularly useful when the blend relationship—the linking fields—need to vary on a sheet-by-sheet. 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. Identify your data sources for common data types: both data sources must have a string or date field for linking data sources. Summary:. Upvote Upvoted Remove Upvote Reply. 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. " inner cross database join on BU Code with a data source filter set up on UPPER([ID])=UPPER(USERNAME()) on the DS2 source. Data source A has Role Column and Data source B also has Role Column. So if you drag Category from the Orders data source, it will automatically mark Orders as the primary data source. . 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. However, some days will have entries for "Cost" but not for "Proj. In the secondary (user rights sheet), create a "Verify Username" calculation that has the fmula:. The secondary data source is indicated with an orange tick on the data source and an orange bar down the side of the Data pane. General Information. 4. 1. [amount] into the view, it gives less than. You can also define the relationship manually by right-clicking on the data source name in the Data pane, and selecting Relationships. COUNTD is tough to work on while you. CustomOverall (Primary) 2. Make sure that you are blending on dimensions present in the view or on all of the. General Information. Blended data sources. It takes advantage of the data collected from previous research and uses it to carry out new research. Cube (multidimensional) data sources have certain characteristics that make them unique in Tableau. 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. The blend applies to that worksheet only. In the data window, switch to [name1] data source, and click at least one link icon to blend these data sources. This feature would be really useful to ensure we can. 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. Even if I don't join the 2 data sources and just blend them by "Region" and "Store Name", I still get "Cannot blend the secondary data source because one or more fields use an unsupported aggregation" on dragging Total Utilized Money field into the view. I'm trying to blend two data sources on a single field, say 'Program Description'. The order in which fields are used determines which data source is the primary versus the secondary data source. You can create a federated database using linked tables/worksheets. Instead, publish each data source separately (to the same server) and then blend the published data sources. 2. Any existing, automatic blend kontakte is visible (and pot be deleted by suspend over the row and clicking the x). on Rows, Columns, Pages, or the Marks Card. Fixed, countd functions won't work with the secondary datasources. Both Primary and Secondary data sources have duplicate rows due to multiple joins in data prep. We use three kinds of cookies on our websites: required, functional, and advertising. This means that it forces the view to display only relevant data in the secondary data source. e. Can anybody please help me with a solution. "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. This feature would be really useful to ensure we can. Data blending is particularly useful when the blend relationship. [Field_Name]":"Value_to_filter" in the Options will not work. then i added a secondary data source from google sheet , which has the fuel amount. 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'. Are you talking about Tableau Prep or Tableau Desktop? Any chance you can share a sample of your data? Expand Post. "Cannot blend the secondary data source because one or more fields use the == function, which cannot be computed locally. 0 but was disabled (greyed out) in 8. If you want to filter data across secondary data sources, consider. If I cant go the above way then is there a possibility to do the duration calculation using table calculations or some other way. Modify the calculation to not use table functions;. This happens only when the data sources are impala. See Join your Data for instructions. Use a parameter with a calculated field to filter the secondary data source at the row level. 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. My goal is to show CY Actuals as bars, with a line for PY Actuals and a line for Budget. 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. Whichever data source is used first in the view, becomes the primary data source and the second one to be used in the view is the secondary data source. Twbx and also the . Data blending works only as a left join. 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.