For more information, see Use Relationships for Multi-table Data Analysis. 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. ” We use three kinds of cookies on our websites: required,. Excel 1 pc. 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". Resolution. 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. Filter not recognizing blend relationship. Marked as. Resolution. Output - End output which I need is a table with a single row data for each country with 3 columns Country name, Total Count of DD, Total Cost for DD. Now, in dashboard D1 : has two worksheets W1 and W2. When I create an additional calculated field in the primary data source with: COUNTD(Person ID) + COUNTD(Person ID), I receive the cannot blend the secondary data source because. I receive this error: "Cannot blend the data source because one or more fields uses an unsupported aggregation". ” Causes and Workarounds for a Blending Limitation Errors 1. I am trying to use the measures name filter functionality with two data sources. Hi . You can choose whether functional and advertising cookies apply. Hi, Because we can't see the entire picture, no detail in the view of the connected data sources, the workbook, etc. While on a view, right click a data source, click replace data source. 2. Create a “Blend Field” with a value of 1 in both your primary and secondary. Expand Post. Data blending is a method for combining data from multiple sources. Please see if it helps , here it says that problem is with COUNT & they have provided one alternative way as well . 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 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". LoadingWhen you try to add URL actions to dashboards, fields from secondary data sources cannot be added to the URL. id, A. I am getting Cannot blend secondary data source because one or more fields used an unsupported aggregation. Here's the data blend view with the secondary data source selected so we can see what blend fields are used:. This is interesting. Chicken + Choice of DrinkBurger + Choice of DrinkSpaghetti + Choice of Drink . month([date])=month(Parameter. 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. The solution. Just aggregates (like SUM, MIN, MAX. Moreover, blending is a kind of left join, not exactly a join. Data blend is like a Left outer join. Make the field(s) used to address the table calculation active linking fields. Data blending is particularly useful when the blend relationship. If you create a quick filter on a field from data source 1 and apply this quick filter to. 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 get error: “Cannot blend the secondary data source because one or more fields use an unsupported aggregation. Call it [Start KM]: IF ATTR ( [KM Date])=ATTR ( [OIL]. 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. 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. Primary and Secondary sources in data blending. e. Tableau has two inbuilt data sources named Sample-superstore and Sample coffee chain. Cube (multidimensional) data sources have certain characteristics that make them unique in Tableau. Thanks. Mihai Constantinescu (Member) 6 years ago. Then you can simply show one filter control on your dashboard and set it to apply to all related data sources. the count of claims I'm getting from the secondary data source, by counting distinctly a measure called claimid. AUMTable (Secondary) 3. From my primary data source I have a dimension in columns say 'Customer Segment'. I have quick filters from the primary data source and I am trying to represent distinct. The. Data coming from a secondary source is ALWAYS aggregated at the level of the link - even if there is 'no need to add anything' that's just the way blending works - it happens after the data table dimensions are set and you are loading values into the data table for the individual worksheet additionally, data coming from the secondary source are always aggregated at the level of the link when brought to the primary source - the individual records are no longer available and you are not able to filter across the various data sources at that point - that is the long way of saying you will have to join or use a relationship - not. The primary data source will be identified automatically from any metrics you put on the worksheet first. Whichever data source you "use first" in a view (by dragging in a field) becomes Primary. 3. 3. As we know the link cant be established unless we use this common dimension (Region Filter) in the view, we can mimic the view by adding the Region Filter Dimension to rows/Columns shelf and uncheck the show header. Instead, publish each data source separately (to the same server) and then blend the published data sources. In the secondary data source, select Data > Create Calculated Field. 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. Any existing, automatic blend kontakte is visible (and pot be deleted by suspend over the row and clicking the x). Modify the calculation to not use table functions;. We would like to show you a description here but the site won’t allow us. To provide comparative data: Secondary data can be used to compare and contrast findings across different studies or datasets. In blending data source, I try to slove problem but I can't. Instead, we need to publish the two data sources separately on the same server and then. with blends, we are only able to support aggregates (like SUM, MIN, MAX. 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. the branch field I'm using from the primary data source. However, when the linking dimension is not in the view, non-additive aLoading. In addition, you cannot blend Measure Values from a secondary data-source, so that rules out this approach as well. 2) DB2 blending doesn't support non-additive aggregates like COUNTD() from secondary sources. I am trying to use the below formula instead of countd function because my data comes from Impala. Please post you twbx workbook so we can see if there a way . 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. 0, but I imagine someone has been able to identify what is causing the issue. 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. 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". In second data source i don;t have salesrep column. IF min([Current Period ]) = true then [Display Sum Media Cost] end / sum(IF [Current Period ] = true then. Upvote Upvoted Remove Upvote Reply. mdb which will be used to illustrate data blending. 3) Select the now grey link next to the original field in. All Answers. Option 1: Include all linking fields in the view, and aggregate secondary fields Data blending will work when the secondary data source uses logical tables, as long. Reference line -----> in this approach able to show sub-category items measures like sales and quantity totals as reference lines shown in below figure . Please attach. 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. Hi Andy, Following up on this - Tableau has been promoting the jump to relationships, in place of joins. 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. 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. Regards. I get around it by adding "max" in front of the first one again, and it says calculation is valid, but once I try to add it to the view it gives the error "Cannot blend the secondary data. Thank you . cannot blend aggregated data from secondary data source. Ken Flerlage (Member) 5 years ago. 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. 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. 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. T or F: Blends, unlike relationships or joins, never truly combine the data. I ended up purchasing an Alteryx license for our company (we now have a lot. when I use A as primary data source and drag A. 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. Remove all dimensions from the secondary data source and ensure that the primary data source’s linking field is in view. Cannot Blend Secondary Data Source - Unsupported Aggregation. The blend applies to that worksheet only. Cannot blend the secondary data source because one or more fields use an unsupported aggregation issue. I have a Remaining Value calculation, but it is not correct. If you have to have row-level access on a. Dominic Laird(Member) 5 years ago. 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. Upvote. 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. Data blending is a method for combining data from multiple sources. Data blending is a good option when you have multiple data sources that cannot be combined through relationships. Both fields are linked in worksheet. As 'Group' is from a secondary data source, I cannot simply use the sort buttons. This functionality was available in versions 8. In your case, you're after the Total Cases by Employee, so just imagine Employee in place of Category. I have 2 data sources, A and B, they are linked by data blending with A. Data source filters. Process for Creating the Dynamic “Parameter”. 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. This happens only when the data sources are impala. Because there are no linking fields in this view. Size() is a great choice for unique counts across data sources if you can create a view where every unique row is displayed. Cannot blend the secondary data source because one or more fields use an unsupported aggregation . Cannot blend the secondary data source because one or more fields use an unsupported aggregation. This feature would be really useful to ensure we can. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. Select Default Properties > Sort. Secondary Data Source: Contains data relating to the usage of a website (hits). 2) Use data source filters instead of the Filters Shelf. How do I blend these data sources by year? - The Tableau Community. Excel . Does the. Credits to Jonathan Drummey for the below workaround Cannot blend the secondary data source because one or more fields use an unsupported aggregation . an aggregated left join where the aggregation of the secondary data cannot be used to increase the level of detail of the primary data. 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. 0 and 7. This means a data blend can’t be published as a data source for others to use. 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. The syntax for calling secondary data source field is not. 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. Non-additive aggregates are aggregate functions that produce results that cannot be aggregated along a dimension. One data source has some values, the other one has different values. A datetime field in the primary data source, for example, will not blend with a date field in the secondary data source. All three options are demonstrated in the attached workbook using the sample data set Superstore. 4. It's a technical limitation. The secondary data source just pulls in some names to associate with ID numbers in the primary and some filters for the staff data. 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. Functional cookies enhance functions, performance, and services on the website. 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. like below . In the Relationships dialog box, under Secondary data source select Custom, and then click Add. Blending from a polygon-based map to an existing data source which uses 1-to-many joins. Data blending; Table Calculations; Resolution Use one of the following workarounds: If possible, join instead of blend your data. Loading. THEN add this total to the SUM of the projected_users from today's date through month X. Thank you. A datetime field may be converted to a date field using a calculation to remove the time portion. {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 a parameter with a calculated field to filter the secondary data source at the row level. Open. All data from a secondary source comes back as an aggregate -- even if there is only one value from the secondary source. LOD expressions are used when running complex queries with multiple dimensions at the data source level. tds and . " Is there a way to circumvent this issue? Or perhaps a different method entirely. Blending your Data in Tableau. I am trying to determine the Average Revenue per User by country for which my calculation is total revenue/unique subscribers. 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. 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 . Does anyone have any Ideas how I can apply a universal filter. Best solution. "Cannot blend aggregated data from the secondary data source with the data on this sheet because there are no linking fields use din the view" I'm using 2 separate data sources connected to Oracle and published to the Tableau server. Community Manager update. Thanks bharat ! but i think client column is common to both the source so i would able to blend the data. 5 3 . In your 2nd and 3rd data sources. since i want only offername from secondary source to the view and the measures are produced from primary datasource is pos_trn. Primary Data Source: Contains a list of all employees and their role. 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". CSS ErrorData blending is based on two key components- Primary data sources and Secondary data sources. I thought about using a parameter but you cant search with a parameter in a prompt, on the other charts that are like this there are hundreds on items. Assuming that's what's going on, there's the question of how to work around this. In the Add/Edit User Mapping dialog crate, do the following: Select a select by the primary your data. Click oLoading. please check the attached workbook. 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. 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. 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. I've attached my workbook that contains 2 data sources that are blended by invoice number. Expand Post. 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. 1. The default view that you first see in the Data Source page canvas is the logical layer of the data source. 1. ×Sorry to interrupt. Secondary data source has Order Date represented as separate Year and Month fields. 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. Resolution. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. 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. If you want to filter data across secondary data sources, consider. First data source looks like below. 2 and later. We have a calculated filed where an aggregation (COUNTD) is done on a filed of secondary data source. COUNTD is tough to work on while you. Loading. Think of this layer as the Relationships canvas in the Data Source page. 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. [Work Hours]) So you have to make. For secondary data source you get same result by managing relationships in your case just Area and Qtr. You can also define the relationship manually by right-clicking on the data source name in the Data pane, and selecting Relationships. the count of claims I'm getting from the secondary data source, by counting distinctly a measure called claimid. 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). Some examples include: cookies used to. In Tableau Desktop, navigate to Data > Edit Relationships. Then, after data blending, the final graph cannot show the data related to the South and East. Make the data source that contains the field that you want to use in the URL action the primary data source in. Unknown file type Total from Secondary Data Source. - Data to Map from - Data to Map to . Data blending tools can present their findings as visualizations, such as infographics and charts, after querying data sources and aggregating relevant information. 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. E make table 2 the primary. 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. General Information. ×Sorry to interrupt. Error: Cannot Blend the secondary data source because one or more fields use an unsupported aggregation. if you have blended data sources you can not use lods One of the drawbacks of blended sources . So, basically, I am having issues with 2 calculations - the FIXED LOD and Remaining Value. 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. targets. 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. 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. 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 use the Opp ID to relate them. Secondary Data Source: Extract W. Are you talking about Tableau Prep or Tableau Desktop? Any chance you can share a sample of your data? Expand Post. 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. One approach that succeeds in adding another measure is to add the measure in question to your. 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 . This type of bases does not allow for blend relationship, therefore, you cannot use a filter like this. Data sources can contain logical tables not be used as secondary data sources for data blending. 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. This can help researchers identify. Let say from DS1 if i am making it as primary datasource then i can get the. Another way to approach this is to do a join of the data outside Tableau via a federated data source. I have three different data source . The default view of Data Source canvas is the logical layer in Tableau version 2020. Ritesh Bisht (Member) 6 years ago. Expand Post. It is important to understand which is the primary source, it can impact your view. with blends, we are only able to support aggregates (like SUM, MIN, MAX. I establish the blend relationships explicitly by going to Data -->Edit Blend Relationships, and selecting the fields that should be related. [OIL DATE]) THEN MIN ( [KMs]) END. LOD calculation and blended data sources. I was now trying to use both calculations you did on a different sheet through data blending. They cannot be used as secondary data sources. 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. Data blending is particularly useful when the blend relationship—the linking fields—need to vary on a sheet-by-sheet. 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. This link might help you: Cannot blend the secondary data source because one or more fields use an unsupported aggregation. As it turns out, I didn't actually end up using an LOD, but thought I might have to, hence the reason for JOINING the data together as shown in. In the calculation dialog box, do the following: In the name text box, enter Sales for Store - South. 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). 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. Use the geographic role in the primary data source on detail instead of the dimension from the secondary data source. Both Primary and Secondary data sources have duplicate rows due to multiple joins in data prep. The unsupported aggregation happens when your aggregate requires row-level visibility to the secondary data source. Tableau Desktop & Web Authoring. drag the secondary measures to measure values section . Good morning @Fred Yu (Customer) . cannot blend aggregated data from the secondary data source with data on this sheet. As you can see I have 2 different data sources using a blend on the blood type. Selected as Best Selected as Best Upvote Upvoted Remove Upvote 1 upvote. I would like to visualize number of distinct hardware. You can create a federated database using linked tables/worksheets. I have two data sets that are linked across Date and Product Category fields. 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. If I remove the blend, I cannot use/filter the secondary data source, and If I use the blend, it will display only the values for the first data source, but not from the second one, excluding. thanks. The first field you drop onto a worksheet defines the primary datasource. I have two data sources and doing a data blend. Viz cannot be filtered with secondary data source filter before loading the visualization so using "[DS_Name]. Chicken + Choice of Drink1 pc. For example, sheet A uses data source 1 as the primary data source; sheet B uses data source 1 as the secondary data source. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. ×Sorry to interrupt. Tableau Desktop 2018. General Information. I have two data sets that are linked across Date and Product Category fields. One of the Dimension which is part of the Relationship between Primary and Secondary Data Source is being used in Filter and the same field cannot be displayed in Report as it changes the Level of grain of the reportIm using two data source to develop the workbook. Secondary data source: spatial file containing the geometry. ×Sorry to interrupt. The date values must be in the same format. Loading. And I use Join data source, after divide measures / row duplicate. I can get all the fields into the view apart from the 'is vat exempt'. Overall LOD will show correct result in Primary datasource. I have just realised why the blending was not working. Here is situation I am facing, I have blended two data sources and created a worksheet. 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. If you want to make sure you don't lose any measures from the secondary source then either. " Expand Post. However, I still get that message saying cannot blend the secondary data source because one or more fields use an unsupported aggregation". We use three kinds of cookies on our websites: required, functional, and advertising. It says, "fields cannot be used from [data name] data source, because there is no relationship to the primary. I cannot change the case of the data to upper or lower. Right-click in the Data window and then. I have 2 separate data sources that have similar fields. “Cannot blend the secondary data source because one or more fields use an unsupported aggregation. Hi All, Is there a way to use a parameter to work for secondary data source in blending. 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. Left. 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 . CSS ErrorAfter Blending, Now it is showing this error: Cannot blend the secondary data source because one or more fields use an unsupported aggregation. 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. - Dataset 1, records the amount spent on ads as "Cost". While using blending data source some of the function doesn't perform well in calculation like COUNTD(), LOD{}, MEDIAN() etc. 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. 0 but was disabled (greyed out) in 8. amount into the view, it gives me the correct sum. " Filtering Across Multiple Data Sources Using a Parameter; Cause A sheet cannot be filtered by a field from a secondary data source. 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. 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)]. Option 1: Include all linking fields in the view, and aggregate secondary fields Data blending will work when the secondary data source uses logical tables, as long as the following conditions are met: All active linking fields from the primary data source must be included in the view on a shelf other than the Filters shelf Link Primary Source and all other secondary source on this Field Created from step 3- 4 using Edit Data blend Relationships 6. Advantages: Very easy to write and implement. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. 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). Primary Data Source: Extract S. on Rows, Columns, Pages, or the Marks Card. When you data changes, you need to redo the. See the attached updated workbook. Resolution. However, when I follow your advice, each group splits into 6 rows (one for each month - January through June). Blending takes place in the 6th step of the order of operation after the data table for the individual worksheet is set and the filters applied - data from the secondary source are aggregated at the level of the link and brought to the primary as. i. . 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. After blending, CountD works fine on primary datasource, but when I try to use CountD on secondary datasource tableau gives error: "Cannot blend secondary data source as one or more fields use an unsupported aggregation" Because of this, our overall.