Someone in the Community told me the following:A common use case for my analysis is blend a secondary data source then do a table calculation with various independent measures (thus I cannot apply filters). Try one of the following options, as appropriate for your workbook: It may be possible to cross database join instead of blending. As 'Group' is from a secondary data source, I cannot simply use the sort buttons. Use the geographic role in the primary data source on detail instead of the dimension from the secondary data source. Another way to approach this is to do a join of the data outside Tableau via a federated data source. They must be in the same format. Which version of Desktop are you using? See attached the superstore workbook (. When I try to graph the distinct count of project ids vs the VendorClass, however, I see every project getting the. This happens only when the data sources are impala. If you have to have row-level access on a. If you want to make sure you don't lose any measures from the secondary source then either. 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. 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. 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. LOD (exclude) - Filtering using a different data source I've used LOD (exclude) to create a % of total calc field (and then created a moving average off that). Name: Distinct Count. Option 1: Include all linking fields in the view, and aggregate secondary fields Data blending will work when the secondary data source uses logical tables, as long as the following conditions are met: All active linking fields from the primary data source must be included in the view on a shelf other than the Filters shelf Link Primary Source and all other secondary source on this Field Created from step 3- 4 using Edit Data blend Relationships 6. Observations : 1. 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". This is the final step and will result in filtering between the blended data sources at your desired level of granularity. 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. Answer. {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. Chicken + Choice of DrinkBurger + Choice of DrinkSpaghetti + Choice of Drink . CSS ErrorBy default Tableau Desktop wraps fields from a secondary data source in an aggregation in calculated fields. Another table is a a table that contains key fields such as date, region, location and hardware id (dimension). The default view that you first see in the Data Source page canvas is the logical layer of the data source. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. A datetime field may be converted to a date field using a calculation to remove the time portion. My goal is to show CY Actuals as bars, with a line for PY Actuals and a line for Budget. 3 and I have created aggregates AGG for fields from data extract and excel file. Upvote Upvoted Remove Upvote Reply. If this aggregation is ATTR() then the grand totals may be blank. Does the. Chicken - VMBurger + Choice of DrinkBurger - VMSpaghetti + Choice of DrinkSpaghetti - VM Trying to do a COUNTD() from a secondary data source and got this dreaded error: > Cannot blend the secondary data source because one or more fields use an unsupported aggregation . See Join your Data for instructions. 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. Select Analysis > Create Calculated Field. the blended data cannot be published to Tableau Online or Tableau Server. newBranchProjection (Secondary) When I try to add COUNTD([DistrictId]) from my primary to text table. 5 3 . This means a data blend can’t be published as a data source for others to use. Data blending is a method for combining data from multiple sources. I have two data sets: the first data set is a shp file from data. 2, Tableau introduces relationships and splits. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. If I remove the blend, I cannot use/filter the secondary data source, and If I use the blend, it will display only the values for the first data source, but not from the second one. Marked as. Data blending works like a ___ join. I have two data sources and I have blended them together. The version I am working with 10. Create a “Blend Field” with a value of 1 in both your primary and secondary. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. 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. Option 2: Create a calculation for a more dynamic sort. 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 Did some research on this and found plenty of "workarounds" with no. The Products set contain the individual products within an Opportunity whereas the Opportunities set contain Sales metrics (i. From my primary data source I have a dimension in columns say 'Customer Segment'. I am trying to use the measures name filter functionality with two data sources. "Cannot blend the secondary data source because one or more fields use the / function, which cannot be computed locally. All data from a secondary source comes back as an aggregate -- even if there is only one value from the secondary source. It throws me cannot blend secondary data source one or more becuase one or more fields use unsupported aggregation . Drag the State (group) dimension over the Region dimension on the Rows shelf to replace it. 0 but was disabled (greyed out) in 8. If you create a quick filter on a field from data source 1 and apply this quick filter to. A datetime field in the primary data source, for example, will not blend with a date field in the secondary data source. Viz cannot be filtered with secondary data source filter before loading the visualization so using "[DS_Name]. Limitations of Data Blending in Tableau. However, when I follow your advice, each group splits into 6 rows (one for each month - January through June). Data from secondary data sources must always be aggregated in calculations. The blend applies to that worksheet only. This can help researchers identify. Maxdate) There is one more way, make the datasource which is using the fixed calculation to. So, in the dummy data, there are two tables from two data sources. For more information, see Deciding Between Joining Tables and Blending Data. - Dataset 1, records the amount spent on ads as "Cost" - Dataset 2 records the revenue generated by orders as "Proj. Set up the primary and. 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. 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. Resolution. It takes advantage of the data collected from previous research and uses it to carry out new research. See Join Your Data for more information. For example, sheet A uses data source 1 as the primary data source; sheet B uses data source 1 as the secondary 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. Blending your Data in Tableau. Remove all dimensions from the secondary data source and ensure that the primary data source’s linking field is in view. According to Tableau, this error can also appear when using a LOD expression in a blended view. In this case the cross database join will effectively act like the. Any existing, automatic blend kontakte is visible (and pot be deleted by suspend over the row and clicking the x). In order to create the waffle chart I am blending it with another datasource using the calculated field defined as [Week 5 (Week5Bond)]. Left. I have been working on Blending feature for a while in different situations and. Hi Andy, Following up on this - Tableau has been promoting the jump to relationships, in place of joins. Try one of the following options, as appropriate for your workbook: It may be possible to cross database join instead of blending. Option 2: Create a calculation for a more dynamic sort. * Supplemental data from a secondary data source is needed. i. Can anybody please help me with a solution. AUMTable (Secondary) 3. 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. Common Issue #1: Cannot blend the secondary data source because one or more fields use an unsupported aggregation The aggregation methods of COUNTD, MEDIAN, and other non-additive aggregate functions can cause fields to become invalid. Cannot Blend Secondary Data Source - Unsupported Aggregation. [Field_Name]":"Value_to_filter" in the Options will not work. when I use A as primary data source and drag A. Status, Stage, etc). thanks. I use the Opp ID to relate them. The aggregation is all on primary source data. "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. Currently, data sources that contain logical tables cannot be used as secondary data sources for data blending. ” We use three kinds of cookies on our websites: required,. I read that this is not possible. The secondary data source will have an orange checkmark on it. ×Sorry to interrupt. 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. The version I am working with 10. The order in which fields are used determines which data source is the primary versus the secondary data source. If I cant go the above way then is there a possibility to do the duration calculation using table calculations or some other way. We don't get row-level data from secondary sources on a. [tier] == 0 then "Low vendors" elseif max [Secondary]. Thank you . Resolution. This would be a great time saver, with all of the calculations and linking changing as well. 3) COUNTD with Secondary DS (Blending) Thanks,. Fields from the secondary data source used in the view have an orange tick. For more information, see Troubleshoot Data Blending; Blended data sources cannot be published as a unit. (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. Option 2: Join tables that are in the same data source, instead of blending them. IF ATTR([Offer Status]) = "Hired" Then AVG([Comp_File]. Instead, publish. CSS ErrorData blending is based on two key components- Primary data sources and Secondary data sources. ) If only one of the tables requires row level information, consider making that the primary data source in the blend (I. In the Add/Edit User Mapping dialog crate, do the following: Select a select by the primary your data. So, basically, I am having issues with 2 calculations - the FIXED LOD and Remaining Value. Are use of grouped fields not allowed in data blending? I have two data sources: Opportunities and Products. Filtering data across a worksheet's secondary data source is not currently supported in Tableau Desktop. One on table it was all upper case on the other one it was a mix of upper and lower case. If the user select May 2018. FIXED ID, WEEK: CountD (accounts)). Click oLoading. Selected as Best Selected as Best Upvote Upvoted Remove Upvote 1 upvote. You cannot change that. Filtering data across a worksheet's secondary data source is not currently supported in Tableau Desktop. A datetime field in the primary data source, for example, will not blend with a date field in the secondary data source. This will be identified with a blue checkmark. See Join Your Data for more information. I am trying to create a waffle chart. In addition, you cannot blend Measure Values from a secondary data-source, so that rules out this approach as well. Here is situation I am facing, I have blended two data sources and created a worksheet. There's a set of views/calcs that show a metric, (metric C) counting distinct number of accounts contacted per person per week (e. No. One data source has some values, the other one has different values. 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 have uploaded this dummy file since I cannot upload my real data here. "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. It says, "fields cannot be used from [data name] data source, because there is no relationship to the primary. The. One approach that succeeds in adding another measure is to add the measure in question to your. please check the attached workbook. 1. Size() is a great choice for unique counts across data sources if you can create a view where every unique row is displayed. Fee" I want to plot Gross Profit (i. Data > Edit Relationships . In the Data window, right-click the relevant field. "Budget" is only contained in an Excel file data source. Thank you. With the release of Tableau 8. For more information, see Use Relationships for Multi-table Data Analysis. 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. 💥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. But the source calc is a countD. on Rows, Columns, Pages, or the Marks Card. For more information, see Use Relationships for Multi-table Data Analysis. xls files). Output - End output which I need is a table with a single row data for each country with 3 columns Country name, Total Count of DD, Total Cost for DD. Cannot blend the secondary data source since one or more search use certain unsupported aggregation. A data blend cannot filter on dimensions that do not exist in the Primary data source. " message. Identify your data sources for common data types: both data sources must have a string or date field for linking data sources. 4, I tried to blend products (secondary) to storefront (primary) based on Sku. 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. I have three different data source . I am trying to determine the Average Revenue per User by country for which my calculation is total revenue/unique subscribers. 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 two data sets that are linked across Date and Product Category fields. Modify the calculation to not use table functions;. ) So the issue is really the introduction of the group on the sheet. So you need to create a Date field in your Master Data Source, which is why I usedAlternative to CountD function in Blending. 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. Make the field(s) used to address the table calculation active linking fields. Upvote Upvoted Remove Upvote Reply. Any help would be appreciated!Also a data blend is only a LEFT join. Just aggregates (like SUM, MIN, MAX. However, some days will have entries for "Cost" but not for "Proj. I am working with two Data Bases that are essentially the same, but I use the second one to "fake" dates (basically the same date +1 year) in order to use it for the YoY comparison that aligns with the different filters I set. [Work Hours]) So you have to make. Instead of using relationships, double-click into your table to get to the. Excel 1 pc. Fields cannot be used from the [name of secondary data source] data source, because there is no blend relationship to the primary data source. In blending data source, I try to slove problem but I can't. Functional cookies enhance functions, performance, and services on the website. . order_date. you get all data from main data source and ONLY matching data from secondary data source. How to calculate Delta value. Tableau Desktop & Web Authoring. You cannot filter data across secondary data sources. When I calculate the average of a measure and use the filter, it works perfectly fine. So if you drag Category from the Orders data source, it will automatically mark Orders as the primary data source. . Complex as the problem may be, the solution is comfortingly simple. Fee - Cost) over time. Because the question is related to how the data sources are being related, it would help to see the real data structure. 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. Primary and Secondary Data Sources in Tableau: To perform blending in a Tableau sheet, there should be at least one secondary data source. We have a calculated filed where an aggregation (COUNTD) is done on a filed of secondary data source. I am trying to use the below formula instead of countd function because my data comes from Impala. In the past, I've just changed my primary table to the one with the calculation. 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. I am using blending and created Relationship but i am having problem in terms of getting distinct count from one of the data sources. I have two data sources to be used but need the count distinct of users from both the data sources. Help would be much. Another way to approach this is to do a join of the data outside Tableau via a federated data source. BR, NBBlended data sources cannot be published as a unit. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. ” Causes and Workarounds for a Blending Limitation Errors. When I do the join between the SSAS Tabular Model (primary data. I am blending (2) data sources based on the date. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. Hi, I have a scenario where I have to use Data Blending option to get certain metric values from Secondary Data Source. (It is a field that contains account names (company) in the sample data. 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'. Both Primary and Secondary data sources have duplicate rows due to multiple joins in data prep. I made a waffle chart grid using an excel data source that contains 3 fields: Rows, Columns and Percentage. Currently, data sources that contain logical tables cannot be used as secondary data sources for data blending. This can restrict many values from the secondary data source. 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. [tier] == 2 'Top Vendors' else 'Mid Vendors'. Your secondary data source does not have the blend activated, you'll need to click on the link and turn it red to activate:. And I use Join data source, after divide measures / row duplicate. You combine data in the logical layer using relationships (or noodles). In the calculation dialog box, do the following: In the name text box, enter Sales for Store - South. 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. For secondary data source you get same result by managing relationships in your case just Area and Qtr. I'm blending the 2 data sources by Service_Id. In the attached file, table shows the sum of sales and first order date correctly from both the. Loading. 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. Upvote. 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. 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. For example, sheet A uses data source 1 as the primary data source; sheet B uses data source 1 as the secondary data source. Therefore it cannot display null data. Because there are no linking fields in this view. Better collaboration. Filtering data across a worksheet's secondary data source is not currently supported in Tableau Desktop. Loading. You can choose whether functional and advertising cookies apply. The first field you drop onto a worksheet defines the primary datasource. A datetime field may be converted to a date field using a calculation to remove the time portion. Data blending is particularly useful when the blend relationship—the linking fields—need to vary on a sheet-by-sheet. To blend on summary data, you can do the following: Create a. Since my Workbook is present inside Office premise. This functionality was available in versions 8. I like to have the ability to swap a primary data source with a secondary data source for data blending in a workbook. LOD calculation and blended data sources. See Troubleshoot Data Blending - Tableau for more information on this and other errors that may occur while using data blending. In a blend, secondary data sources are aggregated and the StoreID dimension would be aggregated to "*". To fix this, we had to add the fields being used in the blending relationship onto the view: Aside from a few of these, we didn’t need to combine the data in very complicated ways. 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. LOD Expressions will not be shown in the Data Source; When referencing a dimensionality declaration parameter, always use the parameter name and not the parameter value; With data blending, the primary data source's linking field must be in the view before you can use a LOD expression from the secondary data source. I 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. Expand Post. Maxdate) There is one more way, make the datasource which is using the fixed calculation to primary data source. I use the Opp ID to relate them. 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. Non-additive aggregates are aggregate functions that produce results that cannot be aggregated along a dimension. Use blends when:. 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. Common field is the employee ID. The default view of Data Source canvas is the logical layer in Tableau version 2020. The secondary data source just pulls in some names to associate with ID numbers in the primary and some filters for the staff data. I've read through the various posts on here, plus the general troubleshooting posts on the Tableau page on blending data, but can't find a solution. 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. 1) Vizible Difference: Getting around Count Distinct in a secondary data source. No long-term contract. Blending requires primary and secondary data sources. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. When blending in Tableau, there is always a primary source and a secondary data source. LOD will not work if it is from the secondary datasource. the count of claims I'm getting from the secondary data source, by counting distinctly a measure called claimid. 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. This happens regardless if I drag it on the rows or on the Marks space as a 'text'. The unsupported aggregation happens when your aggregate requires row-level visibility to the secondary data source. For more information, see Troubleshoot Data Blending; Blended data sources cannot be published as a unit. 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. However, when the linking dimension is not in the view, non-additive aLoading. 3. 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. Does anyone have any Ideas how I can apply a universal filter. This happens regardless if I drag it on the rows or on the Marks space as a 'text'. I get error: “Cannot blend the secondary data source because one or more fields use an unsupported aggregation. " Is there a way to circumvent this issue? Or perhaps a different method entirely. I have 2 data sources, A and B, they are linked by data blending with A. I think I need to define the relationship between the data sources. Tableau Desktop 2018. Good morning . When you blend, you can only have aggregate access to the rows in the secondary. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. IF min([Current Period ]) = true then [Display Sum Media Cost] end / sum(IF [Current Period ] = true then. They both share a common field (State), and that is what I'm filtering on. 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. Here is the sample. 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. When you data changes, you need to redo the. COUNTD - Blended data. This means a data blend can’t be published as a data source for others to use. Hi Justin, Thanks for your quick reply. Whichever data source you "use first" in a view (by dragging in a field) becomes Primary. png - Ben-Sullins's library "Cannot blend the secondary data source because one or more fields use an unsupported. ×Sorry to interrupt. Blending runs a query on each data source and joins the aggregated results of those queries. 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. However, if you do a full outer join on [Dimension] = [Dimension] then we can know which records match up, and do a calculation like:I like to have the ability to swap a primary data source with a secondary data source for data blending in a workbook. Data blending: Cube data sources can only be used as the primary data source for blending data in Tableau. . Russell Christopher (Member) 10 years ago. 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. I tried data blending keeping File C as primary and A & B as secondary data source with DD number as relationship. Marked as. The problem is when I try to calculate the median of that same measure. Beginning with Tableau Desktop 2020. The condition is offer status = hired, but offer status can contain my different response types. Resolution. Blended data sources. Credits to Jonathan Drummey for the below workaround Cannot blend the secondary data source because one or more fields use an unsupported aggregation . 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. 0, but I imagine someone has been able to identify what is causing the issue. In data blending, there is a primary data source and a secondary data source. 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. [OIL DATE]) THEN MIN ( [KMs]) END. Proj. Data blending is particularly useful when the blend relationship—the linking fields—need to vary on a sheet-by-sheet. We don't get row-level data from secondary sources on a blend. This link might help you: Cannot blend the secondary data source because one or more fields use an unsupported aggregation. Hi . Show moreA workbook or mock data would be a sure thing to comment and try upon it. gov which displays certain regions in the US (a geometry field is auto created in tableau which allows me to create this map easily), the second data source is a data pull from a data warehouse holding lat/long coordinates of specific points (able to create a point via calculated tableau field using the make point function). 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. It is important to understand which is the primary source, it can impact. [% age]>=SUM([Percentage]) . I am trying to blend the same data against the other because I wanted to show Same Period last Year. I ended up purchasing an Alteryx license for our company (we now have a lot. See the attached updated workbook. In the Data pane, select the Store - North data source. Verify if one of the measures coming from the cube data source has a default aggregation different than SUM, MIN, MAX, COUNT. ×Sorry to interrupt. The two data sources are identical. e. The value gets reduced based on filters@@@ from all data source. I have three different data source . 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. LoadingWhen you try to add URL actions to dashboards, fields from secondary data sources cannot be added to the URL. " I have seen a few posts on it and found an issue logged about it as far back as version 8. Date dimensions: For cube data sources, date dimensions are typically organized into hierarchies that contain levels such as year,. Data blending is particularly useful when the blend relationship—the linking fields—need to vary on a sheet-by-sheet. order_date = B. When you blend, you can only have aggregate access to the rows in the secondary source. then i added a secondary data source from google sheet , which has the fuel amount. Summary:. "Cannot blend the secondary data source because one or more fields use the == function, which cannot be computed locally. The chart should display: countd. 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). 1 Connected to Tableau Server as Main DS and Live Connection to an excel file as secundary DSStep 2: Bring summary data from the secondary data source into the primary data source. 1) When we add fields from secondary data sources to a view Tableau “joins” the data as part of the blend on one or more linking dimensions. The limitation with Tableau and secondary data sources stinks. Please refer the below link and let me know if this helps to you. 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. E make table 2 the primary and table. Tableau will throw an error: “Cannot blend the secondary data source because one or more fields use an unsupported aggregation. Cannot blend the secondary data source because one or more fields use an unsupported aggregation . Data & Connectivity. Fee". I've blended on user ID. To blend on summary data, you can do the following: Create a. I'm using a cube data source as my primary and am attempting to blend with. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. Instead, we need to publish the two data sources separately on the same server and then. I'm noticing you are using the Date field from the secondary data source you are working with. CustomOverall (Primary) 2. 2)Count Distinct from Secondary workaround. 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.