{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. In the attached file, table shows the sum of sales and first order date correctly from both the. Data blending provides a way to combine data from more than one data source on a single worksheet. I want to do a basic data listing showing customer, order no, postcode & vat exempt. 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]). Fields from the secondary data source used in the view have an orange tick. Primary and Secondary Data Sources in Tableau: To perform blending in a Tableau sheet, there should be at least one secondary data source. Someone in the Community told me the following:A common use case for my analysis is blend a secondary data source then do a table calculation with various independent measures (thus I cannot apply filters). Option 2: Join tables that are in the same data source, instead of blending them. 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. Data blending has some limitations regarding non-additive aggregates such as COUNTD, MEDIAN, and RAWSQLAGG. LOD expressions are used when running complex queries with multiple dimensions at the data source level. Functional cookies enhance functions, performance, and services on the website. Hi . Data blending is a method for combining data from multiple sources. Drag the State (group) dimension over the Region dimension on the Rows shelf to replace it. Assuming that's what's going on, there's the question of how to work around this. Proj. Final Words. . There are a few possibilities: 1) Flip the blend so the primary is secondary and vice versa. LoadingWhen you try to add URL actions to dashboards, fields from secondary data sources cannot be added to the URL. Remove all dimensions from the secondary data source and ensure that the primary data source’s linking field is in view. Cannot blend the secondary data source because one or more fields use an unsupported aggregation" when Data Blending. i will try to build some moke up data in excel and reproduce the same but before that could you please explain me in detail what calculation i need to perform in secondary source. Now, in dashboard D1 : has two worksheets W1 and W2. 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. The data in the primary data source is the main data on which Tableau defines graphs and charts. According to Tableau, this error can also appear when using a LOD expression in a blended view. Hi . Fee - Cost) over time. 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. 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. Data of any sort coming from a secondary source must come as an aggregate of some sort. 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. id, A. Because data blending is an ad-hoc LEFT join that aggregates data from the secondary data source, Tableau cannot always perform aggregations that require the full domain. I am trying to use the below formula instead of countd function because my data comes from Impala {FIXED [Machine Nr] : COUNT([Machine Nr] )} / {FIXED [Machine Nr] : COUNT([Machine Nr] )} This works fine when there is no secondary data source but when I blend with a secondary data source it grays out my sheet i. I have a Remaining Value calculation, but it is not correct. Verify if one of the measures coming from the cube data source has a default aggregation different than SUM, MIN, MAX, COUNT. Non-additive engine are entirety functions that errichten outcomes that cannot be aggregated along a dimension. ” We use three kinds of cookies on our websites: required,. Also, after I get the total per PO Number, I want to get a remaining value that subtracts the Total Cost (from the secondary data source) from the Total per PO Number. Maxdate) There is one more way, make the datasource which is using the fixed calculation to primary data source. You can create a federated database using linked tables/worksheets. Here is an example of what I am trying to accomplish:Data blending is a method for combining data from multiple sources. For more information,. 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. 2. 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. Using Tableau; Upvote; Answer. We use three kinds of cookies on our websites: required, functional, and advertising. This means that when a cube data source is published, you cannot make a connection from Tableau Server using the data source. 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. Please see if it helps , here it says that problem is with COUNT & they have provided one alternative way as well . One on table it was all upper case on the other one it was a mix of upper and lower case. Fee" I want to plot Gross Profit (i. Additional Information While replacing ATTR() with MIN() will cause "Automatic" grand totals to show, the grand totals might not be the expected values. 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". Effective visualization. Chicken + Choice of Drink1 pc. Please check the attached workbook for details. See Join Your Data for more information. Remove all dimensions from the secondary data source and ensure that the primary data source’s. Thank you . 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). But since there are a few dates missing from the second data source i cannot blend on date as doing this will result in loosing data from Table 1. The syntax for calling secondary data source field is not. png - Ben-Sullins's library "Cannot blend the secondary data source because one or more fields use an unsupported. 4, I tried to blend products (secondary) to storefront (primary) based on Sku. newBranchProjection (Secondary) When I try to add COUNTD([DistrictId]) from my primary to text table. Hi Kurt! No, not really. . ) A LOD calc is also trying to do stuff at the row level. If you create a quick filter on a field from data source 1 and apply this quick filter to. Resolution. Step 2: Make it a context filter. Common Issue #1: Cannot blend the secondary data source because one or more fields use an unsupported aggregation The aggregation methods of COUNTD, MEDIAN, and other non-additive aggregate functions can cause fields to become invalid. 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. In the secondary (user rights sheet), create a "Verify Username" calculation that has the fmula:. Help would be much. I've created the first chart with no problem, but I. - Data to Map from - Data to Map to . Primary Data source - Actuals ( day grain) Secondary data source - Goals (quarter grain) Calculated Measures: Primary Data source :- CustCount = CountD( Cust_ID ) Secondary Data source : %of Goal = CustCount/SUM([Goal])The physical layer of the Data Source page canvas is basically the "classic view" of the Data Source page in previous versions of Tableau. If you have to have row-level access on a. It throws me cannot blend secondary data source one or more becuase one or more fields use unsupported aggregation . AUMTable (Secondary) 3. Tableau has two inbuilt data sources named Sample-superstore and Sample coffee chain. I cannot able to use as one connection since am using the data source filter in my first connection have data source filter. 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. 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. an aggregated left join where the aggregation of the secondary data cannot be used to increase the level of detail of the primary data. All Answers. you get all data from main data source and ONLY matching data from secondary data source. Option 2: Create a calculation for a more dynamic sort. Because there are no linking fields in this view. then i added a secondary data source from google sheet , which has the fuel amount. This feature would be really useful to ensure we can. We can see these by activating secondary data source and looking at the dimensions window, the linking dimensions will have an orange chain icon. Nitish Pamarty (Member) 7 years ago. cannot blend aggregated data from secondary data source. 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. When you blend, you can only have aggregate access to the rows in the secondary source. I have 2 data sources, A and B, they are linked by data blending with A. 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. tds and . Data blending is particularly useful when the blend relationship—the linking fields—need to vary on a sheet-by-sheet. Use the geographic role in the primary data source on detail instead of the dimension from the secondary data source. Tableau will throw an error: “Cannot blend the secondary data source because one or more fields use an unsupported aggregation. To fix this, we had to add the fields being used in the blending relationship onto the view: Aside from a few of these, we didn’t need to combine the data in very complicated ways. 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. I thought about using a parameter but you cant search with a parameter in a prompt, on the other charts that are like this there are hundreds on items. Another way to approach this is to do a join of the data outside Tableau via a federated data source. If you want to make sure you don't lose any measures from the secondary source then either. 1, the ability to "Show Empty Rows" (or columns) was removed when you use a secondary data source. Filtering data across a worksheet's secondary data source is not currently supported in Tableau Desktop. That's probably your problem. Please refer the below link and let me know if this helps to you. I have two data sources and I have blended them together. " inner cross database join on BU Code with a data source filter set up on UPPER([ID])=UPPER(USERNAME()) on the DS2 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 . Status, Stage, etc). Hi All, I have blended primary and secondary data sources. When you blend, you can only have aggregate access to the rows in the secondary. 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. This happens regardless if I drag it on the rows or on the Marks space as a 'text'. CSS Errorthe message says that a Logical table can not be used as a secondary source - You are trying to blend data (or at least tableau thinks you are) try reverting the data connection to a Physical model to JOIN the files together on the company name - JimThe secondary data source hasn't been changed and the groups work as filters. They cannot be used as secondary data sources. 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. The value gets reduced based on filters@@@ from all data source. Cannot blend the secondary data source because one or more fields use an unsupported aggregation . In the calculation dialog box, do the following: In the name text box, enter Sales for Store - South. In the Relationships dialog box, under Secondary data source select Custom, and then click Add. Data. I am using blending and created Relationship but i am having problem in terms of getting distinct count from one of the data sources. These latter two situations trigger a different style of data blending (DB2) inside Tableau to ensure an accurate blend and that makes computation of non-additive aggregates much more. Now try to recreate the sheet and link the 2nd and 3rd data. The data source with the KMs is the primary source. ×Sorry to interrupt. So, to do Data Blending, the steps that I would suggest would be: - Connect to the data sources that you need to use. The limitation with Tableau and secondary data sources stinks. Think of this layer as the Relationships canvas in the Data Source page. There's no way to "swap. I am trying using { FIXED : SUM[(portfolioValue)]}. This can restrict many values from the secondary data source. There is a possibility that the values can be restricted from the secondary data. Upvote Upvoted Remove Upvote Reply. Expand Post. mdb which will be used to illustrate data blending. Data blending is a method for combining data from multiple sources. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. I am trying to use the below formula instead of countd function because my data comes from Impala. FIXED requires that you have row-level access to the rows in the secondary source. 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. T or F: Blends, unlike relationships or joins, never truly combine the data. Pick the secondary data source in of Secondary data source pane. 1. 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. 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. 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. 3 and I have created aggregates AGG for fields from data extract and excel file. To overcome this, I've added a filter straight into the data source and not in the view. Few things you need to keep in mind while blending data sources in tableau. * Blend in the summary of a large dataset to reduce query time. 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). 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. But when I am trying to do that I am getting an errorThe issue comes when I try and add a metric that is an aggregate of the two different sources. Instead, we need to publish the two data sources separately on the same server and then. Upvote Upvoted Remove Upvote Reply. The version I am working with 10. How do I blend these data sources by year? - The Tableau Community. blending [cannot blend Measure Values from a secondary data source] -----> this approach failed . According to Tableau, this error can also appear when using a LOD expression in a blended view. "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. This will be identified with a blue checkmark. 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. 2 and later. Expand Post. Are use of grouped fields not allowed in data blending? I have two data sources: Opportunities and Products. 2)Count Distinct from Secondary workaround. Make sure that you are blending on dimensions present in the view or on all of the. Common Issue #1: Cannot blend the secondary data source because one or more fields use an unsupported aggregation The aggregation methods of COUNTD,. Non-additive aggregates are generally not usable when a secondary dimension appears on any Shelf or there’s a linking dimension that is not in the view. Create a “Blend Field” with a value of 1 in both your primary and secondary. However, when I follow your advice, each group splits into 6 rows (one for each month - January through June). Input cannot become used from the [name are secondary data source] data source, because there is no blend relationship to the primary data source. I have two data sets: the first data set is a shp file from data. Build whatever calculated fields from the secondary that need to be used in in the primary. Select Analysis > Create Calculated Field. You cannot filter data across secondary data sources. You can read details here: Logical Tables in Secondary data source. Data blending: Cube data sources can only be used as the primary data source for blending data in Tableau. 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. See the attached updated workbook. ) So the issue is really the introduction of the group on the sheet. You will need a common column between the two tables in order to blend. While on a view, right click a data source, click replace data source. In data source A, I have COUNTD(Person ID) and in data source B, I have COUNTD(Person ID). If that does not help,. This type of bases does not allow for blend relationship, therefore, you cannot use a filter like this. I have quick filters from the primary data source and I am trying to represent distinct. This can help researchers identify. 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. In the formula text box, type the ZN function, the SUM. [Field_Name]":"Value_to_filter" in the Options will not work. Data blending have some limitations regarding non-additive total such like COUNTD, MEDIAN, and RAWSQLAGG. 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). 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. 3 and I have created aggregates AGG for fields from data extract and excel file. Make the field(s) used to address the table calculation active linking fields. From what I understand, it's because the link variable must be present in the view, or else it does not work. Data blending is particularly useful when the blend relationship. 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. The secondary data source just pulls in some names to associate with ID numbers in the primary and some filters for the staff data. 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. Owing to this, only those fields in the secondary data source which bear corresponding matches with the primary data source appear in the visualization pane. 2. It takes advantage of the data collected from previous research and uses it to carry out new research. data source. In order to create the waffle chart I am blending it with another datasource using the calculated field defined as [Week 5 (Week5Bond)]. Moreover, blending is a kind of left join, not exactly a join. Please find the complete blog here ----> COUNTD with secondary DS Tableau(Blending) Workbook is attached. Filter each of the data sources independently on the more granular dimensions. [amount] into the view, it gives less than. Jim. Limitations of Data Blending in Tableau. 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. 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. 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. Data blending brings in additional information from a secondary data source and. THEN add this total to the SUM of the projected_users from today's date through month X. newBranchProjection (Secondary) When I try to add COUNTD([DistrictId]) from my primary to text table. If you want to filter data across secondary data sources, consider the following alternatives: Join tables that are in the same data source, instead of blending them. To blend on summary data, you can do the following: Create a. 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. The default view that you first see in the Data Source page canvas is the logical layer of the data source. [OIL DATE]) THEN MIN ( [KMs]) END. A datetime field in the primary data source, for example, will not blend with a date field in the secondary data source. 2) DB2 blending doesn't support non-additive aggregates like COUNTD() from secondary sources. 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". A secondary data source can be used to re-alias the field values in a primary data source. In second data source i don;t have salesrep column. This is the final step and will result in filtering between the blended data sources at your desired level of granularity. Show moreA workbook or mock data would be a sure thing to comment and try upon it. Hi. Sometimes , it's automatically working but sometimes it says 'Unsupported Aggregation' . 1 because it can cause Tableau to unexpectedly quit. This happens only when the data sources are impala. So make sure you're not using such function while blending. Tableau Desktop & Web Authoring. For secondary data source you get same result by managing relationships in your case just Area and Qtr. I'm blending the 2 data sources by Service_Id. Reference line -----> in this approach able to show sub-category items measures like sales and quantity totals as reference lines shown in below figure . Whichever data source you "use first" in a view (by dragging in a field) becomes Primary. Secondary data sources cannot have logical tables (except when they satisfy specific conditions). duplicate the date field. Let say from DS1 if i am making it as primary datasource then i can get the. ×Sorry to interrupt. I am trying to determine the Average Revenue per User by country for which my calculation is total revenue/unique subscribers. 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. General Information. Yes - you can't bring COUNTD in data blending. In my primary, I define another calculated field to do the aggregation for each project by tier: VendorClass: if max [Secondary]. 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. 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. I have two data sources and I have blended them together. I made a waffle chart grid using an excel data source that contains 3 fields: Rows, Columns and Percentage. Secondary data source has Order Date represented as separate Year and Month fields. Does the. For more information, see Deciding Between Joining Tables and Blending Data. Status, Stage, etc). Resolution. When blending in Tableau, there is always a primary source and a 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. Loading. Ambiente. Cube data sources do not support pass-through connections. Hey all, I'm trying to create a filter in my dashboard such as my two spreadsheets are linked with this filter. A datetime field may be converted to a date field using a calculation to remove the time. xls files). 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. Excel . These latter two situations trigger a different style of data blending (DB2) inside Tableau to ensure an accurate blend and that makes computation of non-additive aggregates much more difficult. Blending runs a query on each data source and joins the aggregated results of those queries. 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 blend is not activated meaning a field from secondary DS is not used in the view. 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. From my primary data source I have a dimension in columns say 'Customer Segment'. You combine data in the logical layer using relationships (or noodles). I have two data sources and doing a data blend. 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. Viz cannot be filtered with secondary data source filter before loading the visualization so using "[DS_Name]. The relationship is on the facility ID. Not able to share for time being. You cannot filter data across secondary data sources. Maxdate) There is one more way, make the datasource which is using the fixed calculation to. I'm trying to show a distinct count of claims by branch. Tableau will throw an error: “Cannot blend the secondary data source because one or more fields use an unsupported aggregation. 3 and I have created aggregates AGG for fields from data extract and excel file. 4. Common warnings and errors when blending data sources No relationship to the primary data source. No. Filter each of the data sources independently on the more granular dimensions. As 'Group' is from a secondary data source, I cannot simply use the sort buttons. Twbx and also the . 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. I get error: “Cannot blend the secondary data source because one or more fields use an unsupported aggregation. 0 but was disabled (greyed out) in 8. Hello Tableau world!! Am running into the strangest problem when data blending with V8. you will get 5/22 date. I establish the blend relationships explicitly by going to Data -->Edit Blend Relationships, and selecting the fields that should be related. We have a calculated filed where an aggregation (COUNTD) is done on a filed of secondary data source. FIXED requires that you have row-level access to the rows in the secondary source. Hi Justin, Thanks for your quick reply. The. Your secondary data source does not have the blend activated, you'll need to click on the link and turn it red to activate:. For more information, see Use Relationships for Multi-table Data Analysis. Resolution. This is a dynamic way to make data in sets stand out and gain greater real-world context for users. We are blending two data sources. Relationships cannot be formed between tables from data sources published to Tableau Server or Tableau Online. 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. 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. 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. I get error: “Cannot blend the secondary data source because one or more fields use an unsupported aggregation. This functionality was available in versions 8. I have two data sets that are linked across Date and Product Category fields. 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. 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. 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. I get a blank sheet on the dashboard using the secondary data source because it looks for CASE SENSITIVE ABC . 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. Error: Cannot blend the secondary data source because one or more fields use an 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. Blending with CountD and LODs. The condition is offer status = hired, but offer status can contain my different response types. Also, in the attached I have added both Calc1 and Calc2 to the tooltip in Sheet 9. 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. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. How to tackle “Cannot blend the secondary data source because one or more fields use an… How to tackle “Cannot blend the secondary data source because one or more fields use an unsupported aggregation” while blending Multiple data sources. . Both fields are linked in worksheet. It also means you cannot create a workbook using the. I am trying to blend the same data against the other because I wanted to show Same Period last Year. But the source calc is a countD. 1. Drag the 2016 Population measure to the Columns. I've attached my workbook that contains 2 data sources that are blended by invoice number. 1) Duplicate the field in primary datasource. Also, data blending is useful for combining data from published. 0, but I imagine someone has been able to identify what is causing the issue. 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. The date values must be in the same format. ×Sorry to interrupt. From what I understand, it's because the link variable must be present in the view, or else it does not work. Think of this layer as the Relationships canvas in the Data Source page. "Cannot blend the secondary data source because one or more fields use the == function, which cannot be computed locally. Instead, publish each data source separately (to the same server) and then blend the published data sources. - Dataset 1, records the amount spent on ads as "Cost" - Dataset 2 records the revenue generated by orders as "Proj. e. 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. If I cant go the above way then is there a possibility to do the duration calculation using table calculations or some other way. 3. While on a view, right click a data source, click replace data source. e. Please post you twbx workbook so we can see if there a way . Blended data sources. The Products set contain the individual products within an Opportunity whereas the Opportunities set contain Sales metrics (i. The order in which fields are used determines which data source is the primary versus the secondary data source. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. id = B. Here's the data blend view with the secondary data source selected so we can see what blend fields are used:. Unfortunately can't share the data, and can't come up with a mock cause I can't figure out what's not/is working as expected. I use the Opp ID to relate them. But I cant add filter Month from the Budget Excel file. Relationships: Join: Combines columns: Yes: Cross database joins will not work with all data sources: Joins: Blend: Combines columns: No: Fields from the secondary data source cannot be brought in to the view unless there is a match on. Verify if one of the measures coming from the cube data source has a default aggregation different than SUM, MIN, MAX, COUNT. I like to have the ability to swap a primary data source with a secondary data source for data blending in a workbook. 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. e. Thank you. 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. 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). For more information, see Use Relationships for Multi-table Data Analysis. Hello Ritish, You could use Size() and a Las() function as a filter and get the same output. * Supplemental data from a secondary data source is needed. Upvote Upvoted Remove Upvote Reply. 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.