If you make sheet 1 as the primary data source and do the data blending with sheet 2. In this example, Superstore Sales is the primary data source and Coffee Chain is the secondary data source. I am trying to use the measures name filter functionality with two data sources. This means that when a cube data source is published, you cannot make a connection from Tableau Server using the data source. As it turns out, I didn't actually end up using an LOD, but thought I might have to, hence the reason for JOINING the data together as shown in. In a blend, secondary data sources are aggregated and the StoreID dimension would be aggregated to "*". In this case the cross database join will effectively act like the. FIXED requires that you have row-level access to the rows in the secondary source. I am trying to blend the same data against the other because I wanted to show Same Period last Year. if you have blended data sources you can not use lods One of the drawbacks of blended sources . Secondary data source has Order Date represented as separate Year and Month fields. Another way to approach this is to do a join of the data outside Tableau via a federated data source. Primary Data source - Actuals ( day grain) Secondary data source - Goals (quarter grain) Calculated Measures: Primary Data source :- CustCount = CountD( Cust_ID ) Secondary Data source : %of Goal = CustCount/SUM([Goal])The physical layer of the Data Source page canvas is basically the "classic view" of the Data Source page in previous versions of Tableau. Cannot blend the secondary data source because one or more fields use an unsupported aggregation . I am trying to determine the Average Revenue per User by country for which my calculation is total revenue/unique subscribers. Observations : 1. I am getting Cannot blend secondary data source because one or more fields used an unsupported aggregation. The attached workbook and the following steps illustrate the process. 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. Loading. In the Data pane, select the Store - North data source. For more information, see Deciding Between Joining Tables and Blending Data. Use a parameter with a calculated field to filter the secondary data source at the row level. 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. 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. Think of this layer as the Relationships canvas in the Data Source page. “Cannot blend the secondary data source because one or more fields use an unsupported aggregation. General Information. 2, users would define joins and unions between physical tables in which Tableau would create a singular, flat table for analysis. Select Default Properties > Sort. 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. They cannot be used as secondary data sources. Data blending is particularly useful when the blend relationship—the linking fields—need to vary on a sheet-by-sheet. I'm using a cube data source as my primary and am attempting to blend with. Summary:. Answer. 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). The blend is not activated meaning a field from secondary DS is not used in the view. A datetime field in the primary data source, for example, will not blend with a date field in the secondary data source. 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. 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. One data source has some values, the other one has different values. When I calculate the average of a measure and use the filter, it works perfectly fine. e. Are use of grouped fields not allowed in data blending? I have two data sources: Opportunities and Products. Filter each of the data sources independently on the more granular dimensions. My problem happens when I go to the dashboard, I want to filter on FW (fiscal week) and have crosstab. . In the past, I've just changed my primary table to the one with the calculation. A datetime field may be converted to a date field using a calculation to remove the time. For example, COUNTD(). 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. They both share a common field (State), and that is what I'm filtering on. 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. It would be nice if when you blend two data sources, you could have the option to show "Only Relevant Values" on filters used from the secondary data source. However, when I follow your advice, each group splits into 6 rows (one for each month - January through June). Change the default sort order of the field using the various options, and then click OK. The order in which fields are used determines which data source is the primary versus the secondary data source. With the recent release of Tableau Desktop 2020. 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. Fields cannot be used from the [name of secondary data source] data source, because there is no blend relationship to the primary data source. In the data window, switch to [name1] data source, and click at least one link icon to blend these data sources. I use the Opp ID to relate them. This means a data blend can’t be published as a data source for others to use. 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. ”. 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". Data blending brings in additional information from a secondary data source and. thanks. Remove all dimensions from the secondary data source and ensure that the primary data source’s linking field is in view. I have three different data source . I've attached my workbook that contains 2 data sources that are blended by invoice number. But I cant add filter Month from the Budget Excel file. 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. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. All Answers. Loading. This is interesting. e. In this source create a calculated field to pull out the KMs on the date of oil change. Functional cookies enhance functions, performance, and services on the website. For more information, see Use Relationships for Multi-table Data Analysis. Fields from the secondary data source used in the view have an orange check mark. Jim. The data is tracked at the subsite level, so I've utilized LOD calculations to determine the min login time and the max logout time fixed on the site level. 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. Filtering data across a worksheet's secondary data source is not currently supported in Tableau Desktop. You cannot filter data across secondary data sources. Current Year Actuals and Prior Year Actuals are housed in a corporate transnational data source. Click oLoading. 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. . Next, create a table calc using the [Start KM] to calculate the total KMs:Error: Cannot blend the secondary data source because one or more fields use an unsupported aggregation. From my primary data source I have a dimension in columns say 'Customer Segment'. The data in the primary data source is the main data on which Tableau defines graphs and charts. Excel 1 pc. 2) Use data source filters instead of the Filters Shelf. You combine data in the logical layer using relationships (or noodles). 2 came the introduction of a brand-new data model. I am blending (2) data sources based on the date. The secondary data source will have an orange checkmark on it. Does the. One on table it was all upper case on the other one it was a mix of upper and lower case. First data source looks like below. So you need to create a Date field in your Master Data Source, which is why I usedAlternative to CountD function in Blending. I've read through the various posts on here, plus the general troubleshooting posts on the Tableau page on blending data, but can't find a solution. This can restrict many values from 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). [Field_Name]":"Value_to_filter" in the Options will not work. 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. The limitation with Tableau and secondary data sources stinks. 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. From my primary data source I have a dimension in columns say 'Customer Segment'. AUMTable (Secondary) 3. Thanks. Here are the 7 major steps for putting this together: Set up your primary (main) and secondary (parameter) 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. Few things you need to keep in mind while blending data sources in tableau. 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. When you blend, you can only have aggregate access to the rows in the secondary source. In this source create a calculated field to pull out the KMs on the date of oil change. I have been working on Blending feature for a while in different situations and. Another sheet:W2 is created with Data source A - taking Role in Row shelf. Currently, data sources that contain logical tables cannot be used as secondary data sources for data blending. I am just trying to filter every Data source, by choosing a field that every Data source has. I have a primary data source coming from a published data extract blending with a secondary data source coming from an Oracle Database. . In the Data pane, select the State data source (secondary). with blends, we are only able to support aggregates (like SUM, MIN, MAX. Because the question is related to how the data sources are being related, it would help to see the real data structure. This can help researchers identify. Primary Data Source: Extract S. However, when the linking dimension is not in the view, non-additive aLoading. Tableau has two inbuilt data sources named Sample-superstore and Sample coffee chain. If this aggregation is ATTR() then the grand totals may be blank. Then try using the LOD expression from a secondary data source. You can also define the relationship manually by right-clicking on the data source name in the Data pane, and selecting Relationships. But the source calc is a countD. 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. Since my Workbook is present inside Office premise. Note: If the geographic role does not exist in the primary data source, then it will be necessary to create the view with the data source that contains the geographic role as the primary data source. I have 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. Instead, publish. COUNTD is tough to work on while you. Hey all, I'm trying to create a filter in my dashboard such as my two spreadsheets are linked with this filter. 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 if you drag Category from the Orders data source, it will automatically mark Orders as the primary data source. "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. Expand Post Using TableauThe secondary data source is indicated with an orange check mark on the data source and an orange bar down the side of the Data pane. 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. I can't do a join because they are two different file formats. Fee". Ritesh Bisht (Member) 6 years ago. Filter each of the data sources independently on the more granular dimensions. 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. You cannot filter data across secondary data sources. As it is right now (version 8) if you add filters from a secondary data source, you can not cascade the filters based on what the user selects from one filter to the other - this is only. You can choose whether functional and advertising cookies apply. Notice that Calc1 gives you an asterisk if there are multiple values returned from the secondary source. " And after that I can't make my workbook work at all. Marked as. LOD calculation and blended data sources. I tried data blending using the zip codes as a common field but I am facing very slow performance. Step 1: Create the Parameter. All customer IDs are under a dimension called "Global ID". Resolution. * Supplemental data from a secondary data source is needed. See the attached updated workbook. Nitish Pamarty (Member) 7 years ago. "Cannot blend the secondary data source because one or more fields use the == function, which cannot be computed locally. Hi . Give the action a sensible name and configure the action. 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. 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. " I have seen a few posts on it and found an issue logged about it as far back as version 8. For more information, see Troubleshoot Data Blending; Blended data sources cannot be published as a unit. {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 details, see Troubleshoot Data Blending. 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. Name: Distinct Count. 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. 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. xls files). Step 2: Make it a context filter. So, to do Data Blending, the steps that I would suggest would be: - Connect to the data sources that you need to use. 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. Please check the attached workbook for details. 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. To 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). Data > Edit Relationships . id, A. I made a waffle chart grid using an excel data source that contains 3 fields: Rows, Columns and Percentage. You can use data blending when you have data in separate data sources that you want to analyze together on a single sheet. This means that it forces the view to display only relevant data in the secondary data source. Required cookies are necessary for basic website functionality. We are blending two data sources. ×Sorry to interrupt. "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. CSS ErrorHi Mavis Liu. Effective visualization. CSS ErrorData blending is based on two key components- Primary data sources and Secondary data sources. Tableau automatically adds an aggregation (SUM) around the column from the secondary source. 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. Someone in the Community told me the following:A common use case for my analysis is blend a secondary data source then do a table calculation with various independent measures (thus I cannot apply filters). 1) Vizible Difference: Getting around Count Distinct in a secondary data source. All the data is in the secondary/blended data source. However, some days will have entries for "Cost" but not for "Proj. For example, sheet A uses data source 1 as the primary data source; sheet B uses data source 1 as the secondary data source. This. This is the response I received from Tableau Support:Cause. Hi, Because we can't see the entire picture, no detail in the view of the connected data sources, the workbook, etc. CSS ErrorLoading. Remove all dimensions from the secondary data source and ensure that the primary data source’s. Upvote. Excel . Non-additive engine are entirety functions that errichten outcomes that cannot be aggregated along a dimension. Thank you . Hope this helps kindly mark this answer as correct or helpful so that it will help others . There is a possibility that the values can be restricted from the secondary data. However when I use B as primary data source, drag [A]. This happens only when the data sources are impala. Hello Everyone, I am using one data source which is a LIVE connection and I have duplicated same data source , the reason behind duplication is i want to have total of category which will be constant and it will not. I have 2 data sources, A and B, they are linked by data blending with A. To blend on summary data, you can do the following: Create a. " inner cross database join on BU Code with a data source filter set up on UPPER([ID])=UPPER(USERNAME()) on the DS2 source. The default view of Data Source canvas is the logical layer in Tableau version 2020. 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. E make table 2 the primary. 1) When we add fields from secondary data sources to a view Tableau “joins” the data as part of the blend on one or more linking dimensions. The 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. 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 . Both Primary and Secondary data sources have duplicate rows due to multiple joins in data prep. A datetime field in the primary data source, for example, will not blend with a date field in the secondary data source. For more information,. 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. I want to do a basic data listing showing customer, order no, postcode & vat exempt. Expand Post. In the secondary data source, select Data > Create Calculated Field. This means a data blend can’t be published as a data source for others to use. The Products set contain the individual products within an Opportunity whereas the Opportunities set contain Sales metrics (i. amount into the view, it gives me the correct sum. Make sure that you are blending on dimensions present in the view or on. When I do the join between the SSAS Tabular Model (primary data. Loading. (It is a field that contains account names (company) in the sample data. There's a set of views/calcs that show a metric, (metric C) counting distinct number of accounts contacted per person per week (e. Aggregate the date fields at the MY. cannot blend secondary data source because one or more fields use an unsupported aggregation beacuse of LOD. This feature would be really useful to ensure we can. 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 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. Now try to recreate the sheet and link the 2nd and 3rd data. 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 . This is a table calculation equivalent of the COUNTD() database function, which may be required either because the result needs to be used in a calculation at a different level of detail to the level at which it is calculated, or because the datasouce. The first field you drop onto a worksheet defines the primary datasource. Blending your Data in Tableau. We can see these by activating secondary data source and looking at the dimensions window, the linking dimensions will have an orange chain icon. 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. month([date])=month(Parameter. 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. 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. A Level of Detail (LOD) expression is being taken from the secondary data source. Therefore it cannot display null data. e. Limitations of Data Blending in Tableau. See Join Your Data for more information. 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. I have two data sets: the first data set is a shp file from data. Hi Kurt! No, not really. you get all data from main data source and ONLY matching data from secondary data source. Applies to: Tableau Cloud, Tableau Desktop, Tableau Server Data blending is a method for combining data from multiple sources. Selected as Best Selected as Best Upvote Upvoted Remove Upvote 1 upvote. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. Make the field(s) used to address the table calculation active linking fields. Primary and Secondary Data Sources in Tableau: To perform blending in a Tableau sheet, there should be at least one secondary data source. Resolution. 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. Hi Andy, Following up on this - Tableau has been promoting the jump to relationships, in place of joins. For more information, see Troubleshoot Data Blending; Blended data sources cannot be published as a unit. Help would be much. 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. General Information. In Tableau Desktop, navigate to Data > Edit Relationships. I have two datasets; one is a shape file that contains regions and locations. No long-term contract. Hi, I'll expand a bit on what @Chris wrote: There are some fundamental limits to what can be done with data blending and while there are workarounds that can get us the desired results in some circumstances those workarounds will not work in all circumstances (because Tableau never built out data blending to handle every. 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. An orange tick indicates a secondary data source (Promotions). Because there are no linking fields in this view. 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. If the user select May 2018. I cannot change the case of the data to upper or lower. Data blending works only as a left join. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. 3) Select the now grey link next to the original field in. The date values you want to blend on must exist in both data sources. We cannot use ATTR if trying to create an LOD type calculation if blending data sources. 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". Reference line -----> in this approach able to show sub-category items measures like sales and quantity totals as reference lines shown in below figure . Seemingly simple task is getting complicated in Tableau . 1. No. Secondary data is one of the two main types of data, where the second type is the. Option 2: Create a calculation using WINDOW_SUM() Drag the linking field(s) from the secondary data source to. This feature would be really useful to ensure we can. Now you see a new group field listed in the Population data source (primary) called State (group). . Identify your data sources for common data types: both data sources must have a string or date field for linking data sources. 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 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. Verify if one of the measures coming from the cube data source has a default aggregation different than SUM, MIN, MAX, COUNT. LoadingWhen you try to add URL actions to dashboards, fields from secondary data sources cannot be added to the URL. " message. General Information. [tier] == 0 then "Low vendors" elseif max [Secondary]. The blend applies to that worksheet only. ) If only one of the tables requires row level information, consider making that the primary data source in the blend (I. Please check the attached workbook for details. Data blending is used when the linking fields need to vary on a sheet-by-sheet basis for different visualizations. CSS ErrorI am trying to put my LOD calculation (below) on the rows shelf but encountering "cannot blend the secondary data source because one or more fields use an unsupported aggregation" {include [DATE. It throws me cannot blend secondary data source one or more becuase one or more fields use unsupported aggregation . IF ATTR([Offer Status]) = "Hired" Then AVG([Comp_File]. When you drag a field from a secondary data source to the view, you might see a warning that says: Fields cannot be used from the [name of secondary data source] data source, because there is no blend relationship to the primary data source. Currently, I have to rebuild the worksheet and bring in the secondary source first. To overcome this, I've added a filter straight into the data source and not in the view. 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. From what I can tell, joining on Tableau Server Data Sources has been a requested feature for 6 years (Idea: Ability to join Tableau Server data sources). Data blending is a method for combining data from multiple sources. Another way to approach this is to do a join of the data outside Tableau via a federated data source. then i added a secondary data source from google sheet , which has the fuel amount. How ever # no of changes and # of Problems are calculating entire database values. 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. In data blending, there is a primary data source and a secondary data source. LOD expressions are used when running complex queries with multiple dimensions at the data source level. Someone in the Community told me the following: "MAX isn't supported in. I get error: “Cannot blend the secondary data source because one or more fields use an unsupported aggregation. [% age]>=SUM([Percentage]) . [OIL DATE]) THEN MIN ( [KMs]) END. Also, in the attached I have added both Calc1 and Calc2 to the tooltip in Sheet 9. the branch field I'm using from the primary data source. Credits to Jonathan Drummey for the below workaround Cannot blend the secondary data source because one or more fields use an unsupported aggregation . I get error: “Cannot blend the secondary data source because one or more fields use an unsupported aggregation. Data source A has Role Column and Data source B also has Role Column. Blending runs a query on each data source and joins the aggregated results of those queries. 2. 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. However, when I follow your advice, each group splits into 6 rows (one for each month - January through June). Because in Tableau, you don't use COUNTD function when Blending data source. Option 2: Create a calculation for a more dynamic sort. I've created the first chart with no problem, but I. I have just realised why the blending was not working. 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. A datetime field in the primary data source, for example, will not blend with a date field in the secondary data source. Good morning . "Filtering Across Multiple Data Sources Using a Parameter; Cause A sheet cannot be filtered by a field from a secondary data source. 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 Add/Edit User Mapping dialog crate, do the following: Select a select by the primary your data. My goal is to show CY Actuals as bars, with a line for PY Actuals and a line for Budget. In the data window, the blue tick indicates the Primary data source (Sales in the image below). Loading. Calculates the number of distinct values of a field within a partition. We would like to show you a description here but the site won’t allow us. In the attached file, table shows the sum of sales and first order date correctly from both the. Loading. 2) DB2 blending doesn't support non-additive aggregates like COUNTD() from secondary sources. The data source with the KMs is the primary source. The date values must be in the same format. ) So the issue is really the introduction of the group on the sheet. 2) Use this duplicate field in the view instead of the original. Verify if one of the measures coming from the cube data source has a default aggregation different than SUM, MIN, MAX, COUNT. In blending data source, I try to slove problem but I can't. The version I am working with 10. 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". 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. BR, NBBlended data sources cannot be published as a unit. Instead, publish each data source separately (to the same server) and then blend the published data sources. Just aggregates (like SUM, MIN, MAX. To blend on summary data, you can do the following: Create a. 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. When blending in Tableau, there is always a primary source and a secondary data source. But seems we cannot blend 2 secondary data source with same field. 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. I'm using a data blending method, where: Primary data source: Contains the ID I'm trying to count. 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. The date values must be in the same format. "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. Filtering data across a worksheet's secondary data source is not currently supported in Tableau Desktop. 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. ×Sorry to interrupt. (to which I am blending data from other sources Name and Spend) and it worked! Observe the ordering of numbers in the last column between the. I have two data sources which I have blended together on two fields: branch and date. Select Analysis > Create Calculated Field.