Primary and Secondary sources in data blending. when I use A as primary data source and drag A. 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'. Loading. 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. month([date])=month(Parameter. 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. "Cannot blend the secondary data source because one or more fields use the / function, which cannot be computed locally. I can add to filters from the data extracts. When you drag a field from a secondary data source to the view, you might see a warning that says: Fields cannot be used from the [name of secondary data source] data source, because there is no blend relationship to the primary data source. See the attached updated workbook. Proj. 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 . (It is a field that contains account names (company) in the sample data. Please see if it helps , here it says that problem is with COUNT & they have provided one alternative way as well . CSS ErrorAfter Blending, Now it is showing this error: Cannot blend the secondary data source because one or more fields use an unsupported aggregation. 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. mdb which will be used to illustrate data blending. According to Tableau, this error can also appear when using a LOD expression in a blended view. We use three kinds of cookies on our websites: required, functional, and advertising. In the Data window, right-click the relevant field. CSS ErrorData blending is based on two key components- Primary data sources and Secondary data sources. 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 made a waffle chart grid using an excel data source that contains 3 fields: Rows, Columns and Percentage. The problem I'm running into is when I use another data source as the primary source and attempt to bring over the LOD calculation from a secondary source. It has data from 2003-2012. 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". You cannot filter data across secondary data sources. If this aggregation is ATTR() then the grand totals may be blank. I have 2 separate data sources that have similar fields. My problem happens when I go to the dashboard, I want to filter on FW (fiscal week) and have crosstab. Excel . This link might help you: Cannot blend the secondary data source because one or more fields use an unsupported aggregation. 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". Case 2: If you are done with the dashboard development then create a empty extract and publish it on server and run the refresh so that data gets loaded. 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. Remove all dimensions from the secondary data source and ensure that the primary data source’s. * Supplemental data from a secondary data source is needed. Cube (multidimensional) data sources have certain characteristics that make them unique in Tableau. A datetime field in the primary data source, for example, will not blend with a date field in the secondary data source. 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. [OIL DATE]) THEN MIN ( [KMs]) END. Filtering data across a worksheet's secondary data source is not currently supported in Tableau Desktop. 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. Secondary data source has Order Date represented as separate Year and Month fields. But seems we cannot blend 2 secondary data source with same field. 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. 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. From what I understand, it's because the link variable must be present in the view, or else it does not work. ×Sorry to interrupt. cannot blend aggregated data from secondary data source. Another sheet:W2 is created with Data source A - taking Role in Row shelf. g. Few things you need to keep in mind while blending data sources in tableau. - Go to Data > Edit Relationships to create the define primary and secondary data sources and the links - Drag and drop the linked field from the primary data source to use this field on the visualisation. The value gets reduced based on filters@@@ from all data source. I am working with two Data Bases that are essentially the same, but I use the second one to "fake" dates (basically the same date +1 year) in order to use it for the YoY comparison that aligns with the different filters I set. Think of this layer as the Relationships canvas in the Data Source page. 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 the nightmare starts: when I try to add the data source B and make all the relationships, it gives me the lovely error: "Cannot blend the secondary data source because one or more fields use the ZN function, which cannot be computed locally. From what I understand, it's because the link variable must be present in the view, or else it does not work. Secondary data is one of the two main types of data, where the second type is the. There's a set of views/calcs that show a metric, (metric C) counting distinct number of accounts contacted per person per week (e. A data blend cannot filter on dimensions that do not exist in the Primary data source. Community Manager update. You can create a federated database using linked tables/worksheets. In this source create a calculated field to pull out the KMs on the date of oil change. Hi Data Modeler , I have an idea which I cannot test right away. 1) Vizible Difference: Getting around Count Distinct in a secondary data source. Some of the function doesn't work properly when we use blending like COUNTD(), LOD{} expression. Any existing, automatic blend kontakte is visible (and pot be deleted by suspend over the row and clicking the x). The blend applies to that worksheet only. The default view of Data Source canvas is the logical layer in Tableau version 2020. Filter each of the data sources independently on the more granular dimensions. However, I still get that message saying cannot blend the secondary data source because one or more fields use an unsupported aggregation". I'm using a cube data source as my primary and am attempting to blend with. unsupported aggregation. For example, COUNTD(). Please refer the below link and let me know if this helps to you. Data blending has some limitations regarding non-additive aggregates such as COUNTD, MEDIAN, and. COUNTD - Blended data. " I have seen a few posts on it and found an issue logged about it as far back as version 8. In the attached file, table shows the sum of sales and first order date correctly from both the. When on the dashboard, click on the ‘Dashboard’ drop-down and select ‘Actions’. Data blending provides a way to combine data from more than one data source on a single worksheet. Could please share me if there is a alternate solution for data source filter logic?Step 1: Place the required field into the Filter for a worksheet which sources the parent data. I've created the first chart with no problem, but I. This is the response I received from Tableau Support:Cause. While on a view, right click a data source, click replace data source. For more information, see Use Relationships for Multi-table Data Analysis. Data. I have been working on Blending feature for a while in different situations and. The default view that you first see in the Data Source page canvas is the logical layer of the data source. Then, after data blending, the final graph cannot show the data related to the South and East. I am using tableau 2020. Calculates the number of distinct values of a field within a partition. The unsupported aggregation happens when your aggregate requires row-level visibility to the secondary data source. Data blend is like a Left outer join. As you can see I have 2 different data sources using a blend on the blood type. This means a data blend can’t be published as a data source for others to use. The primary data source is just to filter for the invoices I want to look at. I am just trying to filter every Data source, by choosing a field that every Data source has. In short, Tableau connects to multiple data sources, sends independent queries to those data sources, and then combines (or “blends”) the aggregated results of the independent queries on a single worksheet. Chicken + Choice of DrinkBurger + Choice of DrinkSpaghetti + Choice of Drink . the count of claims I'm getting from the secondary data source, by counting distinctly a measure called claimid. Cannot blend the secondary data source because one or more fields use an unsupported aggregation . Option 2: Create a calculation using WINDOW_SUM() Drag the linking field(s) from the secondary data source to. However, when the linking dimension is not in the view, non-additive aLoading. Instead, we need to publish the two data sources separately on the same server and then. Data blending works like a ___ join. 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. e. In a blend, secondary data sources are aggregated and the StoreID dimension would be aggregated to "*". 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 . order_date = B. The problem is when I try to calculate the median of that same measure. I'm able to successfully connect to both data sources and set up the relationship, with the Teradata extract being primary and the Excel sheet being secondary. "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. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. When blending in Tableau, there is always a primary source and a secondary data source. 3) COUNTD with Secondary DS (Blending) Thanks,. If you create a quick filter on a field from data source 1 and apply this quick filter to. with blends, we are only able to support aggregates (like SUM, MIN, MAX. A datetime field in the primary data source, for example, will not blend with a date field in the secondary data source. 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. Here's the data blend view with the secondary data source selected so we can see what blend fields are used:. For more information, see Troubleshoot Data Blending; Blended data sources cannot be published as a unit. In my primary, I define another calculated field to do the aggregation for each project by tier: VendorClass: if max [Secondary]. Beyond that personally I tend to do the work necessary to avoid using data blending in production data sources & views. 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. 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. Thanks for your help everyone! I've found what was happening: I had some filters on the secondary data source. 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. 3. If I cant go the above way then is there a possibility to do the duration calculation using table calculations or some other way. ”. Mihai Constantinescu (Member) 6 years ago. 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. A datetime field may be converted to a date field using a calculation to remove the time. ×Sorry to interrupt. 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). The date values you want to blend on must exist in both data sources. However, some days will have entries for "Cost" but not for "Proj. I am trying to use the measures name filter functionality with two data sources. Cannot blend aggregated data from the secondary data source with the data on this sheet because there are no linking fields used in the view. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. Resolution. Make the field(s) used to address the table calculation active linking fields. In data source A, I have COUNTD(Person ID) and in data source B, I have COUNTD(Person ID). 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. 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. It throws me cannot blend secondary data source one or more becuase one or more fields use unsupported aggregation . In this case the cross. 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. 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. Call it [Start KM]: IF ATTR ( [KM Date])=ATTR ( [OIL]. Marked as. A secondary data source can be used to re-alias the field values in a primary data source. I have uploaded this dummy file since I cannot upload my real data here. In this case, I use Last() as a filter to hide the other rows except the last one and each LOD calculation and blended data sources. 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. if you have blended data sources you can not use lods One of the drawbacks of blended sources . Are use of grouped fields not allowed in data blending? I have two data sources: Opportunities and Products. I've blended on user ID. Hi . Change the default sort order of the field using the various options, and then click OK. If that does not help,. For example, sheet A uses data source 1 as the primary data source; sheet B uses data source 1 as the secondary data source. 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 . Blending your Data in Tableau. They must be in the same format. The order in which fields are used determines which data source is the primary versus the secondary data source. "Cannot blend the secondary data source because one or more fields use the == function, which cannot be computed locally. 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. You will need a common column between the two tables in order to blend. 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. Both Primary and Secondary data sources have duplicate rows due to multiple joins in data prep. [OIL DATE]) THEN MIN ( [KMs]) END. CSS ErrorI am trying to put my LOD calculation (below) on the rows shelf but encountering "cannot blend the secondary data source because one or more fields use an unsupported aggregation" {include [DATE. For example, sheet A uses data source 1 as the primary data source; sheet B uses data source 1 as the secondary data source. Ambiente. Use the geographic role in the primary data source on detail instead of the dimension from the secondary data source. " And after that I can't make my workbook work at all. " Filtering Across Multiple Data Sources Using a Parameter; Cause A sheet cannot be filtered by a field from a secondary data source. For more information, see Troubleshoot Data Blending; Blended data sources cannot be published as a unit. It does exactly what I need and I'm able to filter no problem at all using a different data source when working to a financial period level. The solution. When I do the join between the SSAS Tabular Model (primary data. Each has a joining field with the same name. Good morning @Fred Yu (Customer) . From what I can tell, joining on Tableau Server Data Sources has been a requested feature for 6 years (Idea: Ability to join Tableau Server data sources). Here is an example of what I am trying to accomplish:Data blending is a method for combining data from multiple sources. I receive this error: "Cannot blend the data source because one or more fields uses an unsupported aggregation". From my primary data source I have a dimension in columns say 'Customer Segment'. The primary data source will be identified automatically from any metrics you put on the worksheet first. I cannot able to use as one connection since am using the data source filter in my first connection have data source filter. 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. The Products set contain the individual products within an Opportunity whereas the Opportunities set contain Sales metrics (i. Chicken + Choice of Drink1 pc. then i added a secondary data source from google sheet , which has the fuel amount. This feature would be really useful to ensure we can. Verify if one of the measures coming from the cube data source has a default aggregation different than SUM, MIN, MAX, COUNT. Hello Tableau world!! Am running into the strangest problem when data blending with V8. 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. 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. 1, the ability to "Show Empty Rows" (or columns) was removed when you use a secondary data source. " Expand Post. 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. Another way to approach this is to do a join of the data outside Tableau via a federated data source. Loading. 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. Process for Creating the Dynamic “Parameter”. The secondary data source need to be my transaction file and primary data source need to be my budget file. Left. Hey all, I'm trying to create a filter in my dashboard such as my two spreadsheets are linked with this filter. You combine data in the logical layer using relationships (or noodles). I have two data sets that are linked across Date and Product Category fields. Secondary Data Source: Extract W. Drag the 2016 Population measure to the Columns. 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. 3) Select the now grey link next to the original field in. 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. 1. 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. Does anyone have any Ideas how I can apply a universal filter. Before I check Date filters, I got this results. twbx. In the Add/Edit Field Mapping dialog box, select the date fields from the primary and secondary data sources, and then click OK twice. Beginning with Tableau Desktop 2020. 1. Option 2: Create a calculation for a more dynamic sort. 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. Are you talking about Tableau Prep or Tableau Desktop? Any chance you can share a sample of your data? Expand Post. The condition is offer status = hired, but offer status can contain my different response types. The version I am working with 10. 3 and I have created aggregates AGG for fields from data extract and excel file. 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. 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. Non-additive engine are entirety functions that errichten outcomes that cannot be aggregated along a dimension. Date dimensions: For cube data sources, date dimensions are typically organized into hierarchies that contain levels such as year,. . I've attached my workbook that contains 2 data sources that are blended by invoice number. xls files). Thanks. Because in Tableau, you don't use COUNTD function when Blending data source. The version I am working with 10. AUMTable (Secondary) 3. Data blending is particularly useful when the blend relationship—the linking fields—need to vary on a sheet-by-sheet. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. I am using blending and created Relationship but i am having problem in terms of getting distinct count from one of the data sources. 5 3 . 4, I tried to blend products (secondary) to storefront (primary) based on Sku. I noticed that when the spatial file is the secondary data source, I cannot area plot it by double clicking the geometry variable. So make sure you're not using such function while blending. 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 . Cannot blend the secondary data source because one or more fields use the == function, which cannot be computed locally. To alias field values. I have three different data source . (I created calculated fields "Fiscal Year" and "Fiscal Month" on my secondary Superstore example to simulate this. 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. AUMTable (Secondary) 3. Secondary data source: spatial file containing the geometry. Tableau Desktop; Blended data; Soluzione Use the following workaround: Create a new worksheet. good morning you have blended your data sources - data from the secondary source always comes to the primary and an aggregate so Budg_date needs to be aggregate with min max or attr but that will probably not give you the result you expect the data from the secondary source will come over as an * if there is more than one date filtered from that. For more information, see Use Relationships for Multi-table Data Analysis. 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. * Blend in the summary of a large dataset to reduce query time. This happens only when the data sources are impala. ×Sorry to interrupt. This can help researchers identify. Upvote Upvoted Remove Upvote Reply. I'm blending the 2 data sources by Service_Id. e. 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. 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. Ritesh Bisht (Member) 6 years ago. 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. Both fields are linked in worksheet. Pick the secondary data source in of Secondary data source pane. 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. 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. In the Add/Edit User Mapping dialog crate, do the following: Select a select by the primary your data. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. I am trying to determine the Average Revenue per User by country for which my calculation is total revenue/unique subscribers. The success of BI projects depends on an organization's choice of BI solutions and the vendor’s ability to deliver relatively rapid and successful implementations, along with supportive. From Primary Data Source drag the measure names and measure values . ×Sorry to interrupt. To overcome this, I've added a filter straight into the data source and not in the view. Some examples include: cookies used to. While on a view, right click a data source, click replace data source. However when I use B as primary data source, drag [A]. I. I am trying using { FIXED : SUM[(portfolioValue)]}. Resolution. Fee" I want to plot Gross Profit (i. 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 Did some research on this and found plenty of "workarounds" with no success, because apparently blending sucks and I shouldn't be using it. It's a technical limitation. 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". Expand Post. 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. In the Data window, switch to the [data name2] data source. Please post you twbx workbook so we can see if there a way . Hi there, I got a question about how can I count distinct customer ID? I have 10k customer IDs, some of them appear more than once. The date values you want to blend on must exist in both data sources. 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. I have two data sets that are linked across Date and Product Category fields. Please find the complete blog here ----> COUNTD with secondary DS Tableau(Blending) Workbook is attached. Additional Information While replacing ATTR() with MIN() will cause "Automatic" grand totals to show, the grand totals might not be the expected values. 4. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. Hello Jim, Thank You for your reply. e. We are blending two data sources. You cannot change that. I have two data sources and I have blended them together. " Is there a way to circumvent this issue? Or perhaps a different method entirely. Using Tableau; Upvote; Answer. The "Create Primary Group" operation is bringing the dimension from the secondary into the primary, but it is static, and does not update when your data updates. E make table 2 the primary. From my primary data source I have a dimension in columns say 'Customer Segment'. The unsupported aggregation happens when your aggregate requires row-level visibility to the secondary 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,. " message. 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. e. How to rewrite my calculation to fix the error: cannot blend the secondary data source because one or more fields are use and unsupported aggregation. Twb, . e. BR, NBBlended data sources cannot be published as a unit. It sounds like there might be some complications with a blend? Can’t speak to what’s happening thereAre you blending on [Endtimestamp]? By using the formula DAY([Endtimestamp]), you're changing the dimensionality a little bit. This field works but when I want to add in my Fianl Dashboard I have this message "Cannot blend the secondary data source because one or more fields use an unsupported aggregation" Moreover my first and secondart data sources are linked by the "Sales ID", but this field is not displayed in the final Dashboard. 2) DB2 blending doesn't support non-additive aggregates like COUNTD() from secondary sources. Using existing secondary data sources can save researchers time and resources by providing access to pre-existing data that has already been collected and organized. I have two data sources which I have blended together on two fields: branch and date. Hi Justin, Thanks for your quick reply. 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. 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. I use the Opp ID to relate them. I was now trying to use both calculations you did on a different sheet through data blending. All Answers. According to Tableau, this error can also appear when using a LOD expression in a blended view. Therefore it cannot display null data. The date values must be in the same format. Does the. 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. We would like to show you a description here but the site won’t allow us. 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 . 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. 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". Loading. Another way to approach this is to do a join of the data outside Tableau via a federated data source. Now try to recreate the sheet and link the 2nd and 3rd data. I am trying to use the below formula instead of countd function because my data comes from Impala.