Cannot blend the secondary data source because one or more fields use an unsupported aggregation. I tried data blending keeping File C as primary and A & B as secondary data source with DD number as relationship. This happens regardless if I drag it on the rows or on the Marks space as a 'text'. 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. I'm trying to create a frequency distribution as a percent of total for individual products in a single category on one chart, then dual axis a second chart with the frequency distribution of the category for comparison purposes. id = B. See Join Your Data 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. 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. If you make sheet 1 as the primary data source and do the data blending with sheet 2. I have two data sources which I have blended together on two fields: branch and date. In the Add/Edit Field Mapping dialog box, select the date fields from the primary and secondary data sources, and then click OK twice. Resolution. ) A LOD calc is also trying to do stuff at the row level. We are blending two data sources. A datetime field may be converted to a date field using a calculation to remove the time. I'm trying to show a distinct count of claims by branch. Loading. order_date = B. ×Sorry to interrupt. For secondary data source you get same result by managing relationships in your case just Area and Qtr. Upvote Upvoted Remove Upvote Reply. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. And I want to add one of the field from secondary dataset to be in the filter. 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)]. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. I am confused, as I am not even trying to blend Data from both Data Sources. Set up the primary and. Upvote Upvoted Remove Upvote Reply. 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. This happens only when the data sources are impala. 4. Common Issue #1: Cannot blend the secondary data source because one or more fields use an unsupported aggregation The aggregation methods of COUNTD,. The relationship is on the facility ID. 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. Hi Data Modeler , I have an idea which I cannot test right away. duplicate the date field. 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. e. 1. Nitish Pamarty (Member) 7 years ago. My problem happens when I go to the dashboard, I want to filter on FW (fiscal week) and have crosstab. . However, when I follow your advice, each group splits into 6 rows (one for each month - January through June). This can restrict many values from the secondary data source. So you need to create a Date field in your Master Data Source, which is why I usedAlternative to CountD function in Blending. In the formula text box, type the ZN function, the SUM. 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. All data from a secondary source comes back as an aggregate -- even if there is only one value from the secondary source. According to Tableau, this error can also appear when using a LOD expression in a blended view. It sounds like there might be some complications with a blend? Can’t speak to what’s happening thereAre you blending on [Endtimestamp]? By using the formula DAY([Endtimestamp]), you're changing the dimensionality a little bit. when I use A as primary data source and drag A. General Information. 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". What steps do I need to do to do this?It shows the next message: "Cannot blend the secondary data source because one or more fields use an unsupported aggregation". 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. I've created the first chart with no problem, but I. Complex as the problem may be, the solution is comfortingly simple. Data blending is a method for combining data from multiple sources. 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. Please refer the below link and let me know if this helps to you. 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. For more information,. 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. "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. Excel 1 pc. Marked as. [amount] into the view, it gives less than. We can see these by activating secondary data source and looking at the dimensions window, the linking dimensions will have an orange chain icon. Hello Jim, Thank You for your reply. Drag the State (group) dimension over the Region dimension on the Rows shelf to replace it. Non-additive aggregates are aggregate functions that produce results that cannot be aggregated along a dimension. Currently, data sources that contain logical tables cannot be used as secondary data sources for data blending. The blend applies to that worksheet only. Hi . This is the final step and will result in filtering between the blended data sources at your desired level of granularity. 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. ×Sorry to interrupt. I am blending dates in the secondary data source to dates from the primary source and looking to get a distinct count of the customer code from the secondary data source. 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. All three options are demonstrated in the attached workbook using the sample data set Superstore. Primary and Secondary Data Sources in Tableau: To perform blending in a Tableau sheet, there should be at least one secondary 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. How to calculate Delta value. All the data is in the secondary/blended data source. Help would be much. 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". 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. 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. I establish the blend relationships explicitly by going to Data -->Edit Blend Relationships, and selecting the fields that should be related. Tableau Desktop 2018. Chicken + Choice of DrinkBurger + Choice of DrinkSpaghetti + Choice of Drink . Data blending is particularly useful when the blend relationship—the linking fields—need to vary on a sheet-by-sheet. 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. Secondary data sources cannot have logical tables (except when they satisfy specific conditions). Here's the data blend view with the secondary data source selected so we can see what blend fields are used:. "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. Thank you . month([date])=month(Parameter. Because there are no linking fields in this view. In data source A, I have COUNTD(Person ID) and in data source B, I have COUNTD(Person ID). Moreover, blending is a kind of left join, not exactly a join. 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. 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. Hi All, I have blended primary and secondary data sources. 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. Any existing, automatic blend kontakte is visible (and pot be deleted by suspend over the row and clicking the x). Filtering data across a worksheet's secondary data source is not currently supported in Tableau Desktop. 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. ×Sorry to interrupt. 3 and I have created aggregates AGG for fields from data extract and excel file. Alternate names:. 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. I tried data blending using the zip codes as a common field but I am facing very slow performance. I am trying to determine the Average Revenue per User by country for which my calculation is total revenue/unique subscribers. The blend applies to that worksheet only. 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". Option 2: Create a calculation for a more dynamic sort. This can help researchers identify. 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. In your case, you're after the Total Cases by Employee, so just imagine Employee in place of Category. Secondary data source has Order Date represented as separate Year and Month fields. Loading. Become a Better Analyst in Just 5 Minutes a Week. I cannot able to use as one connection since am using the data source filter in my first connection have data source filter. Can anybody please help me with a solution. 1) Duplicate the field in primary datasource. Last week I’d promised to explain why the solution for identifying whether All items in a Tableau Quick Filter were selected wouldn’t work under certain circumstances in Tableau version 8, here it. For more information, see Troubleshoot Data Blending; Blended data sources cannot be published as a unit. please check the attached workbook. 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]). However, when I follow your advice, each group splits into 6 rows (one for each month - January through June). Please attach. Fields from the secondary data source used in the view have an orange check mark. "Filtering Across Multiple Data Sources Using a Parameter; Cause A sheet cannot be filtered by a field from a secondary data source. Required cookies are necessary for basic website functionality. The solution. If you create a quick filter on a field from data source 1 and apply this quick filter to. Please see if it helps , here it says that problem is with COUNT & they have provided one alternative way as well . CSS Errorthe message says that a Logical table can not be used as a secondary source - You are trying to blend data (or at least tableau thinks you are) try reverting the data connection to a Physical model to JOIN the files together on the company name - JimThe secondary data source hasn't been changed and the groups work as filters. "Cannot blend the secondary data source because one or more fields use the == function, which cannot be computed locally. Just aggregates (like SUM, MIN, MAX. you will get 5/22 date. Resolution. It also means you cannot create a workbook using the. 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). Status, Stage, etc). Data blending has some limitations regarding non-additive aggregates such as COUNTD, MEDIAN, and RAWSQLAGG. Data blending; Table Calculations; Resolution Use one of the following workarounds: If possible, join instead of blend your data. While on a view, right click a data source, click replace data source. We cannot use ATTR if trying to create an LOD type calculation if blending data sources. Data blending is particularly useful when the blend relationship—the linking fields—need to vary on a sheet-by-sheet. Status, Stage, etc). So, in the dummy data, there are two tables from two data sources. Then try using the LOD expression from a secondary data source. ”. 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. e. Filter each of the data sources independently on the more granular dimensions. 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. Answer. This feature would be really useful to ensure we can. 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. 3. In order to create the waffle chart I am blending it with another datasource using the calculated field defined as [Week 5 (Week5Bond)]. Data from a secondary source is displayed along with the primary source data. Blending requires primary and secondary data sources. 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. 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. Tableau will throw an error: “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. I have been working on Blending feature for a while in different situations and. 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. FIXED ID, WEEK: CountD (accounts)). 3 and I have created aggregates AGG for fields from data extract and excel file. . Identify your data sources for common data types: both data sources must have a string or date field for linking data sources. Good morning @Fred Yu (Customer) . Data blending: Cube data sources can only be used as the primary data source for blending data in Tableau. {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. I'm trying to show a distinct count of claims by branch. 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. data source. In the past, I've just changed my primary table to the one with the calculation. 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. In the Data window, right-click the relevant field. " Filtering Across Multiple Data Sources Using a Parameter; Cause A sheet cannot be filtered by a field from a secondary data source. Since my Workbook is present inside Office premise. This feature would be really useful to ensure we can. For more information, see Use Relationships for Multi-table Data Analysis. T or F: Blends, unlike relationships or joins, never truly combine the data. Few things you need to keep in mind while blending data sources in tableau. I'm blending the 2 data sources by Service_Id. See the attached updated workbook. Call it [Start KM]: IF ATTR ( [KM Date])=ATTR ( [OIL]. 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. And I can't explain why it does that. Primary and Secondary sources in data blending. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. The default view of Data Source canvas is the logical layer in Tableau version 2020. 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 . As 'Group' is from a secondary data source, I cannot simply use the sort buttons. 1. To overcome this, I've added a filter straight into the data source and not in the view. To alias field values. But when I am trying to do that I am getting an errorThe issue comes when I try and add a metric that is an aggregate of the two different sources. The value gets reduced based on filters@@@ from all data source. Expand Post. I am trying to determine the Average Revenue per User by country for which my calculation is total revenue/unique subscribers. The primary data source will be identified automatically from any metrics you put on the worksheet first. Assuming that's what's going on, there's the question of how to work around this. Here are the 7 major steps for putting this together: Set up your primary (main) and secondary (parameter) data sources. The data is blended on customer. 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. SandhyaData from the secondary data source (via a data blend) can never be a dimension. I didn't realize this until now, but it appears you cannot use blending when one of your data sources uses the new(ish) relationship model. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. No. I can add to filters from the data extracts. In the Data pane, select the State data source (secondary). Expand Post. Chicken + Choice of DrinkBurger + Choice of DrinkSpaghetti + Choice of Drink . Functional cookies enhance functions, performance, and services on the website. Because the question is related to how the data sources are being related, it would help to see the real data structure. 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. 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. Please post you twbx workbook so we can see if there a way . 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). [Work Hours]) So you have to make. No long-term contract. ×Sorry to interrupt. Data blending works only as a left join. Overall LOD will show correct result in Primary datasource. This means a data blend can’t be published as a data source for others to use. Filtering data across a worksheet's secondary data source is not currently supported in Tableau Desktop. Community Manager update. since i want only offername from secondary source to the view and the measures are produced from primary datasource is pos_trn. Make sure that you are blending on dimensions present in the view or on. Data blending works like a ___ join. 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. Right-click in the Data window and then. Date dimensions: For cube data sources, date dimensions are typically organized into hierarchies that contain levels such as year,. I have three different data source . How ever # no of changes and # of Problems are calculating entire database values. You combine data in the logical layer using relationships (or noodles). Tableau Desktop; Blended data; Soluzione Use the following workaround: Create a new worksheet. Select Analysis > Create Calculated Field. 2. In a blend, secondary data sources are aggregated and the StoreID dimension would be aggregated to "*". 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. THEN add this total to the SUM of the projected_users from today's date through month X. There's no way to "swap. 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. It has data from 2003-2012. like below . 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. ×Sorry to interrupt. You cannot filter data across secondary data sources. The two data sources are identical. In the secondary (user rights sheet), create a "Verify Username" calculation that has the fmula:. Blending from a polygon-based map to an existing data source which uses 1-to-many joins. Your secondary data source does not have the blend activated, you'll need to click on the link and turn it red to activate:. CSS ErrorCannot blend the secondary data source because one or more fields use an unsupported aggregationFollow this link for more information:the secondary data source always has to be aggregated, there's no way to do a row level check to filter out any dimension members that match between the two data sources. Another table is a a table that contains key fields such as date, region, location and hardware id (dimension). We've adjusted our data strategy accordingly so using joins in all of our workbooks that need to leverage this functionality is not a sustainable solution. Are use of grouped fields not allowed in data blending? I have two data sources: Opportunities and Products. Some of my table calculation are the follow: RED FIELD Tableau Name of First Math Course= IF [Tableau Period of First Math Course]== [Academic Period] AND ( [Subject Desc]=='Mathematics' OR [Subject. If the user select May 2018. As you can see I have 2 different data sources using a blend on the blood type. "Data Sources that contain logical tables cannot be used as secondary data sources for blending". This will be identified with a blue checkmark. xls files). Cannot blend the secondary data source because one or more fields use an unsupported aggregation issue. 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. Upvote Upvoted Remove Upvote Reply. The condition is offer status = hired, but offer status can contain my different response types. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. We have a calculated filed where an aggregation (COUNTD) is done on a filed of secondary data source. (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. Also, after I get the total per PO Number, I want to get a remaining value that subtracts the Total Cost (from the secondary data source) from the Total per PO Number. Use a parameter with a calculated field to filter the secondary data source at the row level. Some examples include: cookies used to. cannot blend aggregated data from the secondary data source with data on this sheet. Currently, I have to rebuild the worksheet and bring in the secondary source first. Option 2: Join tables that are in the same data source, instead of blending them. One on table it was all upper case on the other one it was a mix of upper and lower case. 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. Step 1: Connect to your data and set up. e. drag the secondary measures to measure values section . It says, "fields cannot be used from [data name] data source, because there is no relationship to the primary. A datetime field in the primary data source, for example, will not blend with a date field in the secondary data source. We use three kinds of cookies on our websites: required, functional, and advertising. . To solve your issue you should ->go to Connections 2 , keep only facADP and remove all other relationships ->go to its physical layer (double click facADP)Two Data Sources A and B, one work sheet:W1 has used both this A and B to represent View. I've attached my workbook that contains 2 data sources that are blended by invoice number. I am just trying to filter every Data source, by choosing a field that every Data source has. 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. I am trying to blend the same data against the other because I wanted to show Same Period last Year. 2) Use data source filters instead of the Filters Shelf. You can create a federated database using linked tables/worksheets. 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. I receive this error: "Cannot blend the data source because one or more fields uses an unsupported aggregation". Both fields are linked in worksheet. [% age]>=SUM([Percentage]) . This happens only when the data sources are impala. Currently, data sources that contain logical tables cannot be used as secondary data sources for data blending. General Information. 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. I am getting Cannot blend secondary data source because one or more fields used an unsupported aggregation. Owing to this, only those fields in the secondary data source which bear corresponding matches with the primary data source appear in the visualization pane. the count of claims I'm getting from the secondary data source, by counting distinctly a measure called claimid. It's a technical limitation. In the secondary data source, select Data > Create Calculated Field. Non-additive engine are entirety functions that errichten outcomes that cannot be aggregated along a dimension. "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. ×Sorry to interrupt. Relationships: Join: Combines columns: Yes: Cross database joins will not work with all data sources: Joins: Blend: Combines columns: No: Fields from the secondary data source cannot be brought in to the view unless there is a match on. 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. [tier] == 0 then "Low vendors" elseif max [Secondary]. I can't do a join because they are two different file formats. Input cannot become used from the [name are secondary data source] data source, because there is no blend relationship to the primary data source. See Join your Data for instructions. See Troubleshoot Data Blending - Tableau for more information on this and other errors that may occur while using data blending. It is important to understand which is the primary source, it can impact. When Bugs History is a live connection to Vertica living inside my workbook all is well. But I cant add filter Month from the Budget Excel file. Instead of using relationships, double-click into your table to get to the. IF ATTR([Offer Status]) = "Hired" Then AVG([Comp_File]. If you are blending a cube data source, it must be the primary data source. Advantages: Very easy to write and implement. “Cannot blend the secondary data source because one or more fields use an unsupported aggregation. 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. 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. A datetime field may be converted to a date field using a calculation to remove the time portion. If I cant go the above way then is there a possibility to do the duration calculation using table calculations or some other way. Russell Christopher (Member) 10 years ago. So if you drag Category from the Orders data source, it will automatically mark Orders as the primary data source. The Products set contain the individual products within an Opportunity whereas the Opportunities set contain Sales metrics (i. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. Change the default sort order of the field using the various options, and then click OK. 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. So, basically, I am having issues with 2 calculations - the FIXED LOD and Remaining Value. cannot blend secondary data source because one or more fields use an unsupported aggregation beacuse of LOD. In the data window, the blue tick indicates the Primary data source (Sales in the image below). 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. We use three kinds of cookies on our websites: required, functional, and advertising. Common field is the employee ID. Data blending is used when the linking fields need to vary on a sheet-by-sheet basis for different visualizations. I am getting Cannot blend secondary data source because one or more fields used an unsupported aggregation. 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. 1 because it can cause Tableau to unexpectedly quit. Expand Post. I can get all the fields into the view apart from the 'is vat exempt'. Expand Post. Next, create a table calc using the [Start KM] to calculate the total KMs: from Primary data source from Secondary data source. ” Causes and Workarounds for a Blending Limitation Errors 1. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. 0, but I imagine someone has been able to identify what is causing the issue. LOD will not work if it is from the secondary datasource. In the data window, switch to [name1] data source, and click at least one link icon to blend these 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. Because in Tableau, you don't use COUNTD function when Blending data source. with blends, we are only able to support aggregates (like SUM, MIN, MAX. Hello Ritish, You could use Size() and a Las() function as a filter and get the same output. In this example, Superstore Sales is the primary data source and Coffee Chain is the secondary data source. good morning you have blended your data sources - data from the secondary source always comes to the primary and an aggregate so Budg_date needs to be aggregate with min max or attr but that will probably not give you the result you expect the data from the secondary source will come over as an * if there is more than one date filtered from that. ”. They must be in the same format. " message. [OIL DATE]) THEN MIN ( [KMs]) END. Proj. I get a blank sheet on the dashboard using the secondary data source because it looks for CASE SENSITIVE ABC . I have two data sources to be used but need the count distinct of users from both the data sources. I have 2 data sources, A and B, they are linked by data blending with A. I want to do a basic data listing showing customer, order no, postcode & vat exempt. 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". E make table 2 the primary and table. There is a possibility that the values can be restricted from the secondary data. This is the response I received from Tableau Support:Cause. If this aggregation is ATTR() then the grand totals may be blank. newBranchProjection (Secondary) When I try to add COUNTD([DistrictId]) from my primary to text table. Instead, publish each data. 0 and 7. 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. Data from secondary data sources must always be aggregated in calculations. Hi All, Is there a way to use a parameter to work for secondary data source in blending. IF min([Current Period ]) = true then [Display Sum Media Cost] end / sum(IF [Current Period ] = true then. Data blending provides a way to combine data from more than one data source on a single worksheet. If I cant go the above way then is there a possibility to do the duration calculation using table calculations or some other way. 2) Use this duplicate field in the view instead of the original. LoadingWhen you try to add URL actions to dashboards, fields from secondary data sources cannot be added to the URL. Modify the calculation to not use table functions;. month([date])=month(Parameter.