If this aggregation is ATTR() then the grand totals may be blank. Answer. 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. A data blend cannot filter on dimensions that do not exist in the Primary data source. Marked as. The version I am working with 10. I am using tableau 2020. Any existing, automatic blend kontakte is visible (and pot be deleted by suspend over the row and clicking the x). Ambiente. " Filtering Across Multiple Data Sources Using a Parameter; Cause A sheet cannot be filtered by a field from a secondary data source. For details, see Troubleshoot Data Blending. " Is there a way to circumvent this issue? Or perhaps a different method entirely. If the user select May 2018. Does the. I am blending dates in the secondary data source to dates from the primary source and looking to get a distinct count of the customer code from the secondary data source. since i want only offername from secondary source to the view and the measures are produced from primary datasource is pos_trn. 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. You can create a federated database using linked tables/worksheets. A datetime field may be converted to a date field using a calculation to remove the time portion. Blending from a polygon-based map to an existing data source which uses 1-to-many joins. Aside from consulting the primary origin or source, data can also be collected through a third party, a process common with secondary data. Primary and Secondary sources in data blending. Now try to recreate the sheet and link the 2nd and 3rd data. 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. 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. 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. I like to have the ability to swap a primary data source with a secondary data source for data blending in a workbook. Option 2: Create a calculation for a more dynamic sort. Hi All, I have blended primary and secondary data sources. 1) Duplicate the field in primary datasource. Data blending is particularly useful when the blend relationship—the linking fields—need to vary on a sheet-by-sheet. you will get 5/22 date. I made a waffle chart grid using an excel data source that contains 3 fields: Rows, Columns and Percentage. And I use Join data source, after divide measures / row duplicate. The reason your blend breaks is that you're blending with Location as a linking field, so when you remove that from your view, Tableau can't blend any longer. Observations : 1. "Cannot blend the secondary data source because one or more fields use the / function, which cannot be computed locally. In the Data pane, select the Store - North data source. Select Analysis > Create Calculated Field. I am confused, as I am not even trying to blend Data from both Data Sources. I'm trying to show a distinct count of claims by branch. 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. Good morning @Fred Yu (Customer) . ) So the issue is really the introduction of the group on the sheet. All three options are demonstrated in the attached workbook using the sample data set Superstore. Then try using the LOD expression from a secondary data source. ×Sorry to interrupt. General Information. To the Data pane, umschaltung in this [name of secondary data source] data source, real click at lowest one link icon to blend that data sources. I get error: “Cannot blend the secondary data source because one or more fields use an unsupported aggregation. 2. 2, Tableau introduces relationships and splits. Remove all dimensions from the secondary data source and ensure that the primary data source’s. 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. However, when I follow your advice, each group splits into 6 rows (one for each month - January through June). CSS ErrorAfter Blending, Now it is showing this error: Cannot blend the secondary data source because one or more fields use an unsupported aggregation. Verify if one of the measures coming from the cube data source has a default aggregation different than SUM, MIN, MAX, COUNT. Both fields are linked in worksheet. Chicken + Choice of DrinkBurger + Choice of DrinkSpaghetti + Choice of Drink . Hi Kurt! No, not really. with blends, we are only able to support aggregates (like SUM, MIN, MAX. Expand Post. Few things you need to keep in mind while blending data sources in tableau. e. I read that this is not possible. The blend applies to that worksheet only. If multiple logical tables are related in a Tableau data source that source cannot be used as the secondary data source in a Tableau data blend, it can only be used as the primary Therefore one workaround is the Create Primary Group function that you described which "copies" the field from B into A as a group. Cannot blend the secondary data source because one or more fields use an unsupported aggregation issue. Upvote Upvoted Remove Upvote Reply. ”. 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 since one or more search use certain unsupported aggregation. 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. To overcome this, I've added a filter straight into the data source and not in the view. In this case the cross database join will effectively act like the. The reason of the errors being unsupported calculation in blend. Upvote Upvoted Remove Upvote Reply. The two data sources are identical. The Products set contain the individual products within an Opportunity whereas the Opportunities set contain Sales metrics (i. 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. 1. Another sheet:W2 is created with Data source A - taking Role in Row shelf. I noticed there was an issue using Data Blend from 3 different source. Jim. FIXED ID, WEEK: CountD (accounts)). [amount] into the view, it gives less than. This would be a great time saver, with all of the calculations and linking changing as well. Instead of using relationships, double-click into your table to get to the. mdb which will be used to illustrate data blending. Thank you . In versions prior to 2020. The only workaround I can think of is to put the course code onto the level of detail shelf, but that means that what appear to be solid bars are actually stacked bars. I have just realised why the blending was not working. 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. 3 and I have created aggregates AGG for fields from data extract and excel file. 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. ). A datetime field in the primary data source, for example, will not blend with a date field in the secondary data source. 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. 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. Does anyone have any Ideas how I can apply a universal filter to 5 different unrelated data sources? Applies to: Tableau Cloud, Tableau Desktop, Tableau Server. The Products set contain the individual products within an Opportunity whereas the Opportunities set contain Sales metrics (i. The chart should display: countd. You combine data in the logical layer using relationships (or noodles). Instead, the. 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 am trying to use the below formula instead of countd function because my data comes from Impala. From my primary data source I have a measure in rows, say 'Measure, which is 'distinct count of Pol Number' or 'sum of Premium' depending on a boolean parameter's values (TRUE or FALSE) The unsupported aggregation happens when your aggregate requires row-level visibility to the secondary data source. Filtering data across a worksheet's secondary data source is not currently supported in Tableau Desktop. Data source A has Role Column and Data source B also has Role Column. 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. Set up the primary and. Blended data sources. But seems we cannot blend 2 secondary data source with same field. No. Effective visualization. One data source has some values, the other one has different values. So yes, in [Actual Hrs] you can only use the value from the secondary as an aggregate, and that's why you see: SUM([Networkdays (Test blend data calculation)]. Right-click in the Data window and then. I want to do a basic data listing showing customer, order no, postcode & vat exempt. Notice that Calc1 gives you an asterisk if there are multiple values returned from the secondary source. 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. Here is the sample. Expand Post. 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. Let say from DS1 if i am making it as primary datasource then i can get the. You cannot filter data across secondary data sources. Make the field(s) used to address the table calculation active linking fields. So if you drag Category from the Orders data source, it will automatically mark Orders as the primary data source. I have two data sets that are linked across Date and Product Category fields. Error “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. then i added a secondary data source from google sheet , which has the fuel amount. In blending data source, I try to slove problem but I can't. Viz cannot be filtered with secondary data source filter before loading the visualization so using "[DS_Name]. E make table 2 the primary. while data blending is a great feature for exploratory analytics and data validation and incredibly useful to have as an extra tool when nothing else will meet the requirements I find that there's a tradeoff with added. I am trying to create a waffle chart. Non-additive aggregates are aggregate functions that produce results that cannot be aggregated along a dimension. Required cookies are necessary for basic website functionality. 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. 4. I've attached my workbook that contains 2 data sources that are blended by invoice number. This type of bases does not allow for blend relationship, therefore, you cannot use a filter like this. I have the same issue, but Primary Data Source is a Tableau Server Data Source (I do not have direct access to the database), and Secondary Data Source is an excel flat file. In the Data pane, switch to the [name of secondary data source] data source, and click at least one link icon to blend these data sources. A datetime field in the primary data source, for example, will not blend with a date field in the secondary data source. Process for Creating the Dynamic “Parameter”. In the Data pane, switch until the [name of subsidiary datas source] data root, and click at least one link icon to blend these datas sourcing. The date values must be in the same format. When I create an additional calculated field in the primary data source with: COUNTD(Person ID) + COUNTD(Person ID), I receive the cannot blend the secondary data source because. I noticed that when the spatial file is the secondary data source, I cannot area plot it by double clicking the geometry variable. Currently, I have to rebuild the worksheet and bring in the secondary source first. Data blending brings in additional information from a secondary data source and. 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. " Expand Post. I have two data sets that are linked across Date and Product Category fields. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. Currently, data sources that contain logical tables cannot be used as secondary data sources for data blending. Size() is a great choice for unique counts across data sources if you can create a view where every unique row is displayed. - Data to Map from - Data to Map to . blending [cannot blend Measure Values from a secondary data source] -----> this approach failed . Relationships cannot be formed between tables from data sources published to Tableau Server or Tableau Online. CustomOverall (Primary) 2. I have three different data source . CSS ErrorIF user chooses month X and parameters/filters like gender/age/etc, THEN count all distinct users from data set #2 where the date of data set #2 is from 2017-08-01 through today's date. However, when the linking dimension is not in the view, non-additive aLoading. 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. A secondary data source can be used to re-alias the field values in a primary data source. {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. The unsupported aggregation happens when your aggregate requires row-level visibility to the secondary data source. The relationship is on the facility ID. ×Sorry to interrupt. 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. You can use data blending when you have data in separate data sources that you want to analyze together on a single sheet. 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. I have a primary data source coming from a published data extract blending with a secondary data source coming from an Oracle Database. Give the action a sensible name and configure the action. Calculates the number of distinct values of a field within a partition. Then you can simply show one filter control on your dashboard and set it to apply to all related data sources. In Tableau Desktop, navigate to Data > Edit Relationships. Dominic Laird(Member) 5 years ago. They cannot be used as secondary data sources. This feature would be really useful to ensure we can. 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. Data blend is like a Left outer join. In this source create a calculated field to pull out the KMs on the date of oil change. 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. 1. The syntax for calling secondary data source field is not. I'm using a data blending method, where: Primary data source: Contains the ID I'm trying to count. Unknown file type Total from Secondary Data Source. So you need to create a Date field in your Master Data Source, which is why I usedAlternative to CountD function in Blending. Data blending is a method for combining data from multiple sources. When trying to use COUNTD() it gives this error: cannot blend secondary data source because one or more fields use an unsupported aggregation when hovering over the Measures because it is now red. Tableau will throw an error: “Cannot blend the secondary data source because one or more fields use an unsupported aggregation. I have two data sources and I have blended them together. I can add to filters from the data extracts. I have quick filters from the primary data source and I am trying to represent distinct. Identify your data sources for common data types: both data sources must have a string or date field for linking data sources. 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. When Bugs History is a live connection to Vertica living inside my workbook all is well. 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". Before I check Date filters, I got this results. 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. 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. All Answers. Primary and Secondary sources in data blending. Whichever data source is used first in the view, becomes the primary data source and the second one to be used in the view is the secondary data source. Tableau Desktop & Web Authoring. In my primary, I define another calculated field to do the aggregation for each project by tier: VendorClass: if max [Secondary]. Your secondary data source does not have the blend activated, you'll need to click on the link and turn it red to activate:. 2 came the introduction of a brand-new data model. Hello Tableau world!! Am running into the strangest problem when data blending with V8. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. We use three kinds of cookies on our websites: required, functional, and advertising. Assuming that's what's going on, there's the question of how to work around this. Cannot blend the secondary data source because one or more fields use an unsupported aggregation" when Data Blending. ×Sorry to interrupt. Now you see a new group field listed in the Population data source (primary) called State (group). Beginning with Tableau Desktop 2020. unsupported aggregation. Maxdate) There is one more way, make the datasource which is using the fixed calculation to primary data source. You can choose whether functional and advertising cookies apply. See Join your Data for instructions. Date dimensions: For cube data sources, date dimensions are typically organized into hierarchies that contain levels such as year,. " I have seen a few posts on it and found an issue logged about it as far back as version 8. 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. They both share a common field (State), and that is what I'm filtering on. I am trying using { FIXED : SUM[(portfolioValue)]}. 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. Sometimes , it's automatically working but sometimes it says 'Unsupported Aggregation' . Currently, it's not working, the filter I try to add in the dashboard appears red in my spreadsheet and tells me that : "Data sources containing logical tables cannot be used as a secondary data source for data blending". (I created calculated fields "Fiscal Year" and "Fiscal Month" on my secondary Superstore example to simulate this. For example, select Analysis > Create Calculated Field, and in the Formula text box, type the. 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. To blend on summary data, you can do the following: Create a. Are use of grouped fields not allowed in data blending? I have two data sources: Opportunities and Products. on Rows, Columns, Pages, or the Marks Card. 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. 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). cannot blend aggregated data from the secondary data source with data on this sheet. Data blending is a method for combining data from multiple sources. Cube (multidimensional) data sources have certain characteristics that make them unique in Tableau. Upvote Upvoted Remove Upvote Reply. Filtering data across a worksheet's secondary data source is not currently supported in Tableau Desktop. T or F: Blends, unlike relationships or joins, never truly combine the data. [Field_Name]":"Value_to_filter" in the Options will not work. How to calculate Delta value. Consider joining the two data sources together using Tableau Prep, and then you can use that data as a. I have three different data source . I have two data sources which I have blended together on two fields: branch and date. So you don't get in the case of data blending. (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. Fields from the secondary data source used in the view have an orange tick. 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. There's no way to "swap. [tier] == 0 then "Low vendors" elseif max [Secondary]. Yes - you can't bring COUNTD in data blending. 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. The secondary data source just pulls in some names to associate with ID numbers in the primary and some filters for the staff data. 1. 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. LoadingWhen you try to add URL actions to dashboards, fields from secondary data sources cannot be added to the URL. Common warnings and errors when blending data sources No relationship to the primary data source. 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. In the formula text box, type the ZN function, the SUM. 1. - Dataset 1, records the amount spent on ads as "Cost" - Dataset 2 records the revenue generated by orders as "Proj. There's a set of views/calcs that show a metric, (metric C) counting distinct number of accounts contacted per person per week (e. When blending in Tableau, there is always a primary source and a secondary data source. Observations : 1. 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. For more information, see Troubleshoot Data Blending; Blended data sources cannot be published as a unit. 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. ) A LOD calc is also trying to do stuff at the row level. ×Sorry to interrupt. The data are sorted, but each row only shows one month of data with the other five columns blank. You must double-click a logical table in the Data Source page canvas to go to the physical layer of the canvas. 4. "Cannot blend the secondary data source because one or more fields use the == function, which cannot be computed locally. 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. Maxdate) There is one more way, make the datasource which is using the fixed calculation to. I'm using a cube data source as my primary and am attempting to blend with. When I then published this to server as an extract, then tried to blend it with the first data set I get this error: 2013-10-15_15-03-01. This happens only when the data sources are impala. 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). 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. 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. This means a data blend can’t be published as a data source for others to use. For more information,. The data is blended on customer. 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. You cannot filter data across secondary data sources. e. I have 2 data sources, A and B, they are linked by data blending with A. I need to get a count distinct of Patient ID from the Primary data source, as well as count distinct of Patient ID from the Secondary data source in one worksheet. I cannot change the case of the data to upper or lower. Community Manager update. While on a view, right click a data source, click replace data source. But there are few workaround for it. Secondary data source has Order Date represented as separate Year and Month fields. 1) Vizible Difference: Getting around Count Distinct in a secondary data source. One approach that succeeds in adding another measure is to add the measure in question to your. Data blending is particularly useful when the blend relationship—the linking fields—need to vary on a sheet-by-sheet. But the source calc is a countD. Please find the complete blog here ----> COUNTD with secondary DS Tableau(Blending) Workbook is attached. I tried to recreate the data as close as possible. Try one of the following options, as appropriate for your workbook: It may be possible to cross database join instead of blending. Data blending has some limitations regarding non-additive aggregates such as COUNTD, MEDIAN, and. For more information, see Troubleshoot Data Blending; Blended data sources cannot be published as a unit. 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 . I can't do a join because they are two different file formats. I have a Remaining Value calculation, but it is not correct. CustomOverall (Primary) 2. Thank you. Status, Stage, etc). If you are blending a cube data source, it must be the primary data source. However, I still get that message saying cannot blend the secondary data source because one or more fields use an unsupported aggregation". Data blending is a method for combining data from multiple sources. Hi Justin, Thanks for your quick reply. I have two data sources and doing a data blend. Step 2: Make it a context filter. 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. For example, sheet A uses data source 1 as the primary data source; sheet B uses data source 1 as the secondary data source. Step 1: Create the Parameter. . Option 2: Create a calculation for a more dynamic sort. 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. Please post you twbx workbook so we can see if there a way . Hello Jim, Thank You for your reply. Here are the 7 major steps for putting this together: Set up your primary (main) and secondary (parameter) data sources. I have been working on Blending feature for a while in different situations and. FIXED requires that you have row-level access to the rows in the secondary source. I am trying to use the below formula instead of countd function because my data comes from Impala. Are use of grouped fields not allowed in data blending? I have two data sources: Opportunities and Products. This means that when a cube data source is published, you cannot make a connection from Tableau Server using the data source. AUMTable (Secondary) 3. Resolution. We are blending two data sources. . This can help researchers identify. Data blending; Table Calculations; Resolution Use one of the following workarounds: If possible, join instead of blend your data. See Join Your Data for more information. From what I understand, it's because the link variable must be present in the view, or else it does not work. All data from a secondary source comes back as an aggregate -- even if there is only one value from the secondary source. Someone in the Community told me the following: "MAX isn't supported in. The. 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. So, in the dummy data, there are two tables from two data sources. 3) COUNTD with Secondary DS (Blending) Thanks,. Fields from the secondary data source used in the view have an orange check mark. 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. 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. Data blending is particularly useful when the blend relationship—the linking fields—need to vary on a sheet-by-sheet. Now, in dashboard D1 : has two worksheets W1 and W2. According to Tableau, this error can also appear when using a LOD expression in a blended view. 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. Ritesh Bisht (Member) 6 years ago. 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. Create a “Blend Field” with a value of 1 in both your primary and secondary.