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 . Additional Information While replacing ATTR() with MIN() will cause "Automatic" grand totals to show, the grand totals might not be the expected values. Effective visualization. Upvote Upvoted Remove Upvote Reply. Data blending: Cube data sources can only be used as the primary data source for blending data in Tableau. Blended data sources. [tier] == 0 then "Low vendors" elseif max [Secondary]. Some examples include: cookies used to. The unsupported aggregation happens when your aggregate requires row-level visibility to the secondary data source. âCannot blend the secondary data source because one or more fields use an unsupported aggregation. e. Applies to: Tableau Cloud, Tableau Desktop, Tableau Server Data blending is a method for combining data from multiple sources. {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. Make sure that you are blending on dimensions present in the view or on. month([date])=month(Parameter. I am trying to use the measures name filter functionality with two data sources. Selected as Best Selected as Best Upvote Upvoted Remove Upvote 1 upvote. Primary Data Source: Contains a list of all employees and their role. Expand Post. Fields from the secondary data source used in the view have an orange check mark. As 'Group' is from a secondary data source, I cannot simply use the sort buttons. 4, I tried to blend products (secondary) to storefront (primary) based on Sku. I have two data sets: the first data set is a shp file from data. I'm trying to show a distinct count of claims by branch. Become a Better Analyst in Just 5 Minutes a Week. Select Analysis > Create Calculated Field. blending takes place in step 6 of the Order of Operation after all the context and dimension filters have been applied - you will not be able to filter across the data sets after that point - you would need to have joined data or use a relationship The issue comes when I try and add a metric that is an aggregate of the two different sources. LoadingWhen you try to add URL actions to dashboards, fields from secondary data sources cannot be added to the URL. Identify your data sources for common data types: both data sources must have a string or date field for linking data sources. 0 but was disabled (greyed out) in 8. Primary Data Source: Extract S. The primary data source will be identified automatically from any metrics you put on the worksheet first. 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. Tableau Desktop 2018. 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. with blends, we are only able to support aggregates (like SUM, MIN, MAX. The unsupported aggregation happens when your aggregate requires row-level visibility to the secondary data source. Cube data sources do not support pass-through connections. 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. 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. Twbx and also the . "Cannot blend data from the secondary data source with the data on this sheet because there are no linking fields used in the view" Expand Post. 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). IF ATTR([Offer Status]) = "Hired" Then AVG([Comp_File]. If I cant go the above way then is there a possibility to do the duration calculation using table calculations or some other way. For more information, see Deciding Between Joining Tables and Blending Data. 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. I didn't realize this until now, but it appears you cannot use blending when one of your data sources uses the new(ish) relationship model. Yes - you can't bring COUNTD in data blending. 3 and I have created aggregates AGG for fields from data extract and excel file. One of the Dimension which is part of the Relationship between Primary and Secondary Data Source is being used in Filter and the same field cannot be displayed in Report as it changes the Level of grain of the reportIm using two data source to develop the workbook. 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. E make table 2 the primary and table. Both fields are linked in worksheet. 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. A datetime field may be converted to a date field using a calculation to remove the time portion. then i added a secondary data source from google sheet , which has the fuel amount. To overcome this, I've added a filter straight into the data source and not in the view. Cannot blend the secondary data source because one or more fields use the == function, which cannot be computed locally. đ„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. I am trying to blend the same data against the other because I wanted to show Same Period last Year. 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. In data source A, I have COUNTD(Person ID) and in data source B, I have COUNTD(Person ID). Data blending is particularly useful when the blend relationshipâthe linking fieldsâneed to vary on a sheet-by-sheet. e. "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. order_date = B. 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". But I cannot for the life of me comprehend why the data blending would behave differently based solely on the chart type that was selected. In the Data window, switch to the [data name2] data source. Data blending is particularly useful when the blend relationship. We would like to show you a description here but the site wonât allow us. Hi All, I have blended primary and secondary data sources. In blending data source, I try to slove problem but I can't. Cannot blend the secondary data source because one or more fields use an unsupported aggregation Itâs cable reimagined No DVR space limits. To blend on summary data, you can do the following: Create a. 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. In the data window, switch to [name1] data source, and click at least one link icon to blend these data sources. Here is the sample. "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. For more information, see Troubleshoot Data Blending; Blended data sources cannot be published as a unit. Step 1: Create the Parameter. Blending runs a query on each data source and joins the aggregated results of those queries. I have 2 published datasource and i think i cannot perform JOIN, LOD and COUNTD. 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. Pick the secondary data source in of Secondary data source pane. I made a waffle chart grid using an excel data source that contains 3 fields: Rows, Columns and Percentage. Data blending is particularly useful when the blend relationshipâthe linking fieldsâneed to vary on a sheet-by-sheet. Relationships cannot be formed between tables from data sources published to Tableau Server or Tableau Online. So, to do Data Blending, the steps that I would suggest would be: - Connect to the data sources that you need to use. Select Default Properties > Sort. xls files). I receive this error: "Cannot blend the data source because one or more fields uses an unsupported aggregation". Set up the primary and. The two data sources are identical. Try one of the following options, as appropriate for your workbook: It may be possible to cross database join instead of blending. This feature would be really useful to ensure we can. Hi Data Modeler , I have an idea which I cannot test right away. Filter not recognizing blend relationship. the blend relationship is defined on driver Code, and working fine when adding both basicSalary (from main data source) and fuel (from secondary) to the sheet. 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. It's a technical limitation. The aggregation is all on primary source data. Then try using the LOD expression from a secondary data source. In the attached file, table shows the sum of sales and first order date correctly from both the. 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. Error âCannot blend the secondary data source because one or more fields use an unsupported aggregation. CustomOverall (Primary) 2. See. For more information,. I am trying to determine the Average Revenue per User by country for which my calculation is total revenue/unique subscribers. Option 2: Join tables that are in the same data source, instead of blending them. Does anyone know if there is a way around this or can you only create a blending whit datasources that were created the same way? I appreciate your help. I am able to achieve the desired results but I am getting a warning ' Fields cannot be used from the [name of secondary data source] data source, because there is no blend relationship to the primary data source. Hi Andy, Following up on this - Tableau has been promoting the jump to relationships, in place of joins. 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". Dominic Laird(Member) 5 years ago. I am getting Cannot blend secondary data source because one or more fields used an unsupported aggregation. 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. Instead, publish each data source separately (to the same server) and then blend the published data sources. A datetime field in the primary data source, for example, will not blend with a date field in the secondary data source. So you don't get in the case of data blending. Upvote Upvoted Remove Upvote Reply. This functionality was available in versions 8. It would be nice if when you blend two data sources, you could have the option to show "Only Relevant Values" on filters used from the secondary data source. I have three different data source . The version I am working with 10. See Troubleshoot Data Blending - Tableau for more information on this and other errors that may occur while using data blending. Option 2: Join tables that are in the same data source, instead of blending them. 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. Mihai Constantinescu (Member) 6 years ago. Fixed, countd functions won't work with the secondary datasources. The version I am working with 10. Build whatever calculated fields from the secondary that need to be used in in the primary. 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. The order in which fields are used determines which data source is the primary versus the secondary data source. Select Default Properties > Sort. I have three different data source . As 'Group' is from a secondary data source, I cannot simply use the sort buttons. 2 and later. However, when I follow your advice, each group splits into 6 rows (one for each month - January through June). In the Data pane, select the Store - North data source. And I use Join data source, after divide measures / row duplicate. Remove all dimensions from the secondary data source and ensure that the primary data sourceâs linking field is in view. cannot blend secondary data source because one or more fields use an unsupported aggregation beacuse of LOD. According to Tableau, this error can also appear when using a LOD expression in a blended view. I can get all the fields into the view apart from the 'is vat exempt'. While on a view, right click a data source, click replace data source. LOD (exclude) - Filtering using a different data source I've used LOD (exclude) to create a % of total calc field (and then created a moving average off that). 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 . and tried to plot chart, the chart complains that "Data sources that contain logical tables cannot be used as secondary data sources for data binding". Option 2: Create a calculation for a more dynamic sort. How ever # no of changes and # of Problems are calculating entire database values. Loading. 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. Non-additive aggregates are aggregate functions that produce results that cannot be aggregated along a dimension. All three options are demonstrated in the attached workbook using the sample data set Superstore. Both Primary and Secondary data sources have duplicate rows due to multiple joins in data prep. CSS ErrorBy default Tableau Desktop wraps fields from a secondary data source in an aggregation in calculated fields. You can choose whether functional and advertising cookies apply. If you want to filter data across secondary data sources, consider. In Tableau Desktop, navigate to Data > Edit Relationships. Aggregate the date fields at the MY. Data blending is a method for combining data from multiple sources. 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. Option 2: Create a calculation for a more dynamic sort. Blending takes place in the 6th step of the order of operation after the data table for the individual worksheet is set and the filters applied - data from the secondary source are aggregated at the level of the link and brought to the primary as. I am trying using { FIXED : SUM[(portfolioValue)]}. I have a calculated field in the Excel data source that returns a binary 1 if the username matches the list in Excel for the facility ID and a 0. IF min([Current Period ]) = true then [Display Sum Media Cost] end / sum(IF [Current Period ] = true then. Blending your Data in Tableau. 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 . Verify if one of the measures coming from the cube data source has a default aggregation different than SUM, MIN, MAX, COUNT. 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. 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). Primary and Secondary sources in data blending. For details, see Troubleshoot Data Blending. 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). Think of this layer as the Relationships canvas in the Data Source page. To solve your issue you should ->go to Connections 2 , keep only facADP and remove all other relationships ->go to its physical layer (double click facADP)Two Data Sources A and B, one work sheet:W1 has used both this A and B to represent View. If I cant go the above way then is there a possibility to do the duration calculation using table calculations or some other way. Resolution. See Join Your Data for more information. FIXED requires that you have row-level access to the rows in the secondary source. The condition is offer status = hired, but offer status can contain my different response types. CSS ErrorData blending is based on two key components- Primary data sources and Secondary data sources. It also means you cannot create a workbook using the. Data blending; Table Calculations; Resolution Use one of the following workarounds: If possible, join instead of blend your data. Please see if it helps , here it says that problem is with COUNT & they have provided one alternative way as well . Overall LOD will show correct result in Primary datasource. ) A LOD calc is also trying to do stuff at the row level. General Information. Upvote. Fee". They must be in the same format. data source. Expand Post. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. ×Sorry to interrupt. In the formula text box, type the ZN function, the SUM. Functional cookies enhance functions, performance, and services on the website. Secondary data sources cannot have logical tables (except when they satisfy specific conditions). 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. The date values must be in the same format. Expand Post Using TableauThe secondary data source is indicated with an orange check mark on the data source and an orange bar down the side of the Data pane. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. For secondary data source you get same result by managing relationships in your case just Area and Qtr. In your 2nd and 3rd data sources. 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. If there is another. If you want to make sure you don't lose any measures from the secondary source then either. Please check the attached workbook for details. General Information. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. We don't get row-level data from secondary sources on a. There are a few possibilities: 1) Flip the blend so the primary is secondary and vice versa. Filter each of the data sources independently on the more granular dimensions. In the Add/Edit Field Mapping dialog box, select the date fields from the primary and secondary data sources, and then click OK twice. AUMTable (Secondary) 3. We can see these by activating secondary data source and looking at the dimensions window, the linking dimensions will have an orange chain icon. Data blending has some limitations regarding non-additive aggregates such as COUNTD, MEDIAN, and. Assuming that's what's going on, there's the question of how to work around this. We use three kinds of cookies on our websites: required, functional, and advertising. Secondary data is one of the two main types of data, where the second type is the. But seems we cannot blend 2 secondary data source with same field. I have two data sets that are linked across Date and Product Category fields. 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 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. Can anybody please help me with a solution. Data blending brings in additional information from a secondary data source and. You combine data in the logical layer using relationships (or noodles). So make sure you're not using such function while blending. Because there are no linking fields in this view. Data. newBranchProjection (Secondary) When I try to add COUNTD([DistrictId]) from my primary to text table. Fee" I want to plot Gross Profit (i. I cannot change the case of the data to upper or lower. A secondary data source can be used to re-alias the field values in a primary data source. I like to have the ability to swap a primary data source with a secondary data source for data blending in a workbook. Data blending is a good option when you have multiple data sources that cannot be combined through relationships. Also I see that if you put [Corrected Date] from the primary source instead of the secondary source, it behaves with the group (and the calc. I tried data blending keeping File C as primary and A & B as secondary data source with DD number as relationship. 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. When blending in Tableau, there is always a primary source and a secondary data source. . You can create a federated database using linked tables/worksheets. If that does not help,. I am using tableau 2020. Instead, publish each data source separately (to the same server) and then blend the published data sources. The secondary data source will have an orange checkmark on it. Instead, publish each data. In this case the cross. 1) Duplicate the field in primary datasource. In the data window, the blue tick indicates the Primary data source (Sales in the image below). But the source calc is a countD. Please check the attached workbook for details. 2. you are blending the 2 excel data sources - blending takes place after the structure for data table for the worksheet has been established - and that is done as you bring dimensions to the rows and columns and apply filters to those dimensions - you will not be able to filter across data sources except at the link after that pointđĄ Ability to switch primary and secondary data sources. For more information, see Troubleshoot Data Blending; Blended data sources cannot be published as a unit. Hi . I get a blank sheet on the dashboard using the secondary data source because it looks for CASE SENSITIVE ABC . BR, NBBlended data sources cannot be published as a unit. 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. If you make sheet 1 as the primary data source and do the data blending with sheet 2. 3) COUNTD with Secondary DS (Blending) Thanks,. Modify the calculation to not use table functions;. Upvote Upvoted Remove Upvote Reply. Your secondary data source does not have the blend activated, you'll need to click on the link and turn it red to activate:. Change the default sort order of the field using the various options, and then click OK. ×Sorry to interrupt. "Filtering Across Multiple Data Sources Using a Parameter; Cause A sheet cannot be filtered by a field from a secondary data source. I am trying to blend the same data against the other because I wanted to show Same Period last Year. In your case, you're after the Total Cases by Employee, so just imagine Employee in place of Category. Loading. It says, "fields cannot be used from [data name] data source, because there is no relationship to the primary. I've blended on user ID. 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. In this example, Superstore Sales is the primary data source and Coffee Chain is the secondary data source. Does anyone have any Ideas how I can apply a universal filter. 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. Using Tableau; Upvote; Answer. One approach that succeeds in adding another measure is to add the measure in question to your. This is the final step and will result in filtering between the blended data sources at your desired level of granularity. In the Add/Edit User Mapping dialog crate, do the following: Select a select by the primary your data. Any help would be appreciated!Also a data blend is only a LEFT join. I was now trying to use both calculations you did on a different sheet through data blending. please check the attached workbook. you get all data from main data source and ONLY matching data from secondary data source. Answer. If I remove the blend, I cannot use/filter the secondary data source, and If I use the blend, it will display only the values for the first data source, but not from the second one. Hello Jim, Thank You for your reply. This means a data blend canât be published as a data source for others to use. " The only fields used in the view are the date fields, to which I did a . Cannot blend the secondary data source because one or more fields use an unsupported aggregation. Not able to share for time being. The data are sorted, but each row only shows one month of data with the other five columns blank. Instead, the. g. I am trying to . Currently, data sources that contain logical tables cannot be used as secondary data sources for data blending. Data blending is used when the linking fields need to vary on a sheet-by-sheet basis for different visualizations. I am confused, as I am not even trying to blend Data from both Data Sources. I am trying to determine the Average Revenue per User by country for which my calculation is total revenue/unique subscribers. We don't get row-level data from secondary sources on a blend. However, if you do a full outer join on [Dimension] = [Dimension] then we can know which records match up, and do a calculation like:I like to have the ability to swap a primary data source with a secondary data source for data blending in a workbook. The date values you want to blend on must exist in both data sources. When you data changes, you need to redo the. 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. 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 . Loading. CSS ErrorHi Mavis Liu. Note: If the geographic role does not exist in the primary data source, then it will be necessary to create the view with the data source that contains the geographic role as the primary data source. I have just realised why the blending was not working. 2) Use this duplicate field in the view instead of the original. In the Data pane, select the State data source (secondary). When I try to graph the distinct count of project ids vs the VendorClass, however, I see every project getting the. 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". Sometimes , it's automatically working but sometimes it says 'Unsupported Aggregation' . The concept of data blending is, for every match in the primary table there should be exactly one row item in your secondary table, in the view of this concept any aggregation on the secondary table will always be distinct by default. Fields cannot be used from the [name of secondary data source] data source, because there is no blend relationship to the primary data source. 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 . The reason of the errors being unsupported calculation in blend. 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. 1, the ability to "Show Empty Rows" (or columns) was removed when you use a secondary data source. Call it [Start KM]: IF ATTR ( [KM Date])=ATTR ( [OIL]. 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. 1 because it can cause Tableau to unexpectedly quit. Maxdate) There is one more way, make the datasource which is using the fixed calculation to. It is important to understand which is the primary source, it can impact your view. Remove all dimensions from the secondary data source and ensure that the primary data sourceâs. "Data Sources that contain logical tables cannot be used as secondary data sources for blending". The secondary data source consists of 1 Fact table (Agg_ActualVsExpected) and 4 Dim tables, one of the Dim tables is Dim_Service, whose primary key is Service_Id, which appears also in the Fact table. Data blending works only as a left join. (I created calculated fields "Fiscal Year" and "Fiscal Month" on my secondary Superstore example to simulate this. Hello Jim, Thank You for your reply. The data source with the KMs is the primary source. 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. AUMTable (Secondary) 3. When blending in Tableau, there is always a primary source and a secondary data source. 2) Use data source filters instead of the Filters Shelf. In addition, you cannot blend Measure Values from a secondary data-source, so that rules out this approach as well. 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. You cannot filter data across secondary data sources. LOD will not work if it is from the secondary datasource. 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). 4. drag the secondary measures to measure values section . 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. I have a primary data source coming from a published data extract blending with a secondary data source coming from an Oracle Database. 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. Data blending is particularly useful when the blend relationshipâthe linking fieldsâneed to vary on a sheet-by-sheet. So, in the dummy data, there are two tables from two data 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. Some examples include: session cookies needed to transmit the website, authentication cookies, and security cookies. A Level of Detail (LOD) expression is being taken from the secondary data source. Reference line -----> in this approach able to show sub-category items measures like sales and quantity totals as reference lines shown in below figure . When on the dashboard, click on the âDashboardâ drop-down and select âActionsâ. To reduce query times when working with a large data source like Store - South, you can use data blending to blend only on the summary data of the large secondary data source (Store - South) with the data in the smaller and presumably faster primary data source (Store - North). Summary:. Chicken + Choice of DrinkBurger + Choice of DrinkSpaghetti + Choice of Drink . 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 data blend cannot filter on dimensions that do not exist in the Primary data source. [% age]>=SUM([Percentage]) . Let say from DS1 if i am making it as primary datasource then i can get the. Proj. If I cant go the above way then is there a possibility to do the duration calculation using table calculations or some other way. If one of those measures is brought into a view with a linking dimension not in the view, or a linking dimension is turned on that is not in the view, the pill will turn red, the view will turn grey, and hovering over the pill reveals a "Cannot blend the secondary data source because one or more fields use an unsupported aggregation. the count of claims I'm getting from the secondary data source, by counting distinctly a measure called claimid. Tableau v8 added a new style of data blending (DB2) where the linking field does not have to be in the view. CSS ErrorLoading. Left. Option 1: Join the data sources with a cross-database join instead of blending. I have two data sources which I have blended together on two fields: branch and date. One data source has some values, the other one has different values. ×Sorry to interrupt. Another table is a a table that contains key fields such as date, region, location and hardware id (dimension). the branch field I'm using from the primary data source. Now, in dashboard D1 : has two worksheets W1 and W2.