cannot blend the secondary data source. I have two data sources which I have blended together on two fields: branch and date. cannot blend the secondary data source

 
 I have two data sources which I have blended together on two fields: branch and datecannot blend the secondary data source  This is a dynamic way to make data in sets stand out and gain greater real-world context for users

duplicate the date field. It's a technical limitation. Think of this layer as the Relationships canvas in the Data Source page. The Products set contain the individual products within an Opportunity whereas the Opportunities set contain Sales metrics (i. This means a data blend can’t be published as a data source for others to use. Proj. See Join Your Data for more information. A datetime field may be converted to a date field using a calculation to remove the time. 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. Good morning . 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. When I calculate the average of a measure and use the filter, it works perfectly fine. Data blending has some limitations regarding non-additive aggregates such as COUNTD, MEDIAN, and RAWSQLAGG. The solution. In second data source i don;t have salesrep column. (I created calculated fields "Fiscal Year" and "Fiscal Month" on my secondary Superstore example to simulate this. This can help researchers identify. I can add to filters from the data extracts. "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. The value gets reduced based on filters@@@ from all data source. CSS ErrorAfter Blending, Now it is showing this error: Cannot blend the secondary data source because one or more fields use an unsupported aggregation. The chart should display: countd. Common Issue #1: Cannot blend the secondary data source because one or more fields use an unsupported aggregation The aggregation methods of COUNTD,. the blended data cannot be published to Tableau Online or Tableau Server. Any existing, automatic blend kontakte is visible (and pot be deleted by suspend over the row and clicking the x). In blending data source, I try to slove problem but I can't. then i added a secondary data source from google sheet , which has the fuel amount. 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. Hi All, I have blended primary and secondary data sources. [% age]>=SUM([Percentage]) . While using blending data source some of the function doesn't perform well in calculation like COUNTD(), LOD{}, MEDIAN() etc. Data blend is like a Left outer join. Modify the calculation to not use table functions;. Complex as the problem may be, the solution is comfortingly simple. When you blend, you can only have aggregate access to the rows in the secondary. You can also define the relationship manually by right-clicking on the data source name in the Data pane, and selecting Relationships. You can choose whether functional and advertising cookies apply. 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. Verify if one of the measures coming from the cube data source has a default aggregation different than SUM, MIN, MAX, COUNT. 2. , 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. IF ATTR([Offer Status]) = "Hired" Then AVG([Comp_File]. 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. I think I need to define the relationship between the data sources. Create a “Blend Field” with a value of 1 in both your primary and secondary. Hi. Tableau Desktop; Blended data; Soluzione Use the following workaround: Create a new worksheet. id, A. Option 2: Create a calculation for a more dynamic sort. 1. 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. Mihai Constantinescu (Member) 6 years ago. My goal is to show CY Actuals as bars, with a line for PY Actuals and a line for Budget. Fields cannot be used from the [name of secondary data source] data source, because there is no blend relationship to the primary data source. Another table is a a table that contains key fields such as date, region, location and hardware id (dimension). Tableau automatically adds an aggregation (SUM) around the column from the secondary source. In your 2nd and 3rd 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. When blending in Tableau, there is always a primary source and a secondary data source. However, when I follow your advice, each group splits into 6 rows (one for each month - January through June). The data in the primary data source is the main data on which Tableau defines graphs and charts. The reason of the errors being unsupported calculation in blend. month([date])=month(Parameter. Option 2: Create a calculation using WINDOW_SUM() Drag the linking field(s) from the secondary data source to. e. 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. Data of any sort coming from a secondary source must come as an aggregate of some sort. Ambiente. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. However, when the linking dimension is not in the view, non-additive aLoading. Cannot Blend Secondary Data Source - Unsupported Aggregation. CSS ErrorLoading. The limitation with Tableau and secondary data sources stinks. I ended up purchasing an Alteryx license for our company (we now have a lot. Twbx and also the . If you have to have row-level access on a. 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. ×Sorry to interrupt. The date values must be in the same format. A datetime field in the primary data source, for example, will not blend with a date field in the secondary data source. To overcome this, I've added a filter straight into the data source and not in the view. [OIL DATE]) THEN MIN ( [KMs]) END. Please refer the below link and let me know if this helps to you. I can get all the fields into the view apart from the 'is vat exempt'. Data blending; Table Calculations; Resolution Use one of the following workarounds: If possible, join instead of blend your data. I'm blending the 2 data sources by Service_Id. This can restrict many values from the secondary data source. cannot blend aggregated data from secondary data source. This will be identified with a blue checkmark. 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. Expand Post. A data blend cannot filter on dimensions that do not exist in the Primary data source. However, some days will have entries for "Cost" but not for "Proj. the count of claims I'm getting from the secondary data source, by counting distinctly a measure called claimid. unsupported aggregation. Therefore it cannot display null data. If you want to filter data across secondary data sources, consider the following alternatives: Join tables that are in the same data source, instead of blending them. And I use Join data source, after divide measures / row duplicate. I like to have the ability to swap a primary data source with a secondary data source for data blending in a workbook. 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 values in a single view. 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. LOD expressions are used when running complex queries with multiple dimensions at the data source level. 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. 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. Applies to: Tableau Cloud, Tableau Desktop, Tableau Server Data blending is a method for combining data from multiple sources. 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. 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. Then try using the LOD expression from a secondary data source. I have three different data source . Loading. Expand Post. I noticed that when the spatial file is the secondary data source, I cannot area plot it by double clicking the geometry variable. Data from a secondary source is displayed along with the primary source data. Which version of Desktop are you using? See attached the superstore workbook (. Can't see what you are actually doing but Blending data has its limits. 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. Build whatever calculated fields from the secondary that need to be used in in the primary. Chicken + Choice of Drink1 pc. order_date. 3) Select the now grey link next to the original field in. 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. if that is the case I could get same results by joining 2 data sources just by linking Area and Qtr not all 4 and without using LOD for secondary data source i. 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. This happens only when the data sources are impala. This type of bases does not allow for blend relationship, therefore, you cannot use a filter like this. Hope this helps kindly mark this answer as correct or helpful so that it will help others . 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. 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. Data blending: Cube data sources can only be used as the primary data source for blending data in Tableau. 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. e. 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. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. Advantages: Very easy to write and implement. I have a primary data source coming from a published data extract blending with a secondary data source coming from an Oracle Database. I am using tableau 2020. 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". 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. You can choose whether functional and advertising cookies apply. Drag the State (group) dimension over the Region dimension on the Rows shelf to replace it. Here are the 7 major steps for putting this together: Set up your primary (main) and secondary (parameter) data sources. ×Sorry to interrupt. 4, I tried to blend products (secondary) to storefront (primary) based on Sku. "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. 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. A COUNTD of Order ID should be all I need to show this data but it always results in a "Cannot blend the secondary data source because one or more of the fields use an unsupported aggregation". I have a Remaining Value calculation, but it is not correct. Make sure that you are blending on dimensions present in the view or on all of the. 1. The aggregation is all on primary source data. LOD Expressions will not be shown in the Data Source; When referencing a dimensionality declaration parameter, always use the parameter name and not the parameter value; With data blending, the primary data source's linking field must be in the view before you can use a LOD expression from the secondary data source. 2) Use this duplicate field in the view instead of the original. Loading. i. Community Manager update. I want to do a basic data listing showing customer, order no, postcode & vat exempt. 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. We are blending two data sources. you will get 5/22 date. Expand Post. In versions prior to 2020. Another sheet:W2 is created with Data source A - taking Role in Row shelf. Status, Stage, etc). 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. Fee". Please check the attached workbook for details. In the data window, switch to [name1] data source, and click at least one link icon to blend these data sources. Please find the complete blog here ----> COUNTD with secondary DS Tableau(Blending) Workbook is attached. I am trying to blend the same data against the other because I wanted to show Same Period last Year. blending [cannot blend Measure Values from a secondary data source] -----> this approach failed . Show moreA workbook or mock data would be a sure thing to comment and try upon it. In the data window, the blue tick indicates the Primary data source (Sales in the image below). Functional cookies enhance functions, performance, and services on the website. Remove all dimensions from the secondary data source and ensure that the primary data source’s linking field is in view. Currently, data sources that contain logical tables cannot be used as secondary data sources for data blending. 2 and later. Before I check Date filters, I got this results. I tried data blending using the zip codes as a common field but I am facing very slow performance. This means that when a cube data source is published, you cannot make a connection from Tableau Server using the data source. Make the data source that contains the field that you want to use in the URL action the primary data source in. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. 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. We don't get row-level data from secondary sources on a blend. Because the question is related to how the data sources are being related, it would help to see the real data structure. Hi . Become a Better Analyst in Just 5 Minutes a Week. There are a few possibilities: 1) Flip the blend so the primary is secondary and vice versa. A Level of Detail (LOD) expression is being taken from the secondary data source. We cannot use ATTR if trying to create an LOD type calculation if blending data sources. From Primary Data Source drag the measure names and measure values . 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 . Drag the 2016 Population measure to the Columns. I have two data sources and I have blended them together. 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. Few things you need to keep in mind while blending data sources in tableau. General Information. Data blending is a method for combining data from multiple sources. I. ×Sorry to interrupt. Click oLoading. Error “Cannot blend the secondary data source because one or more fields use an unsupported aggregation. I cannot change the case of the data to upper or lower. I'm using a data blending method, where: Primary data source: Contains the ID I'm trying to count. 4. "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. Try one of the following options, as appropriate for your workbook: It may be possible to cross database join instead of blending. Loading. I am trying to blend the same data against the other because I wanted to show Same Period last Year. newBranchProjection (Secondary) When I try to add COUNTD([DistrictId]) from my primary to text table. If you want to filter data across secondary data sources, consider. Now you see a new group field listed in the Population data source (primary) called State (group). There's no way to "swap. 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. Upvote Upvoted Remove Upvote Reply. I'm blending student data (primary) and staff data (second). While on a view, right click a data source, click replace data source. Sometimes , it's automatically working but sometimes it says 'Unsupported Aggregation' . Data blending is a method for combining data from multiple sources. I am trying to use the measures name filter functionality with two data sources. Now, in dashboard D1 : has two worksheets W1 and W2. 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. Another way to approach this is to do a join of the data outside Tableau via a federated data source. This feature would be really useful to ensure we can. 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. E make table 2 the primary. Upvote Upvoted Remove Upvote Reply. All the data is in the secondary/blended data source. 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. A datetime field in the primary data source, for example, will not blend with a date field in the secondary data source. If you are blending a cube data source, it must be the primary data source. If this aggregation is ATTR() then the grand totals may be blank. "Data Sources that contain logical tables cannot be used as secondary data sources for blending". 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. For more information, see Troubleshoot Data Blending; Blended data sources cannot be published as a unit. Data blending tools can present their findings as visualizations, such as infographics and charts, after querying data sources and aggregating relevant information. 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. The data is blended on customer. "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. 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. So if you drag Category from the Orders data source, it will automatically mark Orders as the primary data source. I noticed there was an issue using Data Blend from 3 different source. Hello Jim, Thank You for your reply. Filtering data across a worksheet's secondary data source is not currently supported in Tableau Desktop. So you don't get in the case of data blending. with blends, we are only able to support aggregates (like SUM, MIN, MAX. The date values must be in the same format. i will try to build some moke up data in excel and reproduce the same but before that could you please explain me in detail what calculation i need to perform in secondary source. 3) COUNTD with Secondary DS (Blending) Thanks,. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. Because there are no linking fields in this view. In your case, you're after the Total Cases by Employee, so just imagine Employee in place of Category. In the past, I've just changed my primary table to the one with the calculation. 4, I tried to blend products (secondary) to storefront (primary) based on Sku. I have two data sources to be used but need the count distinct of users from both the data sources. How to calculate Delta value. So, in the dummy data, there are two tables from two data sources. Step 1: Create the Parameter. Because in Tableau, you don't use COUNTD function when Blending data source. Data blending is a method for combining data from multiple sources. Maxdate) There is one more way, make the datasource which is using the fixed calculation to primary data source. 3 and I have created aggregates AGG for fields from data extract and excel file. This means that it forces the view to display only relevant data in the secondary data source. Resolution. Cannot blend the secondary data source because one or more fields use an unsupported aggregation It’s cable reimagined No DVR space limits. Seemingly simple task is getting complicated in Tableau . Marked as. According to Tableau, this error can also appear when using a LOD expression in a blended view. Also, data blending is useful for combining data from published. Select Analysis > Create Calculated Field. drag the secondary measures to measure values section . It has data from 2003-2012. The problem is when I try to calculate the median of that same measure. AUMTable (Secondary) 3. Upvote. 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. We have a calculated filed where an aggregation (COUNTD) is done on a filed of secondary data source. 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. If you create a quick filter on a field from data source 1 and apply this quick filter to. We use three kinds of cookies on our websites: required, functional, and advertising. 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. Marked as. I have two data sources which I have blended together on two fields: branch and date. I establish the blend relationships explicitly by going to Data -->Edit Blend Relationships, and selecting the fields that should be related. However, it gives me following error: "Cannot blend the secondary data source because one or more fields use an unsupported aggregation"We have an enterprise data source that is an SSAS Tabular model. if you have blended data sources you can not use lods One of the drawbacks of blended sources . I tried to recreate the data as close as possible. 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. One data source has some values, the other one has different values. "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. The date values you want to blend on must exist in both data sources. The Products set contain the individual products within an Opportunity whereas the Opportunities set contain Sales metrics (i. Step 2: Make it a context filter. The unsupported aggregation happens when your aggregate requires row-level visibility to the secondary data source. Data. 2)Count Distinct from Secondary workaround. 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. "Cannot blend the secondary data source because one or more fields use the == function, which cannot be computed locally. No. Using Tableau; Upvote; Answer. e. Date dimensions: For cube data sources, date dimensions are typically organized into hierarchies that contain levels such as year,. 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). " I have seen a few posts on it and found an issue logged about it as far back as version 8. CSS ErrorData blending is based on two key components- Primary data sources and Secondary data sources. How ever # no of changes and # of Problems are calculating entire database values. I get error: “Cannot blend the secondary data source because one or more fields use an unsupported aggregation. Someone in the Community told me the following: "MAX isn't supported in. 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 . Summary:. For example, sheet A uses data source 1 as the primary data source; sheet B uses data source 1 as the secondary data source. Currently, data sources that contain logical tables cannot be used as secondary data sources for data blending. Here is the sample. BR, NBBlended data sources cannot be published as a unit. For secondary data source you get same result by managing relationships in your case just Area and Qtr. I have some extra supplemental data in a CSV file that I would like to join to one of the common fields between the two so I can pull some of the SSAS measures by the supplemental data's dimensions that I've blended. Name: Distinct Count. In the Data window, right-click the relevant field. The default view that you first see in the Data Source page canvas is the logical layer of the data source. Call it [Start KM]: IF ATTR ( [KM Date])=ATTR ( [OIL]. Thank you . To alias field values. I get error: “Cannot blend the secondary data source because one or more fields use an unsupported aggregation. 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. . But there are few workaround for it. Step 3: Blend the fields with the target data source using simple blending method (clicking those broken links into red)Hi Saukarsha, The linking fields need to be somewhere on the view in order for the blend to work. when I use A as primary data source and drag A. Please see if it helps , here it says that problem is with COUNT & they have provided one alternative way as well . ) If only one of the tables requires row level information, consider making that the primary data source in the blend (I. First data source looks like below. [OIL DATE]) THEN MIN ( [KMs]) END. 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. For example, sheet A uses data source 1 as the primary data source; sheet B uses data source 1 as the secondary data source. Blended data sources. 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. Tableau Community (Tableau)Data blending creates a link on common dimensions--where those commonalities do not exist in the two data sources, values will be excluded. Calculates the number of distinct values of a field within a partition. I am blending (2) data sources based on the date. please check the attached workbook. 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. So make sure you're not using such function while blending. Overall LOD will show correct result in Primary datasource. Expand Post. Loading. " message. Expand Post. 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). Currently, data sources that contain logical tables cannot be used as secondary data sources for data blending. 1) Vizible Difference: Getting around Count Distinct in a secondary data source. LOD will not work if it is from the secondary datasource. Observations : 1. I am confused, as I am not even trying to blend Data from both Data Sources. Each has a joining field with the same name. Data blending is particularly useful when the blend relationship—the linking fields—need to vary on a sheet-by-sheet. Instead, publish. "Budget" is only contained in an Excel file data source. And I can't explain why it does that. 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. 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". Try one of the following options, as appropriate for your workbook: It may be possible to cross database join instead of blending. Secondary data source: spatial file containing the geometry. The primary data source is just to filter for the invoices I want to look at. They both share a common field (State), and that is what I'm filtering on. As you can see I have 2 different data sources using a blend on the blood type. [amount] into the view, it gives less than. For example, select Analysis > Create Calculated Field, and in the Formula text box, type the. In the Add/Edit Field Mapping dialog box, select the date fields from the primary and secondary data sources, and then click OK twice. (to which I am blending data from other sources Name and Spend) and it worked! Observe the ordering of numbers in the last column between the. Also, in the attached I have added both Calc1 and Calc2 to the tooltip in Sheet 9. The default view of Data Source canvas is the logical layer in Tableau version 2020. This is a table calculation equivalent of the COUNTD() database function, which may be required either because the result needs to be used in a calculation at a different level of detail to the level at which it is calculated, or because the datasouce. Option 2: Create a calculation for a more dynamic sort. Hello Jim, Thank You for your reply. Best solution. 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 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. Does the. Community Manager update. Filtering data across a worksheet's secondary data source is not currently supported in Tableau Desktop. "Cannot blend the secondary data source because one or more fields use the / function, which cannot be computed locally. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. That's probably your problem. The date values you want to blend on must exist in both data sources. 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. See Join your Data for instructions. Assuming that's what's going on, there's the question of how to work around this.