According to Tableau, this error can also appear when using a LOD expression in a blended view. I ended up purchasing an Alteryx license for our company (we now have a lot. General Information. month([date])=month(Parameter. like below . 1. Loading. As we know the link cant be established unless we use this common dimension (Region Filter) in the view, we can mimic the view by adding the Region Filter Dimension to rows/Columns shelf and uncheck the show header. 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. 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. 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. Sometimes , it's automatically working but sometimes it says 'Unsupported Aggregation' . We cannot publish a blended data source as a single data source on the server. 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. The version I am working with 10. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. 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. [amount] into the view, it gives less than. Right-click in the Data window and then. In your 2nd and 3rd data sources. The date values must be in the same format. LoadingWhen you try to add URL actions to dashboards, fields from secondary data sources cannot be added to the URL. . I have two data sets that are linked across Date and Product Category 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). Hi Justin, Thanks for your quick reply. 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. Primary and Secondary Data Sources in Tableau: To perform blending in a Tableau sheet, there should be at least one secondary data source. " Expand Post. 3. 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. 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. For example, select Analysis > Create Calculated Field, and in the Formula text box, type the. Seemingly simple task is getting complicated in Tableau . It's a technical limitation. When you blend, you can only have aggregate access to the rows in the secondary. 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. In the calculation dialog box, do the following: In the name text box, enter Sales for Store - South. 2 came the introduction of a brand-new data model. Hello Tableau world!! Am running into the strangest problem when data blending with V8. CustomOverall (Primary) 2. The syntax for calling secondary data source field is not. We don't get row-level data from secondary sources on a. Data blending is a method for combining data from multiple sources. Does anyone have any Ideas how I can apply a universal filter to 5 different unrelated data sources? Applies to: Tableau Cloud, Tableau Desktop, Tableau Server. For more information, see Use Relationships for Multi-table Data Analysis. Secondary Data Source: Extract W. 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. 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. And I want to add one of the field from secondary dataset to be in the filter. 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. month([date])=month(Parameter. I establish the blend relationships explicitly by going to Data -->Edit Blend Relationships, and selecting the fields that should be related. Use a parameter with a calculated field to filter the secondary data source at the row level. 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 the == function, which cannot be computed locally. The unsupported aggregation happens when your aggregate requires row-level visibility to the secondary data source. You cannot change that. Verify if one of the measures coming from the cube data source has a default aggregation different than SUM, MIN, MAX, COUNT. Community Manager update. (I created calculated fields "Fiscal Year" and "Fiscal Month" on my secondary Superstore example to simulate this. I am trying to determine the Average Revenue per User by country for which my calculation is total revenue/unique subscribers. Data source filters. 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. Expand Post. I am trying to use the below formula instead of countd function because my data comes from Impala. Upvote Upvoted Remove Upvote Reply. Expand Post. In order to create the waffle chart I am blending it with another datasource using the calculated field defined as [Week 5 (Week5Bond)]. "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. [OIL DATE]) THEN MIN ( [KMs]) END. Tableau Desktop 2018. Consider joining the two data sources together using Tableau Prep, and then you can use that data as a. Make sure that you are blending on dimensions present in the view or on all of the. Open. In the secondary data source, select Data > Create Calculated Field. COUNTD is tough to work on while you. The date values must be in the same format. Hope this helps kindly mark this answer as correct or helpful so that it will help others . Data blending; Table Calculations; Resolution Use one of the following workarounds: If possible, join instead of blend your data. Blending from a polygon-based map to an existing data source which uses 1-to-many joins. Please refer the below link and let me know if this helps to you. 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. 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. [tier] == 0 then "Low vendors" elseif max [Secondary]. I am blending 2 data sets by employee id and when i am trying to group a field from the primary database, it is showing me below error: Cannot blend the secondary data source because one or more fields use an unsupported aggregation. Data from secondary data sources must always be aggregated in calculations. We cannot use ATTR if trying to create an LOD type calculation if blending data sources. Common Issue #1: Cannot blend the secondary data source because one or more fields use an unsupported aggregation The aggregation methods of COUNTD,. LOD calculation and blended data sources. From my primary data source I have a measure in rows, say 'Measure, which is 'distinct count of Pol Number' or 'sum of Premium' depending on a boolean parameter's values (TRUE or. 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. 2. An orange tick indicates a secondary data source (Promotions). Primary Data Source: Contains a list of all employees and their role. Loading. First data source looks like below. 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. The unsupported aggregation happens when your aggregate requires row-level visibility to the secondary data source. 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 secondary data source will have an orange checkmark on it. I am blending (2) data sources based on the date. I noticed there was an issue using Data Blend from 3 different source. Pick the secondary data source in of Secondary data source pane. 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. Expand Post. ×Sorry to interrupt. ” Causes and Workarounds for a Blending Limitation Errors. A Level of Detail (LOD) expression is being taken from the secondary data source. 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. Tableau will throw an error: “Cannot blend the secondary data source because one or more fields use an unsupported aggregation. You can use data blending when you have data in separate data sources that you want to analyze together on a single sheet. 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 just realised why the blending was not working. Data & Connectivity. The blend is not activated meaning a field from secondary DS is not used in the view. This link might help you: Cannot blend the secondary data source because one or more fields use an unsupported aggregation. 1) Vizible Difference: Getting around Count Distinct in a secondary data source. My problem happens when I go to the dashboard, I want to filter on FW (fiscal week) and have crosstab. 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. However, when I follow your advice, each group splits into 6 rows (one for each month - January through June). 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". 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. Option 2: Join tables that are in the same data source, instead of blending them. 2 and later. Instead, publish each data source separately (to the same server) and then blend the published 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. 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. Set up the primary and. . 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. 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. drag the secondary measures to measure values section . Show moreA workbook or mock data would be a sure thing to comment and try upon it. Maxdate) There is one more way, make the datasource which is using the fixed calculation to primary data source. 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. From what I understand, it's because the link variable must be present in the view, or else it does not work. If you create a quick filter on a field from data source 1 and apply this. I would like to visualize number of distinct hardware. In this case the cross database join will effectively act like the. 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. Select Default Properties > Sort. There's a set of views/calcs that show a metric, (metric C) counting distinct number of accounts contacted per person per week (e. In this source create a calculated field to pull out the KMs on the date of oil change. Next, create a table calc using the [Start KM] to calculate the total KMs: from Primary data source from Secondary data source. ) A LOD calc is also trying to do stuff at the row level. Hi there, I got a question about how can I count distinct customer ID? I have 10k customer IDs, some of them appear more than once. " Is there a way to circumvent this issue? Or perhaps a different method entirely. I use the Opp ID to relate them. Data blending tools can present their findings as visualizations, such as infographics and charts, after querying data sources and aggregating relevant information. [% age]>=SUM([Percentage]) . In my primary, I define another calculated field to do the aggregation for each project by tier: VendorClass: if max [Secondary]. Then, after data blending, the final graph cannot show the data related to the South and East. 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. Now we have to use W2 as Filter - to filter out the data. Trying to do a COUNTD() from a secondary data source and got this dreaded error: Cannot blend the secondary data source because one or more fields use an unsupported aggregation Did some research on this and found plenty of "workarounds" with no success, because apparently blending sucks and I shouldn't be using it. You can read details here: Logical Tables in Secondary data source. However, I still get that message saying cannot blend the secondary data source because one or more fields use an unsupported aggregation". In the Data window, right-click the relevant field. ×Sorry to interrupt. They cannot be used as secondary data sources. 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. Did some research on this and found plenty of "workarounds" with no success (like replacing COUNTD() with a LoD using AVG(# of Records))Workaround: Option 1: Instead of using Data Blend, please use Relationship to relate the data sources, and the "Only relevant values" option is available to show only existing values. This would be a great time saver, with all of the calculations and linking changing as well. Therefore it cannot display null data. ) So the issue is really the introduction of the group on the sheet. Resolution. I tried data blending keeping File C as primary and A & B as secondary data source with DD number as relationship. We are blending two data sources. 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]). ×Sorry to interrupt. Currently, data sources that contain logical tables cannot be used as secondary data sources for data blending. I have been working on Blending feature for a while in different situations and. 3 and I have created aggregates AGG for fields from data extract and excel file. Ken Flerlage (Member) 5 years ago. Jim. The Products set contain the individual products within an Opportunity whereas the Opportunities set contain Sales metrics (i. Currently, data sources that contain logical tables cannot be used as secondary data sources for data blending. The aggregation is all on primary source data. blending [cannot blend Measure Values from a secondary data source] -----> this approach failed . 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. 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. 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. amount into the view, it gives me the correct sum. I have two data sources and I have blended them together. I tried data blending using the zip codes as a common field but I am facing very slow performance. 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. Data blending works like a ___ join. I have two data sets: the first data set is a shp file from data. 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. In the Data window, switch to the [data name2] data source. 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. We use three kinds of cookies on our websites: required, functional, and advertising. 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. then i added a secondary data source from google sheet , which has the fuel amount. Advantages: Very easy to write and implement. " message. Blending takes place in the 6th step of the order of operation after the data table for the individual worksheet is set and the filters applied - data from the secondary source are aggregated at the level of the link and brought to the primary as. 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. They must be in the same format. I can get all the fields into the view apart from the 'is vat exempt'. Filtering data across a worksheet's secondary data source is not currently supported in Tableau Desktop. You must double-click a logical table in the Data Source page canvas to go to the physical layer of the canvas. 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. e. Blending with CountD and LODs. However, it gives me following error: "Cannot blend the secondary data source because one or more fields use an unsupported aggregation"We have an enterprise data source that is an SSAS Tabular model. - Go to Data > Edit Relationships to create the define primary and secondary data sources and the links - Drag and drop the linked field from the primary data source to use this field on the visualisation. When you data changes, you need to redo the. To provide comparative data: Secondary data can be used to compare and contrast findings across different studies or datasets. ×Sorry to interrupt. 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, excluding. "Cannot blend the secondary data source because one or more fields use the == function, which cannot be computed locally. Click oLoading. To overcome this, I've added a filter straight into the data source and not in the view. Remove all dimensions from the secondary data source and ensure that the primary data source’s. 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. ×Sorry to interrupt. I have 2 data sources, A and B, they are linked by data blending with A. I have the total number of headcounts on one data set, and the number of attritions on the other so I am trying to write number of records (datasource1)/total headcounts (datasource2) and i get the red pill telling me "cannot blend the secondary datasource because one or more fields use an unsupported aggregation". The default view that you first see in the Data Source page canvas is the logical layer of the data source. BR, NBBlended data sources cannot be published as a unit. When I try to graph the distinct count of project ids vs the VendorClass, however, I see every project getting the. For secondary data source you get same result by managing relationships in your case just Area and Qtr. They both share a common field (State), and that is what I'm filtering on. For more information, see Deciding Between Joining Tables and Blending Data. 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. I cannot able to use as one connection since am using the data source filter in my first connection have data source filter. In Tableau Desktop, navigate to Data > Edit Relationships. This. 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. You can create a federated database using linked tables/worksheets. Change the default sort order of the field using the various options, and then click OK. This would be a great time saver, with all of the calculations and linking changing as well. 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. Upvote Upvoted Remove Upvote Reply. See Troubleshoot Data Blending - Tableau for more information on this and other errors that may occur while using data blending. Data blending is particularly useful when the blend relationship—the linking fields—need to vary on a sheet-by-sheet. It says, "fields cannot be used from [data name] data source, because there is no relationship to the primary. I have three different data source . To the Data pane, umschaltung in this [name of secondary data source] data source, real click at lowest one link icon to blend that data sources. E make table 2 the primary. A datetime field in the primary data source, for example, will not blend with a date field in the secondary data source. 0 but was disabled (greyed out) in 8. 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. Identify your data sources for common data types: both data sources must have a string or date field for linking data sources. Option 1: Include all linking fields in the view, and aggregate secondary fields Data blending will work when the secondary data source uses logical tables, as long. Option 2: Create a calculation for a more dynamic sort. But since there are a few dates missing from the second data source i cannot blend on date as doing this will result in loosing data from Table 1. This happens only when the data sources are impala. I'm trying to show a distinct count of claims by branch. I am trying to create a waffle chart. Filter each of the data sources independently on the more granular dimensions. We use three kinds of cookies on our websites: required, functional, and advertising. Unknown file type Total from Secondary Data Source. FIXED requires that you have row-level access to the rows in the secondary source. 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. Data source A has Role Column and Data source B also has Role Column. I'm trying to show a distinct count of claims by branch. 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 . 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. All customer IDs are under a dimension called "Global ID". 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. This happens only when the data sources are impala. All three options are demonstrated in the attached workbook using the sample data set Superstore. Data blending is particularly useful when the blend relationship. Filtering data across a worksheet's secondary data source is not currently supported in Tableau Desktop. Here are the 7 major steps for putting this together: Set up your primary (main) and secondary (parameter) data sources. 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". The Products set contain the individual products within an Opportunity whereas the Opportunities set contain Sales metrics (i. Data blending is a method for combining data from multiple sources. Data blending works only as a left join. 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. I have two data sources to be used but need the count distinct of users from both the data sources. I cannot change the case of the data to upper or lower. But I cant add filter Month from the Budget Excel file. 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". Select Default Properties > Sort. - Dataset 1, records the amount spent on ads as "Cost". Here is the sample. I am confused, as I am not even trying to blend Data from both Data Sources. 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. Help would be much. Instead, the. A secondary data source can be used to re-alias the field values in a primary 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. After blending, CountD works fine on primary datasource, but when I try to use CountD on secondary datasource tableau gives error: "Cannot blend secondary data source as one or more fields use an unsupported aggregation" Because of this, our overall. order_date = B. Aside from consulting the primary origin or source, data can also be collected through a third party, a process common with secondary data. 3) COUNTD with Secondary DS (Blending) Thanks,. Tableau Desktop & Web Authoring. I was now trying to use both calculations you did on a different sheet through data blending. 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. I made a waffle chart grid using an excel data source that contains 3 fields: Rows, Columns and Percentage. The first field you drop onto a worksheet defines the primary datasource. Filtering data across a worksheet's secondary data source is not currently supported in Tableau Desktop. We use three kinds of cookies on our websites: required, functional, and advertising. Try one of the following options, as appropriate for your workbook: It may be possible to cross database join instead of blending. 1, the ability to "Show Empty Rows" (or columns) was removed when you use a secondary data source. [Work Hours]) So you have to make. . The order in which fields are used determines which data source is the primary versus the secondary data source. 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. It throws me cannot blend secondary data source one or more becuase one or more fields use unsupported aggregation . Please attach. To alias field values. Additional Information While replacing ATTR() with MIN() will cause "Automatic" grand totals to show, the grand totals might not be the expected values. Yes - you can't bring COUNTD in data blending. Applies to: Tableau Cloud, Tableau Desktop, Tableau Server Data blending is a method for combining data from multiple sources. you get all data from main data source and ONLY matching data from secondary data source. 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)]. 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. 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. AUMTable (Secondary) 3. I am trying to determine the Average Revenue per User by country for which my calculation is total revenue/unique subscribers. 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. Then try using the LOD expression from a secondary data source. Upvote Upvoted Remove Upvote Reply. And I use Join data source, after divide measures / row duplicate. I get around it by adding "max" in front of the first one again, and it says calculation is valid, but once I try to add it to the view it gives the error "Cannot blend the secondary data. Name: Distinct Count. - Dataset 1, records the amount spent on ads as "Cost" - Dataset 2 records the revenue generated by orders as "Proj. Does anyone have any Ideas how I can apply a universal filter. ×Sorry to interrupt. [tier] == 2 'Top Vendors' else 'Mid Vendors'. This is a new complexity in Tableau v8: In v7 and earlier, to blend we had to have the linked dimensions in the view, i. Excel 1 pc. Secondary data sources cannot have logical tables (except when they satisfy specific conditions). Can anybody please help me with a solution. In a blend, the secondary data source can only contribute aggregated values using the level of detail defined by the linking fields that appear in the view, so when you remove them, the. 5 3 . Data blending is used when the linking fields need to vary on a sheet-by-sheet basis for different visualizations. Tableau Community (Tableau)Data blending creates a link on common dimensions--where those commonalities do not exist in the two data sources, values will be excluded. 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. Expand Post. 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. I am trying using { FIXED : SUM[(portfolioValue)]}. In the Data pane, select the State data source (secondary). 1. In the Add/Edit Field Mapping dialog box, select the date fields from the primary and secondary data sources, and then click OK twice. This is the final step and will result in filtering between the blended data sources at your desired level of granularity. A datetime field in the primary data source, for example, will not blend with a date field in the secondary data source. * Blend in the summary of a large dataset to reduce query time. Did some research on this and found plenty of "workarounds" with no success (like replacing COUNTD() with a LoD using AVG(# of Records)) Workaround: Option 1: Instead of using Data Blend, please use Relationship to relate the data sources, and the "Only relevant values" option is available to show only existing values. In the Data window, right-click the relevant field. , it's difficult to determine; however, what you could do is click on each data source and if you see a chain link that is solid and not broken where fields might be related/blended in the tables below, then click the icon to unlink it. This is interesting. In data blending, there is a primary data source and a secondary data source. In addition, you cannot blend Measure Values from a secondary data-source, so that rules out this approach as well. Currently, data sources that contain logical tables cannot be used as secondary data sources for data blending. The primary data source is just to filter for the invoices I want to look at. 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. i. 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 . Tableau v8 added a new style of data blending (DB2) where the linking field does not have to be in the view. I get a blank sheet on the dashboard using the secondary data source because it looks for CASE SENSITIVE ABC . 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. " Filtering Across Multiple Data Sources Using a Parameter; Cause A sheet cannot be filtered by a field from a secondary data source. " I have seen a few posts on it and found an issue logged about it as far back as version 8. 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. Since my Workbook is present inside Office premise. Alternate names:. This functionality was available in versions 8. Non-additive engine are entirety functions that errichten outcomes that cannot be aggregated along a dimension. 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. 4, I tried to blend products (secondary) to storefront (primary) based on Sku. The limitation with Tableau and secondary data sources stinks. cannot blend secondary data source because one or more fields use an unsupported aggregation beacuse of LOD. 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). I'm using a data blending method, where: Primary data source: Contains the ID I'm trying to count. Cannot blend the secondary data source because one or more fields use an unsupported aggregation It’s cable reimagined No DVR space limits. Another sheet:W2 is created with Data source A - taking Role in Row shelf. 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). Each has a joining field with the same name. This happens regardless if I drag it on the rows or on the Marks space as a 'text'. The date values you want to blend on must exist in both data sources. Some examples include: session cookies needed to transmit the website, authentication cookies, and security cookies. In data source A, I have COUNTD(Person ID) and in data source B, I have COUNTD(Person ID). This feature would be really useful to ensure we can. Primary and Secondary sources in data blending. Cannot blend the secondary data source because one or more fields use an unsupported aggregation.