drag the secondary measures to measure values section . Thanks bharat ! but i think client column is common to both the source so i would able to blend the data. And I can't explain why it does that. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. And I use Join data source, after divide measures / row duplicate. 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 default view that you first see in the Data Source page canvas is the logical layer of the data source. Upvote. Hi . the count of claims I'm getting from the secondary data source, by counting distinctly a measure called claimid. Currently, data sources that contain logical tables cannot be used as secondary data sources for data blending. If you want to filter data across secondary data sources, consider. Option 1: Join the data sources with a cross-database join instead of blending. Hi All, Is there a way to use a parameter to work for secondary data source in blending. ×Sorry to interrupt. Data blending is particularly useful when the blend relationship. We would like to show you a description here but the site won’t allow us. Tableau has two inbuilt data sources named Sample-superstore and Sample coffee chain. IF min([Current Period ]) = true then [Display Sum Media Cost] end / sum(IF [Current Period ] = true then. This type of bases does not allow for blend relationship, therefore, you cannot use a filter like this. Hello Jim, Thank You for your reply. The primary data source is just to filter for the invoices I want to look at. For secondary data source you get same result by managing relationships in your case just Area and Qtr. 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. Excel 1 pc. 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. 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. Remove all dimensions from the secondary data source and ensure that the primary data source’s linking field is in view. please check the attached workbook. If you want to make sure you don't lose any measures from the secondary source then either. 3 and I have created aggregates AGG for fields from data extract and excel file. Viz cannot be filtered with secondary data source filter before loading the visualization so using "[DS_Name]. Resolution. You must double-click a logical table in the Data Source page canvas to go to the physical layer of the canvas. COUNTD is tough to work on while you. Observations : 1. All Answers. gov which displays certain regions in the US (a geometry field is auto created in tableau which allows me to create this map easily), the second data source is a data pull from a data warehouse holding lat/long coordinates of specific points (able to create a point via calculated tableau field using the make point function). It is important to understand which is the primary source, it can impact your view. So, basically, I am having issues with 2 calculations - the FIXED LOD and Remaining Value. But the source calc is a countD. Upvote Upvoted Remove Upvote Reply. 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. 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, in the dummy data, there are two tables from two data sources. You are trying to bring fields from a second data source into a calculation that is being created in the primary (first) data source and aggregations are not consistent - data from the second source comes over as an aggregate - look into what the aggregation is on and how does that relate to what you have in the primary data baseI'm trying to blend two data sources on a single field, say 'Program Description'. Just aggregates (like SUM, MIN, MAX. The solution. The blend is not activated meaning a field from secondary DS is not used 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. We don't get row-level data from secondary sources on a. 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. Here's the data blend view with the secondary data source selected so we can see what blend fields are used:. xls files). 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. 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. 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. Resolution. Data > Edit Relationships . 1. Now, in dashboard D1 : has two worksheets W1 and W2. For more information, see Use Relationships for Multi-table Data Analysis. ×Sorry to interrupt. 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. I use the Opp ID to relate them. I think I need to define the relationship between the data sources. 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. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. mdb which will be used to illustrate data blending. Proj. You cannot filter data across secondary data sources. I establish the blend relationships explicitly by going to Data -->Edit Blend Relationships, and selecting the fields that should be related. The secondary data source need to be my transaction file and primary data source need to be my budget file. {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. Use blends when:. Tableau will throw an error: “Cannot blend the secondary data source because one or more fields use an unsupported aggregation. Common Issue #1: Cannot blend the secondary data source because one or more fields use an unsupported aggregation The aggregation methods of COUNTD, MEDIAN, and other non-additive aggregate functions can cause fields to become invalid. Click oField cannot breathe used from the [name by secondary data source] data original, because there is no mixed relationship to the primary data original. This happens regardless if I drag it on the rows or on the Marks space as a 'text'. This. Are you talking about Tableau Prep or Tableau Desktop? Any chance you can share a sample of your data? Expand Post. Hello Ritish, You could use Size() and a Las() function as a filter and get the same output. 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. If you create a quick filter on a field from data source 1 and apply this quick filter to. I have two datasets; one is a shape file that contains regions and locations. I've blended on user ID. This is indicated by the following icon: The view you are trying to build will function if you use the date from the primary data source (Shipped): Let us know if this is clear, or if more explanation is required! Cheers, TimothyCube data sources are used as primary data sources to blend data in Tableau and cannot be used as secondary data sources. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. 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. Hi All! I would like to ask for your help, I do have two data sources: BI Cube (primary source) & Excel file (secondary) BI Cube Data 1 pc. 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. Left. For example, select Analysis > Create Calculated Field, and in the Formula text box, type the. I have two data sources to be used but need the count distinct of users from both the data sources. * Blend in the summary of a large dataset to reduce query time. I'm blending student data (primary) and staff data (second). Data blending works like a ___ join. Data blending has some limitations regarding non-additive aggregates such as COUNTD, MEDIAN, and RAWSQLAGG. " inner cross database join on BU Code with a data source filter set up on UPPER([ID])=UPPER(USERNAME()) on the DS2 source. Also, in the attached I have added both Calc1 and Calc2 to the tooltip in Sheet 9. cannot blend aggregated data from the secondary data source with data on this sheet. In this source create a calculated field to pull out the KMs on the date of oil change. General Information. 0, but I imagine someone has been able to identify what is causing the issue. In Tableau Desktop, navigate to Data > Edit Relationships. Did some research on this and found plenty of "workarounds" with no success (like replacing COUNTD() with a LoD using AVG(# of Records))Workaround: Option 1: Instead of using Data Blend, please use Relationship to relate the data sources, and the "Only relevant values" option is available to show only existing values. In the data window, the blue tick indicates the Primary data source (Sales in the image below). Expand Post. Resolution. Unknown file type Total from Secondary Data Source. “Cannot blend the secondary data source because one or more fields use an unsupported aggregation. The relationship is on the facility ID. In the secondary data source, select Data > Create Calculated Field. "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. Use a parameter with a calculated field to filter the secondary data source at the row level. CSS ErrorData blending is based on two key components- Primary data sources and Secondary data sources. "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. Instead, we need to publish the two data sources separately on the same server and then. e. ” We use three kinds of cookies on our websites: required,. A data blend cannot filter on dimensions that do not exist in the Primary data source. To fix this, we had to add the fields being used in the blending relationship onto the view: Aside from a few of these, we didn’t need to combine the data in very complicated ways. 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. It says, "fields cannot be used from [data name] data source, because there is no relationship to the primary. Hi Justin, Thanks for your quick reply. 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. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. ×Sorry to interrupt. 3) COUNTD with Secondary DS (Blending) Thanks,. They must be in the same format. Blended data sources. The secondary data source will have an orange checkmark on it. In the secondary (user rights sheet), create a "Verify Username" calculation that has the fmula:. "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. All the data is in the secondary/blended data source. If this aggregation is ATTR() then the grand totals may be blank. . In your 2nd and 3rd data sources. All customer IDs are under a dimension called "Global ID". The data is blended on customer. Try one of the following options, as appropriate for your workbook: It may be possible to cross database join instead of blending. I am getting Cannot blend secondary data source because one or more fields used an unsupported aggregation. For example, COUNTD(). Fields from the secondary data source used in the view have an orange check mark. Credits to Jonathan Drummey for the below workaround Cannot blend the secondary data source because one or more fields use an unsupported aggregation . In the attached file, table shows the sum of sales and first order date correctly from both the. Non-additive aggregates are aggregate functions that produce results that cannot be aggregated along a dimension. While using blending data source some of the function doesn't perform well in calculation like COUNTD(), LOD{}, MEDIAN() etc. It's a technical limitation. ) If only one of the tables requires row level information, consider making that the primary data source in the blend (I. 1. Build whatever calculated fields from the secondary that need to be used in in the primary. There's a set of views/calcs that show a metric, (metric C) counting distinct number of accounts contacted per person per week (e. How to rewrite my calculation to fix the error: cannot blend the secondary data source because one or more fields are use and unsupported aggregation. For example, sheet A uses data source 1 as the primary data source; sheet B uses data source 1 as the secondary data source. Data source A has Role Column and Data source B also has Role Column. 4, I tried to blend products (secondary) to storefront (primary) based on Sku. This functionality was available in versions 8. Common field is the employee ID. When you data changes, you need to redo the. However, I still get that message saying cannot blend the secondary data source because one or more fields use an unsupported aggregation". I have a calculated field in the Excel data source that returns a binary 1 if the username matches the list in Excel for the facility ID and a 0. I ended up purchasing an Alteryx license for our company (we now have a lot. 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. See. Seemingly simple task is getting complicated in Tableau . e. 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). However, if you do a full outer join on [Dimension] = [Dimension] then we can know which records match up, and do a calculation like:I like to have the ability to swap a primary data source with a secondary data source for data blending in a workbook. Another table is a a table that contains key fields such as date, region, location and hardware id (dimension). According to Tableau, this error can also appear when using a LOD expression in a blended view. 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. Expand Post. the branch field I'm using from the primary data source. [Work Hours]) So you have to make. I am trying to use the below formula instead of countd function because my data comes from Impala {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 out my sheet i. It throws me cannot blend secondary data source one or more becuase one or more fields use unsupported aggregation . Cannot blend the secondary data source because one or more fields use the == function, which cannot be computed locally. I have a primary data source coming from a published data extract blending with a secondary data source coming from an Oracle Database. 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. Currently, I have to rebuild the worksheet and bring in the secondary source first. Answer. Jim. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. Data blending is a method for combining data from multiple sources. 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. 3 and I have created aggregates AGG for fields from data extract and excel file. For example, sheet A uses data source 1 as the primary data source; sheet B uses data source 1 as the secondary data source. ×Sorry to interrupt. Error: Cannot blend the secondary data source because one or more fields use an unsupported aggregation I have a primary data source coming from a published data extract blending with a secondary data source coming from an Oracle Database. you get all data from main data source and ONLY matching data from secondary data source. 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. 1. This feature would be really useful to ensure we can. You can use data blending when you have data in separate data sources that you want to analyze together on a single sheet. A datetime field in the primary data source, for example, will not blend with a date field in the secondary data source. "Cannot blend the secondary data source because one or more fields use the / function, which cannot be computed locally. Filtering data across a worksheet's secondary data source is not currently supported in Tableau Desktop. Cube data sources can be used only as a primary data source to blend data in Tableau, and cannot be used as secondary data sources. 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. I am just trying to filter every Data source, by choosing a field that every Data source has. 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. How do I blend these data sources by year? - The Tableau Community. Then try using the LOD expression from a secondary data source. In the secondary data source, select Data > Create Calculated Field. You can choose whether functional and advertising cookies apply. When you blend, you can only have aggregate access to the rows in the secondary. Upvote. Does anyone have any Ideas how I can apply a universal filter. Think of this layer as the Relationships canvas in the Data Source page. Final Words. [amount] into the view, it gives less than. No. So if you drag Category from the Orders data source, it will automatically mark Orders as the primary data source. Maxdate) There is one more way, make the datasource which is using the fixed calculation to primary data source. Data source filters. Moreover, blending is a kind of left join, not exactly a join. 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. Data & Connectivity. Cannot blend the secondary data source since one or more search use certain unsupported aggregation. The date values must be in the same format. Data blending is used when the linking fields need to vary on a sheet-by-sheet basis for different visualizations. - Dataset 1, records the amount spent on ads as "Cost". Become a Better Analyst in Just 5 Minutes a Week. Place Organisation Identifier on the level of detail shelf (from the primary source, or both sources) and the blend should work. I was now trying to use both calculations you did on a different sheet through data blending. 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. " Filtering Across Multiple Data Sources Using a Parameter; Cause A sheet cannot be filtered by a field from a secondary data source. CSS ErrorHi Mavis Liu. Hi. Data blending is a method for combining data from multiple sources. They cannot be used as secondary data sources. Data of any sort coming from a secondary source must come as an aggregate of some sort. If you have to have row-level access on a. The date values must be in the same format. 2 and later. You can choose whether functional and advertising cookies apply. . Both Primary and Secondary data sources have duplicate rows due to multiple joins in data prep. Instead, publish. Solution in the image 📌 Non-additive aggregates from the primary data source 📌 Non-additive aggregates from the secondary data source 📌 Non-additive aggregates from a multi-connection. ×Sorry to interrupt. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. e. It sounds like there might be some complications with a blend? Can’t speak to what’s happening there Are you blending on [Endtimestamp]? By using the formula DAY([Endtimestamp]), you're changing the dimensionality a little bit. 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. I'm blending the 2 data sources by Service_Id. 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. 2)Count Distinct from Secondary workaround. g. Relationships cannot be formed between tables from data sources published to Tableau Server or Tableau Online. Also I see that if you put [Corrected Date] from the primary source instead of the secondary source, it behaves with the group (and the calc. 3. 💥Check my Website💥 Troubleshoot Data Blending in Tableau Part 2 here SHOP After you have used the secondary data source to provide aliases for the primary data source, you no longer need the secondary data source and can close it. This field works but when I want to add in my Fianl Dashboard I have this message "Cannot blend the secondary data source because one or more fields use an unsupported aggregation" Moreover my first and secondart data sources are linked by the "Sales ID", but this field is not displayed in the final Dashboard. Aside from consulting the primary origin or source, data can also be collected through a third party, a process common with secondary data. Cannot blend the secondary data source because one or more 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 . But seems we cannot blend 2 secondary data source with same field. 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. In your case, you're after the Total Cases by Employee, so just imagine Employee in place of Category. Therefore it cannot display null data. The data source with the KMs is the primary source. In the Add/Edit Field Mapping dialog box, select the date fields from the primary and secondary data sources, and then click OK twice. Data blending is particularly useful when the blend relationship—the linking fields—need to vary on a sheet-by-sheet. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. My goal is to show CY Actuals as bars, with a line for PY Actuals and a line for Budget. The default view of Data Source canvas is the logical layer in Tableau version 2020. According to Tableau, this error can also appear when using a LOD expression in a blended view. Primary Source: Payment details (to get customer ID and revenue) Secondary Source: Customer details (to get customer country) from this data source i get the sum of basic salary. Instead, publish each data. 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 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. But I cant add filter Month from the Budget Excel file. Whichever data source you "use first" in a view (by dragging in a field) becomes Primary. Primary Data Source: Contains a list of all employees and their role. Sometimes , it's automatically working but sometimes it says 'Unsupported Aggregation' . IF ATTR([Offer Status]) = "Hired" Then AVG([Comp_File]. Regards. , 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. All data from a secondary source comes back as an aggregate -- even if there is only one value from the secondary source. So, to do Data Blending, the steps that I would suggest would be: - Connect to the data sources that you need to use. Instead, the. This can help researchers identify. duplicate the date field. . Step 2: Make it a context filter. For example, when I try and pull in Cost per Order (cost coming from one source, and Orders coming from another) I get the "Cannot blend the secondary data source because one or more fields use and unsupported aggregation. When blending in Tableau, there is always a primary source and a secondary data source. Expand Post. Change the default sort order of the field using the various options, and then click OK. Loading. 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. In data source A, I have COUNTD(Person ID) and in data source B, I have COUNTD(Person ID). I am using tableau 2020. The value gets reduced based on filters@@@ from all data source. (It is a field that contains account names (company) in the sample data. Secondary data sources cannot have logical tables (except when they satisfy specific conditions). ). I have been working on Blending feature for a while in different situations and. This means a data blend can’t be published as a data source for others to use. "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 sources. Community Manager update. Please see if it helps , here it says that problem is with COUNT & they have provided one alternative way as well . Unfortunately can't share the data, and can't come up with a mock cause I can't figure out what's not/is working as expected. This will be identified with a blue checkmark. FIXED requires that you have row-level access to the rows in the secondary 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. I. 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. Tableau Desktop; Blended data; Soluzione Use the following workaround: Create a new worksheet. A secondary data source can be used to re-alias the field values in a primary data source. Some of the function doesn't work properly when we use blending like COUNTD(), LOD{} expression. 0 but was disabled (greyed out) in 8. Chicken + Choice of DrinkBurger + Choice of DrinkSpaghetti + Choice of Drink . order_date. Select Analysis > Create Calculated Field. Filter each of the data sources independently on the more granular dimensions. Effective visualization. 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. This didn't work alas, "cannot blend secondary data source because one or more fields use an unsupported aggregation" I am using a filter from a different datasource to filter by region . You can choose whether functional and advertising cookies apply. Any help would be appreciated!Also a data blend is only a LEFT join. I am trying to use the below formula instead of countd function because my data comes from Impala. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. 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). You can read details here: Logical Tables in Secondary data source. Then you can simply show one filter control on your dashboard and set it to apply to all related data sources. Data blend is like a Left outer join. 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". 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 . Hello Tableau world!! Am running into the strangest problem when data blending with V8. cannot blend aggregated data from secondary data source. Resolution. ) If only one of the tables requires row level information, consider making that the primary data source in the blend (I. 4. For more information, see Use Relationships for Multi-table Data Analysis. 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". 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. Marked as. 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. ×Sorry to interrupt. We cannot use ATTR if trying to create an LOD type calculation if blending data sources. "Cannot blend the secondary data source because one or more fields use the == function, which cannot be computed locally. This feature would be really useful to ensure we can. month([date])=month(Parameter. 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. Call it [Start KM]: IF ATTR ( [KM Date])=ATTR ( [OIL]. Now we have to use W2 as Filter - to filter out the data. In the Add/Edit User Mapping dialog crate, do the following: Select a select by the primary your data. If you make sheet 1 as the primary data source and do the data blending with sheet 2. Hi Kurt! No, not really. Tableau Desktop 2018.