So you don't get in the case of data blending. This would be a great time saver, with all of the calculations and linking changing as well. With the recent release of Tableau Desktop 2020. I'm using a cube data source as my primary and am attempting to blend with. The data source with the KMs is the primary source. Let say from DS1 if i am making it as primary datasource then i can get the. i will try to build some moke up data in excel and reproduce the same but before that could you please explain me in detail what calculation i need to perform in secondary source. The primary data source will be identified automatically from any metrics you put on the worksheet first. The problem is when I try to calculate the median of that same measure. Resolution. The condition is offer status = hired, but offer status can contain my different response types. 0 and 7. "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. I ended up purchasing an Alteryx license for our company (we now have a lot. Best solution. ” Causes and Workarounds for a Blending Limitation Errors. From Primary Data Source drag the measure names and measure values . 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. This type of bases does not allow for blend relationship, therefore, you cannot use a filter like this. Tableau Desktop & Web Authoring. 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]). This would be a great time saver, with all of the calculations and linking changing as well. See Join Your Data for more information. Dominic Laird(Member) 5 years ago. Cannot blend the secondary data source because one or more fields use an unsupported aggregation" when Data Blending. In this case, I use Last() as a filter to hide the other rows except the last one and each LOD calculation and blended data sources. You can create a federated database using linked tables/worksheets. 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. When I then published this to server as an extract, then tried to blend it with the first data set I get this error: 2013-10-15_15-03-01. 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. In the Add/Edit User Mapping dialog crate, do the following: Select a select by the primary your data. Data blending; Table Calculations; Resolution Use one of the following workarounds: If possible, join instead of blend your data. Make the field(s) used to address the table calculation active linking fields. Left. with blends, we are only able to support aggregates (like SUM, MIN, MAX. "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. you are blending the 2 excel data sources - blending takes place after the structure for data table for the worksheet has been established - and that is done as you bring dimensions to the rows and columns and apply filters to those dimensions - you will not be able to filter across data sources except at the link after that point💡 Ability to switch primary and secondary data sources. LOD will not work if it is from the secondary datasource. ×Sorry to interrupt. Hi, I have a scenario where I have to use Data Blending option to get certain metric values from Secondary Data Source. I am getting Cannot blend secondary data source because one or more fields used an unsupported aggregation. 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. 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". I have two data sources and doing a data blend. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. 1. The solution. 3) Select the now grey link next to the original field in. The chart should display: countd. 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. We can see these by activating secondary data source and looking at the dimensions window, the linking dimensions will have an orange chain icon. Secondary data sources cannot have logical tables (except when they satisfy specific conditions). I'm trying to blend two data sources on a single field, say 'Program Description'. - Dataset 1, records the amount spent on ads as "Cost" - Dataset 2 records the revenue generated by orders as "Proj. I have three different data source . I have two data sets that are linked across Date and Product Category fields. So make sure you're not using such function while blending. Hi All! 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. This means a data blend can’t be published as a data source for others to use. Your secondary data source does not have the blend activated, you'll need to click on the link and turn it red to activate:. 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. "Cannot blend the secondary data source because one or more fields use the == function, which cannot be computed locally. If that does not help,. 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. If there is another aggregation type such as AGG_AVG being used, change it to one of the supported aggregation listed above in the cube database itself before using in Tableau Desktop. [Field_Name]":"Value_to_filter" in the Options will not work. From what I understand, it's because the link variable must be present in the view, or else it does not work. 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. Remove all dimensions from the secondary data source and ensure that the primary data source’s linking field is in view. Data blending is particularly useful when the blend relationship—the linking fields—need to vary on a sheet-by-sheet. I cannot change the case of the data to upper or lower. Change the default sort order of the field using the various options, and then click OK. Upvote. Beyond that personally I tend to do the work necessary to avoid using data blending in production data sources & views. This is interesting. Filtering data across a worksheet's secondary data source is not currently supported in Tableau Desktop. order_date = B. The version I am working with 10. 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. 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. SandhyaData from the secondary data source (via a data blend) can never be a dimension. I am trying to blend the same data against the other because I wanted to show Same Period last Year. In the past, I've just changed my primary table to the one with the calculation. I have 2 data sources, A and B, they are linked by data blending with A. 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. 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. 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. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. 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. You will need a common column between the two tables in order to blend. Final Words. Could please share me if there is a alternate solution for data source filter logic?Step 1: Place the required field into the Filter for a worksheet which sources the parent data. 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. So, to do Data Blending, the steps that I would suggest would be: - Connect to the data sources that you need to use. 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. All three options are demonstrated in the attached workbook using the sample data set Superstore. You can create a federated database using linked tables/worksheets. " Filtering Across Multiple Data Sources Using a Parameter; Cause A sheet cannot be filtered by a field from a secondary data source. 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. cannot blend secondary data source because one or more fields use an unsupported aggregation beacuse of LOD. Status, Stage, etc). Data blending has some limitations regarding non-additive aggregates such as COUNTD, MEDIAN, and RAWSQLAGG. Data blending works only as a left join. ”. 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. I am trying to . 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. For example, COUNTD(). Thank you. How ever # no of changes and # of Problems are calculating entire database values. The secondary data source just pulls in some names to associate with ID numbers in the primary and some filters for the staff data. Cannot Blend Secondary Data Source - Unsupported Aggregation. In a blend, secondary data sources are aggregated and the StoreID dimension would be aggregated to "*". Help would be much. I'm noticing you are using the Date field from the secondary data source you are working with. To blend on summary data, you can do the following: Create a. Tableau automatically adds an aggregation (SUM) around the column from the secondary source. If you want to make sure you don't lose any measures from the secondary source then either. 3 and I have created aggregates AGG for fields from data extract and excel file. Ken Flerlage (Member) 5 years ago. I have 2 separate data sources that have similar fields. Instead, we need to publish the two data sources separately on the same server and then. 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. When you blend, you can only have aggregate access to the rows in the secondary. Data blending is particularly useful when the blend relationship. As 'Group' is from a secondary data source, I cannot simply use the sort buttons. In order to create the waffle chart I am blending it with another datasource using the calculated field defined as [Week 5 (Week5Bond)]. Overall LOD will show correct result in Primary datasource. 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. I use the Opp ID to relate them. Does anyone have any Ideas how I can apply a universal filter. General Information. you will get 5/22 date. 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 . 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. Fee" I want to plot Gross Profit (i. CSS ErrorAfter Blending, Now it is showing this error: 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. Then you can simply show one filter control on your dashboard and set it to apply to all related data sources. * Supplemental data from a secondary data source is needed. Also, in the attached I have added both Calc1 and Calc2 to the tooltip in Sheet 9. Hi, Because we can't see the entire picture, no detail in the view of the connected data sources, the workbook, etc. 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. Now when I drag and drop the transaction data, everything works just fine, but if I try to use the "Add all Subtotals" option to get the AVG Transactions value for each Market then I am getting the dreaded "Cannot blend the secondary data source because one or more fields use an unsupported aggregation" on my worksheet when I change the "Total. " inner cross database join on BU Code with a data source filter set up on UPPER([ID])=UPPER(USERNAME()) on the DS2 source. LOD will not work if it is from the secondary datasource. [tier] == 2 'Top Vendors' else 'Mid Vendors'. month([date])=month(Parameter. Sometimes , it's automatically working but sometimes it says 'Unsupported Aggregation' . on Rows, Columns, Pages, or the Marks Card. Step 3: Blend the fields with the target data source using simple blending method (clicking those broken links into red)Hi Saukarsha, The linking fields need to be somewhere on the view in order for the blend to work. If you create a quick filter on a field from data source 1 and apply this quick filter to. CSS ErrorLoading. 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. 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. Also I see that if you put [Corrected Date] from the primary source instead of the secondary source, it behaves with the group (and the calc. 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. Secondary data source: spatial file containing the geometry. Twbx and also the . The default view that you first see in the Data Source page canvas is the logical layer of the data source. Step 2: Make it a context filter. The default view of Data Source canvas is the logical layer in Tableau version 2020. 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. So, in the dummy data, there are two tables from two data sources. Loading. LoadingWhen you try to add URL actions to dashboards, fields from secondary data sources cannot be added to the URL. In the secondary (user rights sheet), create a "Verify Username" calculation that has the fmula:. Become a Better Analyst in Just 5 Minutes a Week. 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 noticed there was an issue using Data Blend from 3 different source. Limitations of Data Blending in Tableau. like below . Some examples include: cookies used to. Instead, publish each data. blending [cannot blend Measure Values from a secondary data source] -----> this approach failed . cannot blend aggregated data from secondary data source. In the data window, the blue tick indicates the Primary data source (Sales in the image below). Excel . Resolution. Tableau Desktop 2018. Chicken + Choice of DrinkBurger + Choice of DrinkSpaghetti + Choice of Drink . - Data to Map from - Data to Map to . 3. " message. CSS ErrorBy default Tableau Desktop wraps fields from a secondary data source in an aggregation in calculated fields. 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). The date values you want to blend on must exist in both data sources. My goal is to show CY Actuals as bars, with a line for PY Actuals and a line for Budget. There is a possibility that the values can be restricted from the secondary data. Data source A has Role Column and Data source B also has Role Column. * Blend in the summary of a large dataset to reduce query time. 4. I get error: “Cannot blend the secondary data source because one or more fields use an unsupported aggregation. 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. Both Primary and Secondary data sources have duplicate rows due to multiple joins in data prep. Community Manager update. We have a calculated filed where an aggregation (COUNTD) is done on a filed of secondary data source. You are trying to bring fields from a second data source into a calculation that is being created in the primary (first) data source and aggregations are not consistent - data from the second source comes over as an aggregate - look into what the aggregation is on and how does that relate to what you have in the primary data baseI'm trying to blend two data sources on a single field, say 'Program Description'. Next, create a table calc using the [Start KM] to calculate the total KMs: from Primary data source from Secondary data source. ×Sorry to interrupt. The secondary data source will have an orange checkmark on it. then i added a secondary data source from google sheet , which has the fuel amount. month([date])=month(Parameter. Use a parameter with a calculated field to filter the secondary data source at the row level. 1. [amount] into the view, it gives less than. I am just trying to filter every Data source, by choosing a field that every Data source has. Select Analysis > Create Calculated Field. A datetime field in the primary data source, for example, will not blend with a date field in the secondary data source. I have two data sets: the first data set is a shp file from data. I was now trying to use both calculations you did on a different sheet through data blending. Primary Data Source: Contains a list of all employees and their role. when I use A as primary data source and drag A. AUMTable (Secondary) 3. Data blending is a method for combining data from multiple sources. To alias field values. Loading. This link might help you: Cannot blend the secondary data source because one or more fields use an unsupported aggregation. 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. If you make sheet 1 as the primary data source and do the data blending with sheet 2. id, A. Upvote Upvoted Remove Upvote Reply. Common field is the employee ID. Viz cannot be filtered with secondary data source filter before loading the visualization so using "[DS_Name]. Verify if one of the measures coming from the cube data source has a default aggregation different than SUM, MIN, MAX, COUNT. Because data blending is an ad-hoc LEFT join that aggregates data from the secondary data source, Tableau cannot always perform aggregations that require the full domain. You have a nice example to use for filing a support case, and I recommend that you do that. The blend applies to that worksheet only. "Data Sources that contain logical tables cannot be used as secondary data sources for blending". When I calculate the average of a measure and use the filter, it works perfectly fine. Build whatever calculated fields from the secondary that need to be used in in the primary. Can't see what you are actually doing but Blending data has its limits. e. ×Sorry to interrupt. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. This feature would be really useful to ensure we can. A datetime field in the primary data source, for example, will not blend with a date field in the secondary data source. Secondary Data Source: Contains data relating to the usage of a website (hits). I am trying to blend the same data against the other because I wanted to show Same Period last Year. For more information,. I can add to filters from the data extracts. For more information, see Use Relationships for Multi-table Data Analysis. Step 1: Create the Parameter. Assuming that's what's going on, there's the question of how to work around this. So yes, in [Actual Hrs] you can only use the value from the secondary as an aggregate, and that's why you see: SUM([Networkdays (Test blend data calculation)]. Hello Ritish, You could use Size() and a Las() function as a filter and get the same output. One approach that succeeds in adding another measure is to add the measure in question to your. I get error: “Cannot blend the secondary data source because one or more fields use an unsupported aggregation. " inner cross database join on BU Code with a data source filter set up on UPPER([ID])=UPPER(USERNAME()) on the DS2 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. The default view that you first see in the Data Source page canvas is the logical layer of the data source. 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. (I created calculated fields "Fiscal Year" and "Fiscal Month" on my secondary Superstore example to simulate this. I get a blank sheet on the dashboard using the secondary data source because it looks for CASE SENSITIVE ABC . 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. (It is a field that contains account names (company) in the sample data. Modify the calculation to not use table functions;. This can restrict many values from the secondary data source. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. ×Sorry to interrupt. ×Sorry to interrupt. I am trying to create a waffle chart. Someone in the Community told me the following: "MAX isn't supported in. Fee". I have the same issue, but Primary Data Source is a Tableau Server Data Source (I do not have direct access to the database), and Secondary Data Source is an excel flat file. Fields from the secondary data source used in the view have an orange check mark. Now, in dashboard D1 : has two worksheets W1 and W2. But the source calc is a countD. Hi Andy, Following up on this - Tableau has been promoting the jump to relationships, in place of joins. Hi Justin, Thanks for your quick reply. I am trying to determine the Average Revenue per User by country for which my calculation is total revenue/unique subscribers. data source. Error “Cannot blend the secondary data source because one or more fields use an unsupported aggregation. CSS ErrorI want to blend data from two different sources but on blending the data the filters from primary data source do not work if the case is different in the secondary data source. 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. ×Sorry to interrupt. Data blending is particularly useful when the blend relationship—the linking fields—need to vary on a sheet-by-sheet. It has data from 2003-2012. The "Create Primary Group" operation is bringing the dimension from the secondary into the primary, but it is static, and does not update when your data updates. 2. Fields from the secondary data source used in the view have an orange tick. The value gets reduced based on filters@@@ from all data source. The data in the primary data source is the main data on which Tableau defines graphs and charts. Next, drag Category from the Orders data source onto the view, then select the Orders data source and click the chain icon to blend on Order ID. In second data source i don;t have salesrep column. A datetime field in the primary data source, for example, will not blend with a date field in the secondary data source. You want to apply a filter to related data sources - which is an option if multiple data sources have a field with the same name and data type, or if you define explicit relationships between data sources from the Data menu. It takes advantage of the data collected from previous research and uses it to carry out new research. In Tableau Desktop, navigate to Data > Edit Relationships. Does anyone know if there is a way around this or can you only create a blending whit datasources that were created the same way? I appreciate your help. " I have seen a few posts on it and found an issue logged about it as far back as version 8. But seems we cannot blend 2 secondary data source with same field. Then try using the LOD expression from a secondary data source. I have 2 duplicate data sources that I am blending together (they are duplicate because I want to filter the same data source 2 different ways but show it in. In the Relationships dialog box, under Secondary data source select Custom, and then click Add. How do I blend these data sources by year? - The Tableau Community. No. You can choose whether functional and advertising cookies apply. We cannot use ATTR if trying to create an LOD type calculation if blending data sources. 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). Maxdate) There is one more way, make the datasource which is using the fixed calculation to primary data source. Currently, data sources that contain logical tables cannot be used as secondary data sources for data blending. 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. Upvote Upvoted Remove Upvote Reply. ×Sorry to interrupt. . LOD expressions are used when running complex queries with multiple dimensions at the data source level. Tableau v8 added a new style of data blending (DB2) where the linking field does not have to be in the view. Another way to approach this is to do a join of the data outside Tableau via a federated data source. Select Default Properties > Sort. I am trying to determine the Average Revenue per User by country for which my calculation is total revenue/unique subscribers. The limitation with Tableau and secondary data sources stinks. The date values must be in the same format. Chicken + Choice of Drink1 pc. I can add to filters from the data extracts. Summary:. Relationships cannot be formed between tables from data sources published to Tableau Server or Tableau Online. Any existing, automatic blend kontakte is visible (and pot be deleted by suspend over the row and clicking the x). This is the response I received from Tableau Support:Cause. When I put category on either the row or column shelf I am getting the erro r "Cannot blend the secondary data source because one or more field use an unsupported aggregation". Filtering data across a worksheet's secondary data source is not currently supported in Tableau Desktop. 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). Advantages: Very easy to write and implement. Here is situation I am facing, I have blended two data sources and created a worksheet. Data source filters. 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. 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. Loading. Primary and Secondary Data Sources in Tableau: To perform blending in a Tableau sheet, there should be at least one secondary data source. 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. We use three kinds of cookies on our websites: required, functional, and advertising. If you have to have row-level access on a. Marked as. amount into the view, it gives me the correct sum. 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. 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. E make table 2 the primary. Status, Stage, etc). 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. 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. Non-additive engine are entirety functions that errichten outcomes that cannot be aggregated along a dimension. If I cant go the above way then is there a possibility to do the duration calculation using table calculations or some other way. In the Data window, switch to the [data name2] data source. Common warnings and errors when blending data sources No relationship to the primary data source. To fix this, we had to add the fields being used in the blending relationship onto the view: If attempting to use COUNTD in a secondary data source when blending, see the following additional workarounds: If Tableau Prep cannot be used, see: Getting around Count Distinct in a secondary data source (third party website) Creating a primary group: Bring a Field into the Primary Data Source in Tableau Help Sorted by: 2. I have two data sources which I have blended together on two fields: branch and date. Secondary data source has Order Date represented as separate Year and Month fields. 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. The reason of the errors being unsupported calculation in blend. Effective visualization. CustomOverall (Primary) 2. IF ATTR([Offer Status]) = "Hired" Then AVG([Comp_File]. 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. Whichever data source you "use first" in a view (by dragging in a field) becomes Primary. Hi . I am creating a couple of formulas to display the total booking from the second data source to the first data source. The only workaround I can think of is to put the course code onto the level of detail shelf, but that means that what appear to be solid bars are actually stacked bars. Better collaboration. "Filtering Across Multiple Data Sources Using a Parameter; Cause A sheet cannot be filtered by a field from a secondary data source. I can't do a join because they are two different file formats. When you blend, you can only have aggregate access to the rows in the secondary source. The unsupported aggregation happens when your aggregate requires row-level visibility to the secondary data source. Error: "data sources that contain logical tables cannot be used as secondary data sources for blending" I have two fact based data marts that I want to blend on a combination of dimensions (product, month, currency). Both Primary and Secondary data sources have duplicate rows due to multiple joins in data prep. "Cannot blend aggregated data from the secondary data source with the data on this sheet because there are no linking fields use din the view" I'm using 2 separate data sources connected to Oracle and published to the Tableau server. I have two data sets that are linked across Date and Product Category fields. Yes - you can't bring COUNTD in data blending. Remove all dimensions from the secondary data source and ensure that the primary data source’s. Primary Data Source: Extract S. Please see if it helps , here it says that problem is with COUNT & they have provided one alternative way as well . In the actual data I get the error: Cannot blend the secondary data source because one or more fields use an unsupported aggregation. 2, users would define joins and unions between physical tables in which Tableau would create a singular, flat table for analysis. Tableau has two inbuilt data sources named Sample-superstore and Sample coffee chain. Now you see a new group field listed in the Population data source (primary) called State (group). Credits to Jonathan Drummey for the below workaround Cannot blend the secondary data source because one or more fields use an unsupported aggregation . 2) Use data source filters instead of the Filters Shelf. Filter each of the data sources independently on the more granular dimensions. When on the dashboard, click on the ‘Dashboard’ drop-down and select ‘Actions’. I've attached my workbook that contains 2 data sources that are blended by invoice number. Filter not recognizing blend relationship. [OIL DATE]) THEN MIN ( [KMs]) END. Expand Post. 2 came the introduction of a brand-new data model. 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. Data blending provides a way to combine data from more than one data source on a single worksheet. Are you talking about Tableau Prep or Tableau Desktop? Any chance you can share a sample of your data? Expand Post. If the user select May 2018. Use the geographic role in the primary data source on detail instead of the dimension from the secondary data source. 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. Data. 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. Expand Post.