Tableau Desktop Resolution Try one of the following options, as appropriate for your workbook: It may be possible to cross database join instead of blending. 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. As 'Group' is from a secondary data source, I cannot simply use the sort buttons. Reference line -----> in this approach able to show sub-category items measures like sales and quantity totals as reference lines shown in below figure . You cannot filter data across secondary data sources. 1, the ability to "Show Empty Rows" (or columns) was removed when you use a secondary data source. In the Data window, switch to the [data name2] 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 combine data in the logical layer using relationships (or noodles). I'm trying to create a frequency distribution as a percent of total for individual products in a single category on one chart, then dual axis a second chart with the frequency distribution of the category for comparison purposes. 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. Loading. Tableau Desktop 2018. Pick the secondary data source in of Secondary data source pane. Secondary data source has Order Date represented as separate Year and Month fields. . Thanks bharat ! but i think client column is common to both the source so i would able to blend the data. 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. png - Ben-Sullins's library "Cannot blend the secondary data source because one or more fields use an unsupported. From what I understand, it's because the link variable must be present in the view, or else it does not work. 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. I am confused, as I am not even trying to blend Data from both Data Sources. 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. Data blending is particularly useful when the blend relationship—the linking fields—need to vary on a sheet-by-sheet. Secondary data sources cannot have logical tables (except when they satisfy specific conditions). 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. Secondary Data Source: Extract W. I have 2 data sources, A and B, they are linked by data blending with A. Each has a joining field with the same name. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. "Data Sources that contain logical tables cannot be used as secondary data sources for blending". "Cannot blend the secondary data source because one or more fields use the == function, which cannot be computed locally. This will be identified with a blue checkmark. But seems we cannot blend 2 secondary data source with same field. 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. Data & Connectivity. 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). 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. Hi Andy, Following up on this - Tableau has been promoting the jump to relationships, in place of joins. Using Tableau; Upvote; Answer. The version I am working with 10. The date values you want to blend on must exist in both data sources. Secondary data source: (excel) master zip file with ~40k rows (all US zips) - each zip is tied to a territory I am looking to add the territories from the master zip to territory file as a filter. I have a primary data source coming from a published data extract blending with a secondary data source coming from an Oracle Database. Also, after I get the total per PO Number, I want to get a remaining value that subtracts the Total Cost (from the secondary data source) from the Total per PO Number. Option 2: Create a calculation for a more dynamic sort. I have two data sources which I have blended together on two fields: branch and date. 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. Another sheet:W2 is created with Data source A - taking Role in Row shelf. Cannot blend the secondary data source since one or more search use certain unsupported aggregation. Functional cookies enhance functions, performance, and services on the website. The version I am working with 10. Primary Data Source: Contains a list of all employees and their role. Loading. 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. 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. The Products set contain the individual products within an Opportunity whereas the Opportunities set contain Sales metrics (i. Fields from the secondary data source used in the view have an orange tick. ×Sorry to interrupt. Chicken - VMBurger + Choice of DrinkBurger - VMSpaghetti + Choice of DrinkSpaghetti - VM Trying to do a COUNTD() from a secondary data source and got this dreaded error: > Cannot blend the secondary data source because one or more fields use an unsupported aggregation . ) If only one of the tables requires row level information, consider making that the primary data source in the blend (I. 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". 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. Marked as. The data source with the KMs is the primary source. Data from a secondary source is displayed along with the primary source data. Input cannot become used from the [name are secondary data source] data source, because there is no blend relationship to the primary data source. 1 because it can cause Tableau to unexpectedly quit. Data of any sort coming from a secondary source must come as an aggregate of some sort. Data blending have some limitations regarding non-additive total such like COUNTD, MEDIAN, and RAWSQLAGG. I am trying to create a waffle chart. This would be a great time saver, with all of the calculations and linking changing as well. 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 there is another aggregation type such as AGG_AVG being used, change it to one of the supported aggregation listed above in the cube database itself before using in Tableau Desktop. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. Ken Flerlage (Member) 5 years ago. 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. 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. Make the data source that contains the field that you want to use in the URL action the primary data source in. 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. 2) DB2 blending doesn't support non-additive aggregates like COUNTD() from secondary sources. Can anybody please help me with a solution. ×Sorry to interrupt. There is a possibility that the values can be restricted from the secondary data. The point is to do row-level work in the secondary source, so that when the blend pulls data it doesn't have to do the row-level work. This can restrict many values from the secondary data source. "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. Resolution. the count of claims I'm getting from the secondary data source, by counting distinctly a measure called claimid. Fixed, countd functions won't work with the secondary datasources. cannot blend aggregated data from the secondary data source with data on this sheet. I am trying to blend the same data against the other because I wanted to show Same Period last Year. However, when I follow your advice, each group splits into 6 rows (one for each month - January through June). General Information. In the data window, the blue tick indicates the Primary data source (Sales in the image below). I have 2 separate data sources that have similar fields. I'm using a data blending method, where: Primary data source: Contains the ID I'm trying to count. Twbx and also the . 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. CSS ErrorAfter Blending, Now it is showing this error: Cannot blend the secondary data source because one or more fields use an unsupported aggregation. you will get 5/22 date. Name: Distinct Count. So, in the dummy data, there are two tables from two data sources. When you data changes, you need to redo the. tds and . 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. e. So if you drag Category from the Orders data source, it will automatically mark Orders as the primary data source. From my primary data source I have a dimension in columns say 'Customer Segment'. You cannot change that. Expand Post. 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". I have two data sources which I have blended together on two fields: branch and date. Thanks. They cannot be used as secondary data sources. However, some days will have entries for "Cost" but not for "Proj. 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". Common Issue #1: Cannot blend the secondary data source because one or more fields use an unsupported aggregation The aggregation methods of COUNTD,. Fee". I am trying to blend the same data against the other because I wanted to show Same Period last Year. If you want to filter data across secondary data sources, consider. data source. additionally, data coming from the secondary source are always aggregated at the level of the link when brought to the primary source - the individual records are no longer available and you are not able to filter across the various data sources at that point - that is the long way of saying you will have to join or use a. Size() is a great choice for unique counts across data sources if you can create a view where every unique row is displayed. I get error: “Cannot blend the secondary data source because one or more fields use an unsupported aggregation. The default view of Data Source canvas is the logical layer in Tableau version 2020. When I make the data source as Primary, I am able to see the respective values, Kindly see the below screenshot:- But, when I consider this data source as secondary and then try to use it in primary data source sheet, I get this error:- Cannot blend the secondary data source because one or more fields use an unsupported aggregation. IF min([Current Period ]) = true then [Display Sum Media Cost] end / sum(IF [Current Period ] = true then. 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. I have two data sources and I have blended them together. Call it [Start KM]: IF ATTR ( [KM Date])=ATTR ( [OIL]. 2)Count Distinct from Secondary workaround. 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. If you want to make sure you don't lose any measures from the secondary source then either. 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'. Hi. If I cant go the above way then is there a possibility to do the duration calculation using table calculations or some other way. I tried data blending keeping File C as primary and A & B as secondary data source with DD number as relationship. 1) Duplicate the field in primary datasource. The secondary data source need to be my transaction file and primary data source need to be my budget file. Are you talking about Tableau Prep or Tableau Desktop? Any chance you can share a sample of your data? Expand Post. This is a new complexity in Tableau v8: In v7 and earlier, to blend we had to have the linked dimensions in the view, i. "Cannot blend the secondary data source because one or more fields use the / function, which cannot be computed locally. Then try using the LOD expression from a secondary data source. Some examples include: cookies used to. Note: If the geographic role does not exist in the primary data source, then it will be necessary to create the view with the data source that contains the geographic role as the primary data source. If you make sheet 1 as the primary data source and do the data blending with sheet 2. In the past, I've just changed my primary table to the one with the calculation. LOD (exclude) - Filtering using a different data source I've used LOD (exclude) to create a % of total calc field (and then created a moving average off that). Use the geographic role in the primary data source on detail instead of the dimension from the secondary data source. I have my primary data source with dimensions customer and order no and a secondary data source with customer, postcode and an 'is vat exempt' boolean field. you get all data from main data source and ONLY matching data from secondary data source. 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). LOD expressions are used when running complex queries with multiple dimensions at the data source level. Data blending is particularly useful when the blend relationship—the linking fields—need to vary on a sheet-by-sheet. FIXED requires that you have row-level access to the rows in the secondary source. Verify if one of the measures coming from the cube data source has a default aggregation different than SUM, MIN, MAX, COUNT. Filtering data across a worksheet's secondary data source is not currently supported in Tableau Desktop. 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. Dominic Laird(Member) 5 years ago. In the Data window, right-click the relevant field. For details, see Troubleshoot Data Blending. Data blending has some limitations regarding non-additive aggregates such as COUNTD, MEDIAN, and. id = B. e. To blend on summary data, you can do the following: Create a. 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 It’s cable reimagined No DVR space limits. I am trying to use the below formula instead of countd function because my data comes from Impala. Sometimes , it's automatically working but sometimes it says 'Unsupported Aggregation' . I read that this is not possible. Fields from the secondary data source used in the view have an orange check mark. AUMTable (Secondary) 3. 1. I tried data blending using the zip codes as a common field but I am facing very slow performance. Observations : 1. 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. COUNTD is tough to work on while you. Hello Jim, Thank You for your reply. Currently, data sources that contain logical tables cannot be used as secondary data sources for data blending. The first field you drop onto a worksheet defines the primary datasource. I am getting Cannot blend secondary data source because one or more fields used an unsupported aggregation. When blending in Tableau, there is always a primary source and a secondary data source. This feature would be really useful to ensure we can. There's a set of views/calcs that show a metric, (metric C) counting distinct number of accounts contacted per person per week (e. Trying to do a COUNTD() from a secondary data source and got this dreaded error: > Cannot blend the secondary data source because one or more fields use an unsupported aggregation . General Information. As 'Group' is from a secondary data source, I cannot simply use the sort buttons. When Bugs History is a live connection to Vertica living inside my workbook all is well. If you create a quick filter on a field from data source 1 and apply this quick filter to. 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. 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. Step 2: Make it a context filter. I think I need to define the relationship between the data sources. Best solution. However when I use B as primary data source, drag [A]. Here is an example of what I am trying to accomplish:Data blending is a method for combining data from multiple sources. Help would be much. 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 . "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. This happens regardless if I drag it on the rows or on the Marks space as a 'text'. Please check the attached workbook for details. Data blending brings in additional information from a secondary data source and displays it with data from the primary data source directly in the view. I have two datasets; one is a shape file that contains regions and locations. The value gets reduced based on filters@@@ from all data source. Tableau automatically adds an aggregation (SUM) around the column from the secondary source. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. Place Organisation Identifier on the level of detail shelf (from the primary source, or both sources) and the blend should work. You can choose whether functional and advertising cookies apply. The data source with the KMs is the primary source. Build whatever calculated fields from the secondary that need to be used in in the primary. Primary and Secondary sources in data blending. * Supplemental data from a secondary data source is needed. COUNTD - Blended data. ) If only one of the tables requires row level information, consider making that the primary data source in the blend (I. I have a Remaining Value calculation, but it is not correct. Does the. Data blending is a good option when you have multiple data sources that cannot be combined through relationships. Date dimensions: For cube data sources, date dimensions are typically organized into hierarchies that contain levels such as year,. Primary and Secondary sources in data blending. So make sure you're not using such function while blending. This type of bases does not allow for blend relationship, therefore, you cannot use a filter like this. Currently, data sources that contain logical tables cannot be used as secondary data sources for data blending. I have two data sets that are linked across Date and Product Category fields. It is important to understand which is the primary source, it can impact. Cannot blend the secondary data source because one or more fields use an unsupported aggregation" when Data Blending. Advantages: Very easy to write and implement. Another way to approach this is to do a join of the data outside Tableau via a federated data source. Instead, the. As you can see I have 2 different data sources using a blend on the blood type. " message. 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. I. 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. I've attached my workbook that contains 2 data sources that are blended by invoice number. Upvote. The default view that you first see in the Data Source page canvas is the logical layer of the data source. Even if I don't join the 2 data sources and just blend them by "Region" and "Store Name", I still get "Cannot blend the secondary data source because one or more fields use an unsupported aggregation" on dragging Total Utilized Money field into the view. 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. In the secondary data source, select Data > Create Calculated Field. Go to Data menu on top and go to Edit Relationships (Data -> Edit Relationships) Create a custom relationship between the 2 new created in 2nd and 3rd source. Hi, I'll expand a bit on what @Chris wrote: There are some fundamental limits to what can be done with data blending and while there are workarounds that can get us the desired results in some circumstances those workarounds will not work in all circumstances (because Tableau never built out data blending to handle every. But since there are a few dates missing from the second data source i cannot blend on date as doing this will result in loosing data from Table 1. The chart should display: countd. I use the Opp ID to relate them. Please post you twbx workbook so we can see if there a way . Another way to approach this is to do a join of the data outside Tableau via a federated data source. Also, in the attached I have added both Calc1 and Calc2 to the tooltip in Sheet 9. Select Custom in the relationships list, and then get Attach. Unknown file type Total from Secondary Data Source. " inner cross database join on BU Code with a data source filter set up on UPPER([ID])=UPPER(USERNAME()) on the DS2 source. "Filtering Across Multiple Data Sources Using a Parameter; Cause A sheet cannot be filtered by a field from a secondary data source. I have two data sources to be used but need the count distinct of users from both the data sources. 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. So you need to create a Date field in your Master Data Source, which is why I usedAlternative to CountD function in Blending. [OIL DATE]) THEN MIN ( [KMs]) END. Because there are no linking fields in this view. Use a parameter with a calculated field to filter the secondary data source at the row level. A key difference with blending is that data is aggregated before being "joined" - you'll notice this when you include a column from the secondary source in a calculation in the primary source. I'm trying to show a distinct count of claims by branch. g. The condition is offer status = hired, but offer status can contain my different response types. I can get all the fields into the view apart from the 'is vat exempt'. Step 1: Connect to your data and set up. Why are values from the secondary data source not appearing in a blended data source view? They did not exist in the primary data source. Let say from DS1 if i am making it as primary datasource then i can get the. Because in Tableau, you don't use COUNTD function when Blending data source. 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. Tableau will throw an error: “Cannot blend the secondary data source because one or more fields use an unsupported aggregation. 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 HelpWhen I am using apply filter to related data sources, other data sources add this field as a secondary data source and the worksheets which uses that as a primary data source gives me errors. Drag the 2016 Population measure to the Columns. If I cant go the above way then is there a possibility to do the duration calculation using table calculations or some other way. Remove all dimensions from the secondary data source and ensure that the primary data source’s. This means that when a cube data source is published, you cannot make a connection from Tableau Server using the data source. General Information. Yes - you can't bring COUNTD in data blending. Summary:. Chicken + Choice of DrinkBurger + Choice of DrinkSpaghetti + Choice of Drink . Try one of the following options, as appropriate for your workbook: It may be possible to cross database join instead of blending. the blended data cannot be published to Tableau Online or Tableau Server. It takes advantage of the data collected from previous research and uses it to carry out new research. SandhyaData from the secondary data source (via a data blend) can never be a dimension. Even if I don't join the 2 data sources and just blend them by "Region" and "Store Name", I still get "Cannot blend the secondary data source because one or more fields use an unsupported aggregation" on dragging Total Utilized Money field into the view. In the Add/Edit Field Mapping dialog box, select the date fields from the primary and secondary data sources, and then click OK twice. I am trying to determine the Average Revenue per User by country for which my calculation is total revenue/unique subscribers. 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. But when I am trying to do that I am getting an errorThe issue comes when I try and add a metric that is an aggregate of the two different sources. Maxdate) There is one more way, make the datasource which is using the fixed calculation to. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. the count of claims I'm getting from the secondary data source, by counting distinctly a measure called claimid. So, basically, I am having issues with 2 calculations - the FIXED LOD and Remaining Value. " I have seen a few posts on it and found an issue logged about it as far back as version 8. e. Filtering data across a worksheet's secondary data source is not currently supported in Tableau Desktop. 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. " inner cross database join on BU Code with a data source filter set up on UPPER([ID])=UPPER(USERNAME()) on the DS2 source. - Data to Map from - Data to Map to . 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". Instead, publish each data source separately (to the same server) and then blend the published data sources. the branch field I'm using from the primary data source. [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. The blend applies to that worksheet only. Currently, data sources that contain logical tables cannot be used as secondary data sources for data blending. For more information, see Troubleshoot Data Blending; Blended data sources cannot be published as a unit. Upvote Upvoted Remove Upvote Reply. Data blending is a method for combining data from multiple sources. 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. I am just trying to filter every Data source, by choosing a field that every Data source has. ”. The blend applies to that worksheet only. We can see these by activating secondary data source and looking at the dimensions window, the linking dimensions will have an orange chain icon. You can choose whether functional and advertising cookies apply. In this source create a calculated field to pull out the KMs on the date of oil change. Maxdate) There is one more way, make the datasource which is using the fixed calculation to primary data source. I am already using a Custom SQL query as an additional data source and trying to do blending based on the relationship on BU code field from RPT and AD. I have two data sources and I have blended them together. We cannot use ATTR if trying to create an LOD type calculation if blending data sources. 💥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. My problem happens when I go to the dashboard, I want to filter on FW (fiscal week) and have crosstab. All customer IDs are under a dimension called "Global ID". 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. 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]) results in error I can add to filters from the data extracts. Think of this layer as the Relationships canvas in the Data Source page. Nitish Pamarty (Member) 7 years ago. Drag the State (group) dimension over the Region dimension on the Rows shelf to replace it. Option 2: Create a calculation for a more dynamic sort. Selected as Best Selected as Best Upvote Upvoted Remove Upvote 1 upvote. Data source A has Role Column and Data source B also has Role Column. I cannot change the case of the data to upper or lower. " The only fields used in the view are the date fields, to which I did a . You can choose whether functional and advertising cookies apply. But the source calc is a countD. I have quick filters from the primary data source and I am trying to represent distinct. the branch field I'm using from the primary data source. Instead of using relationships, double-click into your table to get to the. Now, in dashboard D1 : has two worksheets W1 and W2. cannot blend aggregated data from secondary data source. Ritesh Bisht (Member) 6 years ago. In data blending, there is a primary data source and a secondary data source. The secondary data source just pulls in some names to associate with ID numbers in the primary and some filters for the staff data. cannot blend secondary data source because one or more fields use an unsupported aggregation beacuse of LOD. 3) Select the now grey link next to the original field in. [tier] == 0 then "Low vendors" elseif max [Secondary]. This happens only when the data sources are impala. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. I have 2 published datasource and i think i cannot perform JOIN, LOD and COUNTD. Upvote. See Troubleshoot Data Blending - Tableau for more information on this and other errors that may occur while using data blending. "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. 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.