Expand Post. I was now trying to use both calculations you did on a different sheet through data blending. To blend on summary data, you can do the following: Create a. 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. I am trying to blend the same data against the other because I wanted to show Same Period last Year. I want to do a basic data listing showing customer, order no, postcode & vat exempt. e. 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. Data from a secondary source is displayed along with the primary source data. COUNTD is not possible with Secondary datasource at Tableau (BLENDING) , below is one of the workaround that I would like to share (Maybe there are Many * Many ) I got one query at Tableau forum recently & below is based on the same . In your workbook sheet2 does not contain 5/22 date. 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). Change the default sort order of the field using the various options, and then click OK. 4. The data in the primary data source is the main data on which Tableau defines graphs and charts. IF ATTR([Offer Status]) = "Hired" Then AVG([Comp_File]. Please check the attached workbook for details. . A key difference with blending is that data is aggregated before being "joined" - you'll notice this when you include a column from the secondary source in a calculation in the primary source. But the source calc is a countD. I am trying to blend the same data against the other because I wanted to show Same Period last Year. The limitation with Tableau and secondary data sources stinks. We don't get row-level data from secondary sources on a. This is the response I received from Tableau Support:Cause. When I create an additional calculated field in the primary data source with: COUNTD(Person ID) + COUNTD(Person ID), I receive the cannot blend the secondary data source because. 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. ) A LOD calc is also trying to do stuff at the row level. In the data window, the blue tick indicates the Primary data source (Sales in the image below). We can see these by activating secondary data source and looking at the dimensions window, the linking dimensions will have an orange chain icon. Click oField cannot breathe used from the [name by secondary data source] data original, because there is no mixed relationship to the primary data original. According to Tableau, this error can also appear when using a LOD expression in a blended view. Hello Tableau world!! Am running into the strangest problem when data blending with V8. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. CSS ErrorData blending is based on two key components- Primary data sources and Secondary data sources. 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. 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. Beginning with Tableau Desktop 2020. For secondary data source you get same result by managing relationships in your case just Area and Qtr. {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. For more information,. " Is there a way to circumvent this issue? Or perhaps a different method entirely. I get error: “Cannot blend the secondary data source because one or more fields use an unsupported aggregation. 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". They both share a common field (State), and that is what I'm filtering on. Open. How ever # no of changes and # of Problems are calculating entire database values. Therefore it cannot display null data. 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. Size() is a great choice for unique counts across data sources if you can create a view where every unique row is displayed. targets. Because in Tableau, you don't use COUNTD function when Blending data source. The reason of the errors being unsupported calculation in blend. Data sources can contain logical tables not be used as secondary data sources for data blending. First data source looks like below. I have a primary data source coming from a published data extract blending with a secondary data source coming from an Oracle Database. I'm trying to show a distinct count of claims by branch. Upvote Upvoted Remove Upvote Reply. The two data sources are identical. The two values you mentioned, 5315 - Radio and 5345 - Public Relations, do not appear in your primary data source for 2012, but do appear in the secondary data source, so they cannot be included in the data. There are a few possibilities: 1) Flip the blend so the primary is secondary and vice versa. The reason your blend breaks is that you're blending with Location as a linking field, so when you remove that from your view, Tableau can't blend any longer. 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. Also, in the attached I have added both Calc1 and Calc2 to the tooltip in Sheet 9. Upvote. Which version of Desktop are you using? See attached the superstore workbook (. With the release of Tableau 8. Instead, publish each data. Loading. In the past, I've just changed my primary table to the one with the calculation. 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. 3) Select the now grey link next to the original field in. The solution. "Cannot blend data from the secondary data source with the data on this sheet because there are no linking fields used in the view" Expand Post. Best solution. 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. 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". Try one of the following options, as appropriate for your workbook: It may be possible to cross database join instead of blending. See Join Your Data for more information. Limitations of Data Blending in Tableau. Option 2: Join tables that are in the same data source, instead of blending them. 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). Blended data sources. 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. Verify if one of the measures coming from the cube data source has a default aggregation different than SUM, MIN, MAX, COUNT. Secondary data sources cannot have logical tables (except when they satisfy specific conditions). Jim. 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. Does anyone have any Ideas how I can apply a universal filter. If I cant go the above way then is there a possibility to do the duration calculation using table calculations or some other way. data source. In a blend, secondary data sources are aggregated and the StoreID dimension would be aggregated to "*". 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. Set up the primary and. 1. * Supplemental data from a secondary data source is needed. I am using tableau 2020. BR, NBBlended data sources cannot be published as a unit. Resolution. All data from a secondary source comes back as an aggregate -- even if there is only one value from the secondary source. I think I need to define the relationship between the data sources. Filtering data across a worksheet's secondary data source is not currently supported in Tableau Desktop. CustomOverall (Primary) 2. ×Sorry to interrupt. Fee". I've created the first chart with no problem, but I. In your case, you're after the Total Cases by Employee, so just imagine Employee in place of Category. Each has a joining field with the same name. Non-additive engine are entirety functions that errichten outcomes that cannot be aggregated along a dimension. 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. You can choose whether functional and advertising cookies apply. Relationships: Join: Combines columns: Yes: Cross database joins will not work with all data sources: Joins: Blend: Combines columns: No: Fields from the secondary data source cannot be brought in to the view unless there is a match on. Hi . You can read details here: Logical Tables in Secondary data source. Process for Creating the Dynamic “Parameter”. 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. CSS Errorthe 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 - JimThe secondary data source hasn't been changed and the groups work as filters. This feature would be really useful to ensure we can. For example, sheet A uses data source 1 as the primary data source; sheet B uses data source 1 as the secondary data source. I am trying to determine the Average Revenue per User by country for which my calculation is total revenue/unique subscribers. 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". Show moreA workbook or mock data would be a sure thing to comment and try upon it. Hello Jim, Thank You for your reply. The data are sorted, but each row only shows one month of data with the other five columns blank. I've attached my workbook that contains 2 data sources that are blended by invoice number. ×Sorry to interrupt. I would like to visualize number of distinct hardware. For example, select Analysis > Create Calculated Field, and in the Formula text box, type the. A Level of Detail (LOD) expression is being taken from the secondary data source. 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. Data blending is a good option when you have multiple data sources that cannot be combined through relationships. 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. Not able to share for time being. Secondary data source has Order Date represented as separate Year and Month fields. Observations : 1. 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 . "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. In this source create a calculated field to pull out the KMs on the date of oil change. 3 and I have created aggregates AGG for fields from data extract and excel file. The secondary data source need to be my transaction file and primary data source need to be my budget file. But I cant add filter Month from the Budget Excel file. (I created calculated fields "Fiscal Year" and "Fiscal Month" on my secondary Superstore example to simulate this. Observations : 1. I use the Opp ID to relate them. Ritesh Bisht (Member) 6 years ago. Please find the complete blog here ----> COUNTD with secondary DS Tableau(Blending) Workbook is attached. Excel . Expand Post. I ended up purchasing an Alteryx license for our company (we now have a lot. ) If only one of the tables requires row level information, consider making that the primary data source in the blend (I. Instead, publish each data source separately (to the same server) and then blend the published data sources. 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. Solution in the image 📌 Non-additive aggregates from the primary data source 📌 Non-additive aggregates from the secondary data source 📌 Non-additive aggregates from a multi-connection. 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. A datetime field may be converted to a date field using a calculation to remove the time portion. Russell Christopher (Member) 10 years ago. An orange tick indicates a secondary data source (Promotions). Thank you. with blends, we are only able to support aggregates (like SUM, MIN, MAX. This functionality was available in versions 8. Click on the ‘Add Action’ button and choose ‘Change Set Values’. Moreover, blending is a kind of left join, not exactly a join. Build whatever calculated fields from the secondary that need to be used in in the primary. Select Custom in the relationships list, and then get Attach. I'm blending student data (primary) and staff data (second). "Data Sources that contain logical tables cannot be used as secondary data sources for blending". I made a waffle chart grid using an excel data source that contains 3 fields: Rows, Columns and Percentage. Use blends when:. I can't do a join because they are two different file formats. 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. Some of the function doesn't work properly when we use blending like COUNTD(), LOD{} expression. Please attach. The default view of Data Source canvas is the logical layer in Tableau version 2020. They cannot be used as secondary data sources. This. 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. 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 am creating a couple of formulas to display the total booking from the second data source to the first data source. You combine data in the logical layer using relationships (or noodles). e. 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). LOD will not work if it is from the secondary datasource. 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. 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. an aggregated left join where the aggregation of the secondary data cannot be used to increase the level of detail of the primary data. Hi. Resolution. But seems we cannot blend 2 secondary data source with same field. Seemingly simple task is getting complicated in Tableau . Tableau v8 added a new style of data blending (DB2) where the linking field does not have to be in the view. 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. We use three kinds of cookies on our websites: required, functional, and advertising. Data > Edit Relationships . Status, Stage, etc). 1) Vizible Difference: Getting around Count Distinct in a 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. The Products set contain the individual products within an Opportunity whereas the Opportunities set contain Sales metrics (i. You have a nice example to use for filing a support case, and I recommend that you do that. 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. I am using tableau 2020. Proj. Upvote Upvoted Remove Upvote Reply. Data blending have some limitations regarding non-additive total such like COUNTD, MEDIAN, and RAWSQLAGG. ×Sorry to interrupt. CSS ErrorLoading. This link might help you: Cannot blend the secondary data source because one or more fields use an unsupported aggregation. id = B. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. "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. The relationship is on the facility ID. The aggregation is all on primary source data. 3) COUNTD with Secondary DS (Blending) Thanks,. since i want only offername from secondary source to the view and the measures are produced from primary datasource is pos_trn. To overcome this, I've added a filter straight into the data source and not in the view. ) If only one of the tables requires row level information, consider making that the primary data source in the blend (I. CSS ErrorTo reduce query times when working with a large data source like Store - South, you can use data blending to blend only on the summary data of the large secondary data source (Store - South) with the data in the smaller and presumably faster primary data source (Store - North). It takes advantage of the data collected from previous research and uses it to carry out new research. 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. So if you drag Category from the Orders data source, it will automatically mark Orders as the primary data source. unsupported aggregation. I am trying to determine the Average Revenue per User by country for which my calculation is total revenue/unique subscribers. In data blending, there is a primary data source and a secondary data source. From my primary data source I have a dimension in columns say 'Customer Segment'. Data blending is used when the linking fields need to vary on a sheet-by-sheet basis for different visualizations. 2)Count Distinct from Secondary workaround. 3 and I have created aggregates AGG for fields from data extract and excel file. Filter each of the data sources independently on the more granular dimensions. I like to have the ability to swap a primary data source with a secondary data source for data blending in a workbook. 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. "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. When blending in Tableau, there is always a primary source and a secondary data source. Help would be much. and tried to plot chart, the chart complains that "Data sources that contain logical tables cannot be used as secondary data sources for data binding". Place Organisation Identifier on the level of detail shelf (from the primary source, or both sources) and the blend should work. In your 2nd and 3rd data sources. Instead, the. Cannot blend the secondary data source because one or more fields use an unsupported aggregation" when Data Blending. Here is the sample. 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. When I make the data source as Primary, I am able to see the respective values, Kindly see the below screenshot:- But, when I consider this data source as secondary and then try to use it in primary data source sheet, I get this error:- Cannot blend the secondary data source because one or more fields use an unsupported aggregation. In the actual data I get the error: Cannot blend the secondary data source because one or more fields use an unsupported aggregation. The value gets reduced based on filters@@@ from all data source. The unsupported aggregation happens when your aggregate requires row-level visibility to the secondary data source. I have two data sets that are linked across Date and Product Category fields. {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. See. 2. We have a calculated filed where an aggregation (COUNTD) is done on a filed of secondary data source. "Cannot blend the secondary data source because one or more fields use the == function, which cannot be computed locally. Whichever data source you "use first" in a view (by dragging in a field) becomes Primary. In the Data pane, select the Store - North data source. A datetime field in the primary data source, for example, will not blend with a date field in the secondary data source. 1. In this case the cross. Relationships cannot be formed between tables from data sources published to Tableau Server or Tableau Online. If multiple logical tables are related in a Tableau data source that source cannot be used as the secondary data source in a Tableau data blend, it can only be used as the primary Therefore one workaround is the Create Primary Group function that you described which "copies" the field from B into A as a group. 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 . 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. The point is to do row-level work in the secondary source, so that when the blend pulls data it doesn't have to do the row-level work. 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. Right-click in the Data window and then. To alias field values. " Expand Post. 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. Here's the data blend view with the secondary data source selected so we can see what blend fields are used:. Data. LoadingWhen you try to add URL actions to dashboards, fields from secondary data sources cannot be added to the URL. I am trying to use the below formula instead of countd function because my data comes from Impala. 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. But I cant add filter Month from the Budget Excel file. For more information, see Troubleshoot Data Blending; Blended data sources cannot be published as a unit. 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. if you have blended data sources you can not use lods One of the drawbacks of blended sources . I am able to achieve the desired results but I am getting a warning ' Fields cannot be used from the [name of secondary data source] data source, because there is no blend relationship to the primary data source. amount into the view, it gives me the correct sum. Aside from consulting the primary origin or source, data can also be collected through a third party, a process common with secondary data. I want to display all values for all different data sources, and use them as filters, and filter the relevant records from both datasources at the same time. I've blended on user ID. Filter each of the data sources independently on the more granular dimensions. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. See the attached updated workbook. Primary and Secondary sources in data blending. Instead of using relationships, double-click into your table to get to the. Are use of grouped fields not allowed in data blending? I have two data sources: Opportunities and Products. Make sure that you are blending on dimensions present in the view or on. The date values you want to blend on must exist in both data sources. 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. When I calculate the average of a measure and use the filter, it works perfectly fine. Fields cannot be used from the [name of secondary data source] data source, because there is no blend relationship to 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. " And after that I can't make my workbook work at all. I'm blending the 2 data sources by Service_Id. The date values must be in the same format. 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. This can help researchers identify. I have just realised why the blending was not working. What I'm trying to do is, create a new column in the 'data to map to' table, saying I only want to see 'PY Sales' numbers where the 'Period' column is equal to the MAXIMUM of 'Sales Cycle' column from 'Data to Map from' table, which is from. i. ) So the issue is really the introduction of the group on the sheet. The blend applies to that worksheet only. This is indicated by the following icon: The view you are trying to build will function if you use the date from the primary data source (Shipped): Let us know if this is clear, or if more explanation is required! Cheers, TimothyCube data sources are used as primary data sources to blend data in Tableau and cannot be used as secondary data sources. CSS ErrorIF user chooses month X and parameters/filters like gender/age/etc, THEN count all distinct users from data set #2 where the date of data set #2 is from 2017-08-01 through today's date. 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. ” Causes and Workarounds for a Blending Limitation Errors 1. Twb, . LOD calculation and blended data sources. 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. duplicate the date field. Data of any sort coming from a secondary source must come as an aggregate of some sort. Expand Post. FIXED requires that you have row-level access to the rows in the secondary source. Both Primary and Secondary data sources have duplicate rows due to multiple joins in data prep. Data blending works only as a left join. In the Data pane, switch to the [name of secondary data source] data source, and click at least one link icon to blend these data sources. e. In this case the cross database join will effectively act like the. The date values you want to blend on must exist in both data sources. In the data window, switch to [name1] data source, and click at least one link icon to blend these data sources. In the Data pane, select the State data source (secondary). It says, "fields cannot be used from [data name] data source, because there is no relationship to the primary. blending [cannot blend Measure Values from a secondary data source] -----> this approach failed . This can restrict many values from the secondary data source. 0 but was disabled (greyed out) in 8. This feature would be really useful to ensure we can. The unsupported aggregation happens when your aggregate requires row-level visibility to the secondary data source. I have two data sources and I have blended them together. " inner cross database join on BU Code with a data source filter set up on UPPER([ID])=UPPER(USERNAME()) on the DS2 source. I would like to ask for your help, I do have two data sources: BI Cube (primary source) & Excel file (secondary) BI Cube Data 1 pc. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. Change the default sort order of the field using the various options, and then click OK. Mihai Constantinescu (Member) 6 years ago. Now, in dashboard D1 : has two worksheets W1 and W2. I am getting Cannot blend secondary data source because one or more fields used an unsupported aggregation. 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. The data source with the KMs is the primary source. In the Data window, right-click the relevant field. We cannot publish a blended data source as a single data source on the server. However, I still get that message saying cannot blend the secondary data source because one or more fields use an unsupported aggregation". It has data from 2003-2012. Loading. And I want to add one of the field from secondary dataset to be in the filter. I receive this error: "Cannot blend the data source because one or more fields uses an unsupported aggregation". Cannot blend the secondary data source because one or more fields use an unsupported aggregation. One of the Dimension which is part of the Relationship between Primary and Secondary Data Source is being used in Filter and the same field cannot be displayed in Report as it changes the Level of grain of the reportIm using two data source to develop the workbook. 1. Data blending is particularly useful when the blend relationship. The version I am working with 10. Cannot blend the secondary data source because one or more fields use an unsupported aggregation issue. Option 1: Join the data sources with a cross-database join instead of blending. If you create a quick filter on a field from data source 1 and apply this. 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. AUMTable (Secondary) 3. AUMTable (Secondary) 3. As 'Group' is from a secondary data source, I cannot simply use the sort buttons. 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". on Rows, Columns, Pages, or the Marks Card. 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. In short, Tableau connects to multiple data sources, sends independent queries to those data sources, and then combines (or “blends”) the aggregated results of the independent queries on a single worksheet.