Nitish Pamarty (Member) 7 years ago. CustomOverall (Primary) 2. 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. Upvote Upvoted Remove Upvote Reply. Maxdate) There is one more way, make the datasource which is using the fixed calculation to primary data source. Thanks for your help everyone! I've found what was happening: I had some filters on the secondary data source. I have two data sources which I have blended together on two fields: branch and date. Russell Christopher (Member) 10 years ago. Modify the calculation to not use table functions;. I am getting Cannot blend secondary data source because one or more fields used an unsupported aggregation. I'm blending the 2 data sources by Service_Id. tds and . 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. They both share a common field (State), and that is what I'm filtering on. Date dimensions: For cube data sources, date dimensions are typically organized into hierarchies that contain levels such as year,. Hi, I have a scenario where I have to use Data Blending option to get certain metric values from Secondary Data Source. In this case the cross. Hi, Because we can't see the entire picture, no detail in the view of the connected data sources, the workbook, etc. Instead, publish each data. the count of claims I'm getting from the secondary data source, by counting distinctly a measure called claimid. Place Organisation Identifier on the level of detail shelf (from the primary source, or both sources) and the blend should work. For more information, see Troubleshoot Data Blending; Blended data sources cannot be published as a unit. "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. Community Manager update. Marked as. 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. A datetime field in the primary data source, for example, will not blend with a date field in the secondary data source. You want to apply a filter to related data sources - which is an option if multiple data sources have a field with the same name and data type, or if you define explicit relationships between data sources from the Data menu. To blend on summary data, you can do the following: Create a. The data is blended on customer. We would like to show you a description here but the site won’t allow us. Option 2: Create a calculation for a more dynamic sort. ) If only one of the tables requires row level information, consider making that the primary data source in the blend (I. Select Analysis > Create Calculated Field. You have a nice example to use for filing a support case, and I recommend that you do that. Are use of grouped fields not allowed in data blending? I have two data sources: Opportunities and Products. 2. "Data Sources that contain logical tables cannot be used as secondary data sources for blending". Applies to: Tableau Cloud, Tableau Desktop, Tableau Server Data blending is a method for combining data from multiple sources. {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. You can choose whether functional and advertising cookies apply. 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. I've created the first chart with no problem, but I. If you create a quick filter on a field from data source 1 and apply this quick filter to. I get a blank sheet on the dashboard using the secondary data source because it looks for CASE SENSITIVE ABC . 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. order_date. ”. Error: "data sources that contain logical tables cannot be used as secondary data sources for blending" I have two fact based data marts that I want to blend on a combination of dimensions (product, month, currency). In the secondary data I have a LOD field called Total_Category_Response defined as { FIXED [Category]: SUM([Respose_ValI am working on a dashboard where I am using the data blending feature to visualize the data from different data sources in to a single view. This happens only when the data sources are impala. the branch field I'm using from the primary data 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. 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. Tableau Desktop & Web Authoring. 1. Jim. Now try to recreate the sheet and link the 2nd and 3rd data. Good morning . Tableau v8 added a new style of data blending (DB2) where the linking field does not have to be in the view. e. From my primary data source I have a dimension in columns say 'Customer Segment'. In the Data pane, switch until the [name of subsidiary datas source] data root, and click at least one link icon to blend these datas sourcing. 0, but I imagine someone has been able to identify what is causing the issue. 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. 3 and I have created aggregates AGG for fields from data extract and excel file. Loading. Currently, data sources that contain logical tables cannot be used as secondary data sources for data blending. While on a view, right click a data source, click replace data source. 1) Vizible Difference: Getting around Count Distinct in a secondary data source. And I want to add one of the field from secondary dataset to be in the filter. 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". I am getting Cannot blend secondary data source because one or more fields used an unsupported aggregation. The default view that you first see in the Data Source page canvas is the logical layer of the data source. The primary data source will be identified automatically from any metrics you put on the worksheet first. I have just realised why the blending was not working. Select Custom in the relationships list, and then get Attach. Right-click in the Data window and then. Hi All, Is there a way to use a parameter to work for secondary data source in blending. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. The value gets reduced based on filters@@@ from all data source. Hi . Loading. There's no way to "swap. Aggregate the date fields at the MY. I am creating a couple of formulas to display the total booking from the second data source to the first data source. 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. 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. I'm using a cube data source as my primary and am attempting to blend with. you get all data from main data source and ONLY matching data from secondary data source. " Expand Post. I get error: “Cannot blend the secondary data source because one or more fields use an unsupported aggregation. So you don't get in the case of data blending. Instead, publish each data source separately (to the same server) and then blend the published data sources. Excel . 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. You can create a federated database using linked tables/worksheets. Since my Workbook is present inside Office premise. LOD will not work if it is from the secondary datasource. We cannot use ATTR if trying to create an LOD type calculation if blending data sources. 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. For more information, see Troubleshoot Data Blending; Blended data sources cannot be published as a unit. In the data window, switch to [name1] data source, and click at least one link icon to blend these data sources. "Cannot blend the secondary data source because one or more fields use the / function, which cannot be computed locally. 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. That's probably your problem. Expand Post. Fields cannot be used from the [name of secondary data source] data source, because there is no blend relationship to the primary data source. Both Primary and Secondary data sources have duplicate rows due to multiple joins in data prep. Open. There are a few possibilities: 1) Flip the blend so the primary is secondary and vice versa. I tried data blending keeping File C as primary and A & B as secondary data source with DD number as relationship. I have two data sets that are linked across Date and Product Category fields. newBranchProjection (Secondary) When I try to add COUNTD([DistrictId]) from my primary to text table. Because the question is related to how the data sources are being related, it would help to see the real data structure. A secondary data source can be used to re-alias the field values in a primary data source. Expand Post. Case 1: If you are facing this issue before report is been developed then try to use data source filter to limit the data flow and finish the development. Hello Tableau world!! Am running into the strangest problem when data blending with V8. (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. Upvote Upvoted Remove Upvote Reply. g. Here is an example of what I am trying to accomplish:Data blending is a method for combining data from multiple sources. I have two data sources and I have blended them together. Resolution. E make table 2 the primary. 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. The condition is offer status = hired, but offer status can contain my different response types. Cube data sources do not support pass-through connections. All Answers. General Information. The default view of Data Source canvas is the logical layer in Tableau version 2020. How to calculate Delta value. CustomOverall (Primary) 2. Before I check Date filters, I got this results. 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. In data blending, there is a primary data source and a secondary data source. Data blending is a method for combining data from multiple sources. Good morning @Fred Yu (Customer) . Give the action a sensible name and configure the action. In my primary, I define another calculated field to do the aggregation for each project by tier: VendorClass: if max [Secondary]. Relationships cannot be formed between tables from data sources published to Tableau Server or Tableau Online. The reason of the errors being unsupported calculation in blend. This feature would be really useful to ensure we can. Make the field(s) used to address the table calculation active linking fields. [OIL DATE]) THEN MIN ( [KMs]) END. I noticed there was an issue using Data Blend from 3 different source. No. Fixed, countd functions won't work with the secondary datasources. I am using tableau 2020. Option 2: Join tables that are in the same data source, instead of blending them. This functionality was available in versions 8. Additional Information While replacing ATTR() with MIN() will cause "Automatic" grand totals to show, the grand totals might not be the expected values. I am trying to use the below formula instead of countd function because my data comes from Impala. 1. ×Sorry to interrupt. 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. I can't do a join because they are two different file formats. When Bugs History is a live connection to Vertica living inside my workbook all is well. COUNTD is tough to work on while you. Data blending is particularly useful when the blend relationship—the linking fields—need to vary on a sheet-by-sheet. Another way to approach this is to do a join of the data outside Tableau via a federated data source. I can add to filters from the data extracts. If you want to make sure you don't lose any measures from the secondary source then either. ” Causes and Workarounds for a Blending Limitation Errors 1. This happens regardless if I drag it on the rows or on the Marks space as a 'text'. I am using blending and created Relationship but i am having problem in terms of getting distinct count from one of the data sources. Cube (multidimensional) data sources have certain characteristics that make them unique in Tableau. In the actual data I get the error: Cannot blend the secondary data source because one or more fields use an unsupported aggregation. I've attached my workbook that contains 2 data sources that are blended by invoice number. Drag the State (group) dimension over the Region dimension on the Rows shelf to replace it. you are blending the 2 excel data sources - blending takes place after the structure for data table for the worksheet has been established - and that is done as you bring dimensions to the rows and columns and apply filters to those dimensions - you will not be able to filter across data sources except at the link after that point💡 Ability to switch primary and secondary data sources. When I do the join between the SSAS Tabular Model (primary data. In this example, Superstore Sales is the primary data source and Coffee Chain is the secondary data source. 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. Change the default sort order of the field using the various options, and then click OK. Any existing, automatic blend kontakte is visible (and pot be deleted by suspend over the row and clicking the x). Ambiente. I can get all the fields into the view apart from the 'is vat exempt'. Option 1: Join the data sources with a cross-database join instead of blending. I get error: “Cannot blend the secondary data source because one or more fields use an unsupported aggregation. png - Ben-Sullins's library "Cannot blend the secondary data source because one or more fields use an unsupported. I am trying to blend the same data against the other because I wanted to show Same Period last Year. Fee". 4. We use three kinds of cookies on our websites: required, functional, and advertising. E make table 2 the primary and table. The Products set contain the individual products within an Opportunity whereas the Opportunities set contain Sales metrics (i. 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. 2) Use data source filters instead of the Filters Shelf. Tableau will throw an error: “Cannot blend the secondary data source because one or more fields use an unsupported aggregation. Secondary Data Source: Contains data relating to the usage of a website (hits). Now we have to use W2 as Filter - to filter out the data. 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. ×Sorry to interrupt. 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. It throws me cannot blend secondary data source one or more becuase one or more fields use unsupported aggregation . We use three kinds of cookies on our websites: required, functional, and advertising. Currently, I have to rebuild the worksheet and bring in the secondary source first. 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. In this source create a calculated field to pull out the KMs on the date of oil change. 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. 3) COUNTD with Secondary DS (Blending) Thanks,. Loading. I noticed that when the spatial file is the secondary data source, I cannot area plot it by double clicking the geometry variable. 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. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. . ) So the issue is really the introduction of the group on the sheet. I am confused, as I am not even trying to blend Data from both Data Sources. 1) Duplicate the field in primary datasource. 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. I am trying to use the measures name filter functionality with two data sources. I can add to filters from the data extracts. Drag the 2016 Population measure to the Columns. Your secondary data source does not have the blend activated, you'll need to click on the link and turn it red to activate:. Upvote Upvoted Remove Upvote Reply. For more information, see Deciding Between Joining Tables and Blending Data. This means a data blend can’t be published as a data source for others to use. In versions prior to 2020. In second data source i don;t have salesrep column. Data blending is particularly useful when the blend relationship—the linking fields—need to vary on a sheet-by-sheet. We use three kinds of cookies on our websites: required, functional, and advertising. Summary:. Then you can simply show one filter control on your dashboard and set it to apply to all related data sources. [OIL DATE]) THEN MIN ( [KMs]) END. To provide comparative data: Secondary data can be used to compare and contrast findings across different studies or datasets. If this aggregation is ATTR() then the grand totals may be blank. I've blended on user ID. Loading. Next, create a table calc using the [Start KM] to calculate the total KMs: from Primary data source from Secondary data source. please check the attached workbook. This can help researchers identify. Help would be much. I'm trying to show a distinct count of claims by branch. 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]). Fields cannot be used from the [name of secondary data source] data source, because there is no blend relationship to the primary data source. ” Causes and Workarounds for a Blending Limitation Errors. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. 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. CSS ErrorLoading. Here's the data blend view with the secondary data source selected so we can see what blend fields are used:. The data in the primary data source is the main data on which Tableau defines graphs and charts. I am trying to determine the Average Revenue per User by country for which my calculation is total revenue/unique subscribers. Use blends when:. However when I use B as primary data source, drag [A]. "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. ×Sorry to interrupt. Loading. If you have to have row-level access on a. the branch field I'm using from the primary data source. The date values must be in the same format. if you have blended data sources you can not use lods One of the drawbacks of blended sources . The blend is not activated meaning a field from secondary DS is not used in the view. Yes - you can't bring COUNTD in data blending. While on a view, right click a data source, click replace data source. 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. One on table it was all upper case on the other one it was a mix of upper and lower case. AUMTable (Secondary) 3. The problem I'm running into is when I use another data source as the primary source and attempt to bring over the LOD calculation from a secondary source. The aggregation is all on primary source 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. with blends, we are only able to support aggregates (like SUM, MIN, MAX. I ended up purchasing an Alteryx license for our company (we now have a lot. You must double-click a logical table in the Data Source page canvas to go to the physical layer of the canvas. Make sure that you are blending on dimensions present in the view or on. Pick the secondary data source in of Secondary data source pane. Data sources can contain logical tables not be used as secondary data sources for data blending. [% age]>=SUM([Percentage]) . Hi Justin, Thanks for your quick reply. This means that when a cube data source is published, you cannot make a connection from Tableau Server using the data source. 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". Secondary data is one of the two main types of data, where the second type is the. A Level of Detail (LOD) expression is being taken from the secondary data source. So if you drag Category from the Orders data source, it will automatically mark Orders as the primary data source. The version I am working with 10. ×Sorry to interrupt. i. As you can see I have 2 different data sources using a blend on the blood type. 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. 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. How to tackle “Cannot blend the secondary data source because one or more fields use an… How to tackle “Cannot blend the secondary data source because one or more fields use an unsupported aggregation” while blending Multiple data sources. For more information, see Troubleshoot Data Blending; Blended data sources cannot be published as a unit. , 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. Data blending is a method for combining data from multiple sources. 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. Required cookies are necessary for basic website functionality. 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. But I cant add filter Month from the Budget Excel file. 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. I read that this is not possible. LOD Expressions will not be shown in the Data Source; When referencing a dimensionality declaration parameter, always use the parameter name and not the parameter value; With data blending, the primary data source's linking field must be in the view before you can use a LOD expression from the secondary data source. LOD will not work if it is from the secondary datasource. The relationship is on the facility ID. Option 2: Create a calculation using WINDOW_SUM() Drag the linking field(s) from the secondary data source to. " And after that I can't make my workbook work at all. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. I am trying using { FIXED : SUM[(portfolioValue)]}. [tier] == 0 then "Low vendors" elseif max [Secondary]. Build whatever calculated fields from the secondary that need to be used in in the primary. Some of the function doesn't work properly when we use blending like COUNTD(), LOD{} expression. Step 3: Blend the fields with the target data source using simple blending method (clicking those broken links into red)Hi Saukarsha, The linking fields need to be somewhere on the view in order for the blend to work. In the attached file, table shows the sum of sales and first order date correctly from both the. I made a waffle chart grid using an excel data source that contains 3 fields: Rows, Columns and Percentage. CSS ErrorTo reduce query times when working with a large data source like Store - South, you can use data blending to blend only on the summary data of the large secondary data source (Store - South) with the data in the smaller and presumably faster primary data source (Store - North). Maxdate) There is one more way, make the datasource which is using the fixed calculation to. IF ATTR([Offer Status]) = "Hired" Then AVG([Comp_File]. In the secondary data source, select Data > Create Calculated Field. This feature would be really useful to ensure we can. 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. In addition, you cannot blend Measure Values from a secondary data-source, so that rules out this approach as well. Expand Post. It also means you cannot create a workbook using the. AUMTable (Secondary) 3. on Rows, Columns, Pages, or the Marks Card. However, when I follow your advice, each group splits into 6 rows (one for each month - January through June). In your case, you're after the Total Cases by Employee, so just imagine Employee in place of Category. 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. If you create a quick filter on a field from data source 1 and apply this. The secondary data source need to be my transaction file and primary data source need to be my budget file. Thank you . Upvote. 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. 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". Status, Stage, etc). See Join Your Data for more information. We can see these by activating secondary data source and looking at the dimensions window, the linking dimensions will have an orange chain icon. Calculates the number of distinct values of a field within a partition. Hi . The data source with the KMs is the primary source. 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 . You can also define the relationship manually by right-clicking on the data source name in the Data pane, and selecting Relationships. Filtering data across a worksheet's secondary data source is not currently supported in Tableau Desktop. - Data to Map from - Data to Map to . This is one of the disadvantages of data blending in Tableau. I have three different data source . Hello Jim, Thank You for your reply. Upvote Upvoted Remove Upvote Reply. Limitations of Data Blending in Tableau. The blend applies to that worksheet only. 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). Cannot blend the secondary data source because one or more fields use an unsupported aggregation. Data source filters. you will get 5/22 date. 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. 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". Proj. I receive this error: "Cannot blend the data source because one or more fields uses an unsupported aggregation". “Cannot blend the secondary data source because one or more fields use an unsupported aggregation. 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. In your workbook sheet2 does not contain 5/22 date. The problem is when I try to calculate the median of that same measure. CSS ErrorIF user chooses month X and parameters/filters like gender/age/etc, THEN count all distinct users from data set #2 where the date of data set #2 is from 2017-08-01 through today's date. They cannot be used as secondary data sources. If I cant go the above way then is there a possibility to do the duration calculation using table calculations or some other way. Current Year Actuals and Prior Year Actuals are housed in a corporate transnational data source. I am trying to create a waffle chart. The unsupported aggregation happens when your aggregate requires row-level visibility to the secondary data source. Select Default Properties > Sort. The order in which fields are used determines which data source is the primary versus the secondary data source. ×Sorry to interrupt. The date values you want to blend on must exist in both data sources. Tableau Desktop 2018. Cannot blend the secondary data source since one or more search use certain unsupported aggregation. 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. But I cannot for the life of me comprehend why the data blending would behave differently based solely on the chart type that was selected. You will need a common column between the two tables in order to blend. 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 trying to use the below formula instead of countd function because my data comes from Impala. CSS ErrorAfter Blending, Now it is showing this error: Cannot blend the secondary data source because one or more fields use an unsupported aggregation. 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.