- 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. Make the data source that contains the field that you want to use in the URL action the primary data source in. Let say from DS1 if i am making it as primary datasource then i can get the. the count of claims I'm getting from the secondary data source, by counting distinctly a measure called claimid. I establish the blend relationships explicitly by going to Data -->Edit Blend Relationships, and selecting the fields that should be related. I am trying to determine the Average Revenue per User by country for which my calculation is total revenue/unique subscribers. Filtering data across a worksheet's secondary data source is not currently supported in Tableau Desktop. 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. 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). 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. Reference line -----> in this approach able to show sub-category items measures like sales and quantity totals as reference lines shown in below figure . Expand Post. ×Sorry to interrupt. Hello Ritish, You could use Size() and a Las() function as a filter and get the same output. In the past, I've just changed my primary table to the one with the calculation. i. I get a blank sheet on the dashboard using the secondary data source because it looks for CASE SENSITIVE ABC . Instead, publish each data source separately (to the same server) and then blend the published data sources. 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. Observations : 1. You combine data in the logical layer using relationships (or noodles). "Filtering Across Multiple Data Sources Using a Parameter; Cause A sheet cannot be filtered by a field from a secondary data source. Size() is a great choice for unique counts across data sources if you can create a view where every unique row is displayed. Instead, publish. month([date])=month(Parameter. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. Data blending is a good option when you have multiple data sources that cannot be combined through relationships. Cannot blend the secondary data source because one or more fields use an unsupported aggregation . Seemingly simple task is getting complicated in Tableau . In this case the cross database join will effectively act like the. Does the. The version I am working with 10. CustomOverall (Primary) 2. I'm blending the 2 data sources by Service_Id. 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. I've attached my workbook that contains 2 data sources that are blended by invoice number. 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). 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. 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. I am trying to determine the Average Revenue per User by country for which my calculation is total revenue/unique subscribers. However, when I follow your advice, each group splits into 6 rows (one for each month - January through June). 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. Data blending is particularly useful when the blend relationship—the linking fields—need to vary on a sheet-by-sheet. 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. For more information, see Use Relationships for Multi-table Data Analysis. When you blend, you can only have aggregate access to the rows in the secondary source. I have quick filters from the primary data source and I am trying to represent distinct. This is indicated by the following icon: The view you are trying to build will function if you use the date from the primary data source (Shipped): Let us know if this is clear, or if more explanation is required! Cheers, TimothyCube data sources are used as primary data sources to blend data in Tableau and cannot be used as secondary data sources. Date dimensions: For cube data sources, date dimensions are typically organized into hierarchies that contain levels such as year,. In the secondary data source, select Data > Create Calculated Field. From Primary Data Source drag the measure names and measure values . Secondary data source: (excel) master zip file with ~40k rows (all US zips) - each zip is tied to a territory I am looking to add the territories from the master zip to territory file as a filter. 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. In the secondary data source, select Data > Create Calculated Field. I am using blending and created Relationship but i am having problem in terms of getting distinct count from one of the data sources. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. An orange tick indicates a secondary data source (Promotions). 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 . You must double-click a logical table in the Data Source page canvas to go to the physical layer of the canvas. Filtering data across a worksheet's secondary data source is not currently supported in Tableau Desktop. I am trying using { FIXED : SUM[(portfolioValue)]}. 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. unsupported aggregation. ” We use three kinds of cookies on our websites: required,. In the Add/Edit Field Mapping dialog box, select the date fields from the primary and secondary data sources, and then click OK twice. Data > Edit Relationships . Using Tableau; Upvote; Answer. They must be in the same format. Resolution. I can get all the fields into the view apart from the 'is vat exempt'. We use three kinds of cookies on our websites: required, functional, and advertising. We cannot use ATTR if trying to create an LOD type calculation if blending data sources. The date values must be in the same format. 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. 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. Option 2: Create a calculation using WINDOW_SUM() Drag the linking field(s) from the secondary data source to. then i added a secondary data source from google sheet , which has the fuel amount. Loading. 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. Therefore it cannot display null data. ). The data is tracked at the subsite level, so I've utilized LOD calculations to determine the min login time and the max logout time fixed on the site level. ×Sorry to interrupt. IF min([Current Period ]) = true then [Display Sum Media Cost] end / sum(IF [Current Period ] = true then. If you want to filter data across secondary data sources, consider. 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. Excel . I cannot change the case of the data to upper or lower. (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. Expand Post. [amount] into the view, it gives less than. You have a nice example to use for filing a support case, and I recommend that you do that. 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" Because of this, our overall. Nitish Pamarty (Member) 7 years ago. You can create a federated database using linked tables/worksheets. In versions prior to 2020. The data source with the KMs is the primary source. The blend is not activated meaning a field from secondary DS is not used in the view. Proj. , it's difficult to determine; however, what you could do is click on each data source and if you see a chain link that is solid and not broken where fields might be related/blended in the tables below, then click the icon to unlink it. For example, COUNTD(). you will get 5/22 date. This happens only when the data sources are impala. In the Add/Edit User Mapping dialog crate, do the following: Select a select by the primary your data. [% age]>=SUM([Percentage]) . Use blends when:. 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. Thanks bharat ! but i think client column is common to both the source so i would able to blend the data. This feature would be really useful to ensure we can. 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. 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. 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. {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. Expand Post. CSS ErrorAfter Blending, Now it is showing this error: Cannot blend the secondary data source because one or more fields use an unsupported aggregation. I tried data blending keeping File C as primary and A & B as secondary data source with DD number as relationship. I have three different data source . Thank you . In second data source i don;t have salesrep column. We cannot publish a blended data source as a single data source on the server. 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 . 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. Ritesh Bisht (Member) 6 years ago. " message. COUNTD is tough to work on while you. To alias field values. Fields cannot be used from the [name of secondary data source] data source, because there is no blend relationship to the primary data source. Upvote Upvoted Remove Upvote Reply. I. Instead, publish each data source separately (to the same server) and then blend the published data sources. You cannot filter data across secondary data sources. According to Tableau, this error can also appear when using a LOD expression in a blended view. The two data sources are identical. order_date = B. then i added a secondary data source from google sheet , which has the fuel amount. "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. order_date. I am blending (2) data sources based on the date. I have two data sets that are linked across Date and Product Category fields. 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. Chicken + Choice of DrinkBurger + Choice of DrinkSpaghetti + Choice of Drink . 3) COUNTD with Secondary DS (Blending) Thanks,. Ambiente. If I cant go the above way then is there a possibility to do the duration calculation using table calculations or some other way. You cannot change that. I have 2 separate data sources that have similar fields. Please attach. In your workbook sheet2 does not contain 5/22 date. Please find the complete blog here ----> COUNTD with secondary DS Tableau(Blending) Workbook is attached. We use three kinds of cookies on our websites: required, functional, and advertising. We have a calculated filed where an aggregation (COUNTD) is done on a filed of secondary data source. Just aggregates (like SUM, MIN, MAX. Please refer the below link and let me know if this helps to you. Complex as the problem may be, the solution is comfortingly simple. Use a parameter with a calculated field to filter the secondary data source at the row level. 0 but was disabled (greyed out) in 8. You combine data in the logical layer using relationships (or noodles). Data blending is a method for combining data from multiple sources. All Answers. I am blending 2 data sets by employee id and when i am trying to group a field from the primary database, it is showing me below error: Cannot blend the secondary data source because one or more fields use an unsupported aggregation. Loading. I get error: “Cannot blend the secondary data source because one or more fields use an unsupported aggregation. If you have to have row-level access on a. Any help would be appreciated!Also a data blend is only a LEFT join. 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. * Supplemental data from a secondary data source is needed. This link might help you: Cannot blend the secondary data source because one or more fields use an unsupported aggregation. The condition is offer status = hired, but offer status can contain my different response types. You want to apply a filter to related data sources - which is an option if multiple data sources have a field with the same name and data type, or if you define explicit relationships between data sources from the Data menu. I cannot able to use as one connection since am using the data source filter in my first connection have data source filter. ×Sorry to interrupt. Jim. The secondary data source need to be my transaction file and primary data source need to be my budget file. 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. FIXED requires that you have row-level access to the rows in the secondary source. 4. 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. Blending from a polygon-based map to an existing data source which uses 1-to-many joins. When I try to graph the distinct count of project ids vs the VendorClass, however, I see every project getting the. Because there are no linking fields in this view. “Cannot blend the secondary data source because one or more fields use an unsupported aggregation. id, A. 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. 1, the ability to "Show Empty Rows" (or columns) was removed when you use a secondary data source. Are use of grouped fields not allowed in data blending? I have two data sources: Opportunities and Products. Calculates the number of distinct values of a field within a partition. When on the dashboard, click on the ‘Dashboard’ drop-down and select ‘Actions’. If I cant go the above way then is there a possibility to do the duration calculation using table calculations or some other way. In order to create the waffle chart I am blending it with another datasource using the calculated field defined as [Week 5 (Week5Bond)]. Data blending have some limitations regarding non-additive total such like COUNTD, MEDIAN, and RAWSQLAGG. 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" Attached is the workbook that could provide more clarity on my question. Hi All, Is there a way to use a parameter to work for secondary data source in blending. Hope this helps kindly mark this answer as correct or helpful so that it will help others . Fields from the secondary data source used in the view have an orange check mark. 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. If that does not help,. I noticed that when the spatial file is the secondary data source, I cannot area plot it by double clicking the geometry variable. " And after that I can't make my workbook work at all. Step 1: Create the Parameter. 💥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. This functionality was available in versions 8. 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. I have a primary data source coming from a published data extract blending with a secondary data source coming from an Oracle Database. For details, see Troubleshoot Data Blending. 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. Drag the 2016 Population measure to the Columns. The chart should display: countd. Primary Data Source: Contains a list of all employees and their role. So, to do Data Blending, the steps that I would suggest would be: - Connect to the data sources that you need to use. 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. CSS ErrorLoading. In the Data window, right-click the relevant field. This would be a great time saver, with all of the calculations and linking changing as well. Build whatever calculated fields from the secondary that need to be used in in the primary. I have two data sources which I have blended together on two fields: branch and date. I am creating a couple of formulas to display the total booking from the second data source to the first data source. This means that when a cube data source is published, you cannot make a connection from Tableau Server using the data source. I'm trying to show a distinct count of claims by branch. blending [cannot blend Measure Values from a secondary data source] -----> this approach failed . 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. In the Relationships dialog box, under Secondary data source select Custom, and then click Add. 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. 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. I am trying to . Cannot blend the secondary data source because one or more fields use an unsupported aggregation. I have two data sources which I have blended together on two fields: branch and date. since i want only offername from secondary source to the view and the measures are produced from primary datasource is pos_trn. This feature would be really useful to ensure we can. 0 and 7. I'm blending the 2 data sources by Service_Id. 0, but I imagine someone has been able to identify what is causing the issue. I think I need to define the relationship between the data sources. Resolution. Please see if it helps , here it says that problem is with COUNT & they have provided one alternative way as well . First data source looks like below. with blends, we are only able to support aggregates (like SUM, MIN, MAX. 1 because it can cause Tableau to unexpectedly quit. E make table 2 the primary and table. This would be a great time saver, with all of the calculations and linking changing as well. This means that it forces the view to display only relevant data in the secondary data source. I have two data sources and I have blended them together. Moreover, blending is a kind of left join, not exactly a join. In the attached file, table shows the sum of sales and first order date correctly from both the. I'm blending student data (primary) and staff data (second). Hi Data Modeler , I have an idea which I cannot test right away. Answer. CustomOverall (Primary) 2. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. The date values you want to blend on must exist in both data sources. I tried data blending using the zip codes as a common field but I am facing very slow performance. This can help researchers identify. "Cannot blend aggregated data from the secondary data source with the data on this sheet because there are no linking fields use din the view" I'm using 2 separate data sources connected to Oracle and published to the Tableau server. Name: Distinct Count. Relationships cannot be formed between tables from data sources published to Tableau Server or Tableau Online. Data blending is used when the linking fields need to vary on a sheet-by-sheet basis for different visualizations. 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. Some examples include: session cookies needed to transmit the website, authentication cookies, and security cookies. 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)]. Secondary data is one of the two main types of data, where the second type is the. Dominic Laird(Member) 5 years ago. The default view that you first see in the Data Source page canvas is the logical layer of the data source. However, when the linking dimension is not in the view, non-additive aLoading. 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. Another sheet:W2 is created with Data source A - taking Role in Row shelf. cannot blend secondary data source because one or more fields use an unsupported aggregation beacuse of LOD. The secondary data source just pulls in some names to associate with ID numbers in the primary and some filters for the staff data. Data blending works only as a left join. If this aggregation is ATTR() then the grand totals may be blank. Whichever data source you "use first" in a view (by dragging in a field) becomes Primary. Marked as. The limitation with Tableau and secondary data sources stinks. png - Ben-Sullins's library "Cannot blend the secondary data source because one or more fields use an unsupported. Select Default Properties > Sort. Make sure that you are blending on dimensions present in the view or on. For example, sheet A uses data source 1 as the primary data source; sheet B uses data source 1 as the secondary data source. I have two data sources to be used but need the count distinct of users from both the data sources. Hi All, I have blended primary and secondary data sources. So if you drag Category from the Orders data source, it will automatically mark Orders as the primary data source. It throws me cannot blend secondary data source one or more becuase one or more fields use unsupported aggregation . It takes advantage of the data collected from previous research and uses it to carry out new research. I have 2 published datasource and i think i cannot perform JOIN, LOD and COUNTD. It is important to understand which is the primary source, it can impact. 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. 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. 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. Verify if one of the measures coming from the cube data source has a default aggregation different than SUM, MIN, MAX, COUNT. 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. If there is another. Option 1: Join the data sources with a cross-database join instead of blending. Select Custom in the relationships list, and then get Attach. That's probably your problem. The version I am working with 10. Cannot blend the secondary data source because one or more fields use an unsupported aggregation" when Data Blending. Hi . Remove all dimensions from the secondary data source and ensure that the primary data source’s. ×Sorry to interrupt. on Rows, Columns, Pages, or the Marks Card. As 'Group' is from a secondary data source, I cannot simply use the sort buttons. 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. To overcome this, I've added a filter straight into the data source and not in the view. As it is right now (version 8) if you add filters from a secondary data source, you can not cascade the filters based on what the user selects from one filter to the other - this is only. I get error: “Cannot blend the secondary data source because one or more fields use an unsupported aggregation. 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. Instead, we need to publish the two data sources separately on the same server and then. My problem happens when I go to the dashboard, I want to filter on FW (fiscal week) and have crosstab. You can use data blending when you have data in separate data sources that you want to analyze together on a single sheet. It says, "fields cannot be used from [data name] data source, because there is no relationship to the primary. the count of claims I'm getting from the secondary data source, by counting distinctly a measure called claimid. Can't see what you are actually doing but Blending data has its limits. When you data changes, you need to redo the. 2 and later. . Use the geographic role in the primary data source on detail instead of the dimension from the secondary data source. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. This type of bases does not allow for blend relationship, therefore, you cannot use a filter like this. Tableau Desktop & Web Authoring. Call it [Start KM]: IF ATTR ( [KM Date])=ATTR ( [OIL]. This will be identified with a blue checkmark. Currently, data sources that contain logical tables cannot be used as secondary data sources for data blending. See the attached updated workbook. Next, create a table calc using the [Start KM] to calculate the total KMs:Error: Cannot blend the secondary data source because one or more fields use an unsupported aggregation. The Products set contain the individual products within an Opportunity whereas the Opportunities set contain Sales metrics (i. You cannot filter data across secondary data sources. Primary Data Source: Extract S. 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. 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). Best solution. Tableau Desktop 2018. Make sure that you are blending on dimensions present in the view or on all of the. The aggregation is all on primary source data. When you blend, you can only have aggregate access to the rows in the secondary. Secondary data source has Order Date represented as separate Year and Month fields. Data blending provides a way to combine data from more than one data source on a single worksheet. Create a “Blend Field” with a value of 1 in both your primary and secondary. Credits to Jonathan Drummey for the below workaround Cannot blend the secondary data source because one or more fields use an unsupported aggregation . 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. For more information,. CSS ErrorData blending is based on two key components- Primary data sources and Secondary data sources. In this example, Superstore Sales is the primary data source and Coffee Chain is the secondary data source. Fixed, countd functions won't work with the secondary datasources. This is interesting. When I do the join between the SSAS Tabular Model (primary data. The default view of Data Source canvas is the logical layer in Tableau version 2020. 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. I have been working on Blending feature for a while in different situations and. data source. I am trying to create a waffle chart. Try one of the following options, as appropriate for your workbook: It may be possible to cross database join instead of blending. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. General Information. In my primary, I define another calculated field to do the aggregation for each project by tier: VendorClass: if max [Secondary]. Filtering data across a worksheet's secondary data source is not currently supported in Tableau Desktop. The unsupported aggregation happens when your aggregate requires row-level visibility to the secondary data source. Become a Better Analyst in Just 5 Minutes a Week. Hi All! 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. 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. Because in Tableau, you don't use COUNTD function when Blending data source. I get error: “Cannot blend the secondary data source because one or more fields use an unsupported aggregation. 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. e. Data blending is particularly useful when the blend relationship—the linking fields—need to vary on a sheet-by-sheet. 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. The two data sources are identical. As you can see I have 2 different data sources using a blend on the blood type. I have two data sets that are linked across Date and Product Category fields. Data sources can contain logical tables not be used as secondary data sources for data blending. Data blending brings in additional information from a secondary data source and. 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. Expand Post. Please post you twbx workbook so we can see if there a way . Data blending is particularly useful when the blend relationship—the linking fields—need to vary on a sheet-by-sheet. Thanks for your help everyone! I've found what was happening: I had some filters on the secondary data source. 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. Mihai Constantinescu (Member) 6 years ago. 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. They cannot be used as secondary data sources. Data blending tools can present their findings as visualizations, such as infographics and charts, after querying data sources and aggregating relevant information. ×Sorry to interrupt. tds and . 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. However, I still get that message saying cannot blend the secondary data source because one or more fields use an unsupported aggregation". Make the field(s) used to address the table calculation active linking fields. Step 2: Make it a context filter. 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. See. Open. CSS ErrorI want to blend data from two different sources but on blending the data the filters from primary data source do not work if the case is different in the secondary data source. Alternate names:. Last week I’d promised to explain why the solution for identifying whether All items in a Tableau Quick Filter were selected wouldn’t work under certain circumstances in Tableau version 8, here it. I've blended on user ID. 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. I have uploaded this dummy file since I cannot upload my real data here. with blends, we are only able to support aggregates (like SUM, MIN, MAX. 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. Resolution. Summary:. "Budget" is only contained in an Excel file data source. COUNTD - Blended data.