I am using tableau 2020. Hi, Because we can't see the entire picture, no detail in the view of the connected data sources, the workbook, etc. The default view that you first see in the Data Source page canvas is the logical layer of the data source. 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. " I have seen a few posts on it and found an issue logged about it as far back as version 8. There's a set of views/calcs that show a metric, (metric C) counting distinct number of accounts contacted per person per week (e. Primary and Secondary sources in data blending. The "Create Primary Group" operation is bringing the dimension from the secondary into the primary, but it is static, and does not update when your data updates. They must be in the same format. But the source calc is a countD. All data from a secondary source comes back as an aggregate -- even if there is only one value from the secondary source. Ambiente. To alias field values. Thank you . drag the secondary measures to measure values section . When you blend, you can only have aggregate access to the rows in the secondary source. To the Data pane, umschaltung in this [name of secondary data source] data source, real click at lowest one link icon to blend that data sources. CSS ErrorData blending is based on two key components- Primary data sources and Secondary data sources. 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. e. IF ATTR([Offer Status]) = "Hired" Then AVG([Comp_File]. “Cannot blend the secondary data source because one or more fields use an unsupported aggregation. 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. The data source with the KMs is the primary source. I use the Opp ID to relate them. Answer. I have two data sources and doing a data blend. Selected as Best Selected as Best Upvote Upvoted Remove Upvote 1 upvote. 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. Hello Jim, Thank You for your reply. Step 1: Create the Parameter. 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. 2) Use data source filters instead of the Filters Shelf. While it’s possible to aggregate the 1-to-many data source in the custom SQL, this can be time consuming and will require more edits when data sources change. Best solution. I am using tableau 2020. Blending runs a query on each data source and joins the aggregated results of those queries. 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. This will be identified with a blue checkmark. Status, Stage, etc). Upvote Upvoted Remove Upvote Reply. Upvote Upvoted Remove Upvote Reply. It takes advantage of the data collected from previous research and uses it to carry out new research. Nitish Pamarty (Member) 7 years ago. The Products set contain the individual products within an Opportunity whereas the Opportunities set contain Sales metrics (i. Open. 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. Resolution. 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. Marked as. So make sure you're not using such function while blending. Whichever data source you "use first" in a view (by dragging in a field) becomes Primary. 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)]. The relationship is on the facility ID. 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". 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 example, select Analysis > Create Calculated Field, and in the Formula text box, type the. Secondary data source has Order Date represented as separate Year and Month fields. ×Sorry to interrupt. The value gets reduced based on filters@@@ from all 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. I like to have the ability to swap a primary data source with a secondary data source for data blending in a workbook. Instead, publish each data source separately (to the same server) and then blend the published data sources. 4. Size() is a great choice for unique counts across data sources if you can create a view where every unique row is displayed. A datetime field may be converted to a date field using a calculation to remove the time. In the Data pane, select the Store - North data source. Data source filters. - Dataset 1, records the amount spent on ads as "Cost". CSS ErrorLoading. However when I use B as primary data source, drag [A]. 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. Data blending; Table Calculations; Resolution Use one of the following workarounds: If possible, join instead of blend your data. However, when the linking dimension is not in the view, non-additive aLoading. Pick the secondary data source in of Secondary data source pane. And I use Join data source, after divide measures / row duplicate. If I cant go the above way then is there a possibility to do the duration calculation using table calculations or some other way. twbx. Assuming that's what's going on, there's the question of how to work around this. Data blending is a method for combining data from multiple sources. I get error: “Cannot blend the secondary data source because one or more fields use an unsupported aggregation. Data of any sort coming from a secondary source must come as an aggregate of some sort. 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. ×Sorry to interrupt. I can add to filters from the data extracts. [Work Hours]) So you have to make. For more information, see Troubleshoot Data Blending; Blended data sources cannot be published as a unit. (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. This feature would be really useful to ensure we can. According to Tableau, this error can also appear when using a LOD expression in a blended view. I. The blend is not activated meaning a field from secondary DS is not used in the view. I have two data sources to be used but need the count distinct of users from both the data sources. Also, data blending is useful for combining data from published. 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. Fields from the secondary data source used in the view have an orange check mark. Loading. 3) Select the now grey link next to the original field in. 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. Can anybody please help me with a solution. Instead, the. As it turns out, I didn't actually end up using an LOD, but thought I might have to, hence the reason for JOINING the data together as shown in. Because there are no linking fields in this view. Remove all dimensions from the secondary data source and ensure that the primary data source’s. Chicken + Choice of Drink1 pc. Tableau will throw an error: “Cannot blend the secondary data source because one or more fields use an unsupported aggregation. In your workbook sheet2 does not contain 5/22 date. So, basically, I am having issues with 2 calculations - the FIXED LOD and Remaining Value. 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 . ) If only one of the tables requires row level information, consider making that the primary data source in the blend (I. Resolution. If I cant go the above way then is there a possibility to do the duration calculation using table calculations or some other way. 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. The data source with the KMs is the primary source. 2) Use this duplicate field in the view instead of the original. Step 1: Connect to your data and set up. Think of this layer as the Relationships canvas in the Data Source page. Tableau Desktop; Blended data; Soluzione Use the following workaround: Create a new worksheet. I am trying to blend the same data against the other because I wanted to show Same Period last Year. Tableau Desktop & Web Authoring. Upvote Upvoted Remove Upvote Reply. 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. In this source create a calculated field to pull out the KMs on the date of oil change. This is a new complexity in Tableau v8: In v7 and earlier, to blend we had to have the linked dimensions in the view, i. Seemingly simple task is getting complicated in Tableau . So if you drag Category from the Orders data source, it will automatically mark Orders as the primary data source. Try one of the following options, as appropriate for your workbook: It may be possible to cross database join instead of blending. In the actual data I get the error: Cannot blend the secondary data source because one or more fields use an unsupported aggregation. What does this mean? I want to create a city filter and apply it both to the SAS data source as well as the pivoted CSV file. Solution in the image 📌 Non-additive aggregates from the primary data source 📌 Non-additive aggregates from the secondary data source 📌 Non-additive aggregates from a multi-connection. tds and . ”. E make table 2 the primary. Proj. The primary data source is just to filter for the invoices I want to look at. 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. But seems we cannot blend 2 secondary data source with same field. We use three kinds of cookies on our websites: required, functional, and advertising. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. 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. Let say from DS1 if i am making it as primary datasource then i can get the. Community Manager update. Data blending is particularly useful when the blend relationship—the linking fields—need to vary on a sheet-by-sheet. For more information, see Use Relationships for Multi-table Data Analysis. 1) Vizible Difference: Getting around Count Distinct in a secondary data source. Blending Data Issue: "Data sources that contain logical tables cannot be used as secondary data sources for data blending" Hi All, new to Tableau (learning through Udemy) and have run into an issue trying to blend. you will get 5/22 date. "Cannot blend the secondary data source because one or more fields use the / function, which cannot be computed locally. . Click on the ‘Add Action’ button and choose ‘Change Set Values’. Viz cannot be filtered with secondary data source filter before loading the visualization so using "[DS_Name]. Blending your Data in Tableau. How do I blend these data sources by year? - The Tableau Community. I can add to filters from the data extracts. 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). THEN add this total to the SUM of the projected_users from today's date through month X. 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. And I want to add one of the field from secondary dataset to be in the filter. e. This would be a great time saver, with all of the calculations and linking changing as well. Here are the 7 major steps for putting this together: Set up your primary (main) and secondary (parameter) data sources. 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 make sheet 1 as the primary data source and do the data blending with sheet 2. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. The limitation with Tableau and secondary data sources stinks. 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. ”. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. Now, in dashboard D1 : has two worksheets W1 and W2. See. 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. 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. Data coming from a secondary source is ALWAYS aggregated at the level of the link - even if there is 'no need to add anything' that's just the way blending works - it happens after the data table dimensions are set and you are loading values into the data table for the individual worksheet additionally, data coming from the secondary source are always aggregated at the level of the link when brought to the primary source - the individual records are no longer available and you are not able to filter across the various data sources at that point - that is the long way of saying you will have to join or use a relationship - not. While on a view, right click a data source, click replace data source. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. " inner cross database join on BU Code with a data source filter set up on UPPER([ID])=UPPER(USERNAME()) on the DS2 source. Please check the attached workbook for details. 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. We don't get row-level data from secondary sources on a blend. If I cant go the above way then is there a possibility to do the duration calculation using table calculations or some other way. Option 2: Join tables that are in the same data source, instead of blending them. Beyond that personally I tend to do the work necessary to avoid using data blending in production data sources & views. 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. Tableau automatically adds an aggregation (SUM) around the column from the secondary source. Verify if one of the measures coming from the cube data source has a default aggregation different than SUM, MIN, MAX, COUNT. Set up the primary and. Non-additive aggregates are aggregate functions that produce results that cannot be aggregated along a dimension. In Tableau Desktop, navigate to Data > Edit Relationships. [amount] into the view, it gives less than. 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. Loading. A data blend cannot filter on dimensions that do not exist in the Primary data source. Data blending works only as a left join. Option 1: Join the data sources with a cross-database join instead of blending. Maxdate) There is one more way, make the datasource which is using the fixed calculation to primary data source. 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 . Data > Edit Relationships . cannot blend aggregated data from the secondary data source with data on this sheet. My goal is to show CY Actuals as bars, with a line for PY Actuals and a line for Budget. Final Words. We are blending two data sources. We've adjusted our data strategy accordingly so using joins in all of our workbooks that need to leverage this functionality is not a sustainable solution. If you want to filter data across secondary data sources, consider. One on table it was all upper case on the other one it was a mix of upper and lower case. I have two data sets: the first data set is a shp file from data. It also means you cannot create a workbook using the. T or F: Blends, unlike relationships or joins, never truly combine the data. the blended data cannot be published to Tableau Online or Tableau Server. You can create a federated database using linked tables/worksheets. if you have blended data sources you can not use lods One of the drawbacks of blended sources . The data in the primary data source is the main data on which Tableau defines graphs and charts. I'm trying to blend two data sources on a single field, say 'Program Description'. Currently, data sources that contain logical tables cannot be used as secondary data sources for data blending. 3. Summary:. The solution. I am creating a couple of formulas to display the total booking from the second data source to the first data source. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. Expand Post. In second data source i don;t have salesrep column. LOD Expressions will not be shown in the Data Source; When referencing a dimensionality declaration parameter, always use the parameter name and not the parameter value; With data blending, the primary data source's linking field must be in the view before you can use a LOD expression from the secondary data source. In the data window, switch to [name1] data source, and click at least one link icon to blend these data sources. Beginning with Tableau Desktop 2020. Data from secondary data sources must always be aggregated in calculations. This can restrict many values from the secondary data source. Data from a secondary source is displayed along with the primary source data. From my primary data source I have a measure in rows, say 'Measure, which is 'distinct count of Pol Number' or 'sum of Premium' depending on a boolean parameter's values (TRUE or FALSE) The unsupported aggregation happens when your aggregate requires row-level visibility to the secondary data source. COUNTD - Blended data. For example, sheet A uses data source 1 as the primary data source; sheet B uses data source 1 as the secondary data source. LoadingWhen you try to add URL actions to dashboards, fields from secondary data sources cannot be added to the URL. 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. Here's the data blend view with the secondary data source selected so we can see what blend fields are used:. e. There's no way to "swap. 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. 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. Create a “Blend Field” with a value of 1 in both your primary and secondary. I am getting Cannot blend secondary data source because one or more fields used an unsupported aggregation. Marked as. 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 . Date dimensions: For cube data sources, date dimensions are typically organized into hierarchies that contain levels such as year,. Hi, I have a scenario where I have to use Data Blending option to get certain metric values from Secondary Data Source. ×Sorry to interrupt. Data blending is used when the linking fields need to vary on a sheet-by-sheet basis for different visualizations. 2, Tableau introduces relationships and splits. The version I am working with 10. Expand Post. Make sure that you are blending on dimensions present in the view or on all of the. So the only way, it was possible was to connect one of the data sources with a calendar table joined with previous year and then blend it against the same data to get the Current Year and Same Period Last Year values in a single view. To overcome this, I've added a filter straight into the data source and not in the view. * Blend in the summary of a large dataset to reduce query time. They cannot be used as secondary data sources. For more information, see Deciding Between Joining Tables and Blending Data. FIXED requires that you have row-level access to the rows in the secondary source. The concept of data blending is, for every match in the primary table there should be exactly one row item in your secondary table, in the view of this concept any aggregation on the secondary table will always be distinct by default. I 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. In a blend, secondary data sources are aggregated and the StoreID dimension would be aggregated to "*". Observations : 1. Not able to share for time being. 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. Twbx and also the . 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 can get all the fields into the view apart from the 'is vat exempt'. 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. How ever # no of changes and # of Problems are calculating entire database values. Primary and Secondary Data Sources in Tableau: To perform blending in a Tableau sheet, there should be at least one secondary data source. Any existing, automatic blend kontakte is visible (and pot be deleted by suspend over the row and clicking the x). It sounds like there might be some complications with a blend? Can’t speak to what’s happening thereAre you blending on [Endtimestamp]? By using the formula DAY([Endtimestamp]), you're changing the dimensionality a little bit. Consider joining the two data sources together using Tableau Prep, and then you can use that data as a. 3 and I have created aggregates AGG for fields from data extract and excel file. A Level of Detail (LOD) expression is being taken from the secondary data source. If there is another. ×Sorry to interrupt. Primary Data Source: Extract S. 1. I am confused, as I am not even trying to blend Data from both Data Sources. 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). But I cant add filter Month from the Budget Excel file. LOD calculation and blended data sources. ) So the issue is really the introduction of the group on the sheet. In versions prior to 2020. When on the dashboard, click on the ‘Dashboard’ drop-down and select ‘Actions’. Please find the complete blog here ----> COUNTD with secondary DS Tableau(Blending) Workbook is attached. I cannot change the case of the data to upper or lower. Input cannot become used from the [name are secondary data source] data source, because there is no blend relationship to the primary data source. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. As you can see I have 2 different data sources using a blend on the blood type. An orange tick indicates a secondary data source (Promotions). Sometimes , it's automatically working but sometimes it says 'Unsupported Aggregation' . e. 3) COUNTD with Secondary DS (Blending) Thanks,. Are you talking about Tableau Prep or Tableau Desktop? Any chance you can share a sample of your data? Expand Post. 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. AUMTable (Secondary) 3. 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. Loading. id, A. Primary Data Source: Contains a list of all employees and their role. A key difference with blending is that data is aggregated before being "joined" - you'll notice this when you include a column from the secondary source in a calculation in the primary source. You cannot filter data across secondary data sources. Good morning @Fred Yu (Customer) . This is one of the disadvantages of data blending in Tableau. I'm blending student data (primary) and staff data (second). 2) DB2 blending doesn't support non-additive aggregates like COUNTD() from secondary sources. (I created calculated fields "Fiscal Year" and "Fiscal Month" on my secondary Superstore example to simulate this. You cannot change that. However, some days will have entries for "Cost" but not for "Proj. Filtering data across a worksheet's secondary data source is not currently supported in Tableau Desktop. Since my Workbook is present inside Office premise. Change the default sort order of the field using the various options, and then click OK. - 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. I am trying to use the measures name filter functionality with two data sources. 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. "Cannot blend the secondary data source because one or more fields use an unsupported aggregation" I have tried the following calculations but have not been able to figure this out. Currently, it's not working, the filter I try to add in the dashboard appears red in my spreadsheet and tells me that : "Data sources containing logical tables cannot be used as a secondary data source for data blending". " Expand Post. Each has a joining field with the same name. All three options are demonstrated in the attached workbook using the sample data set Superstore. This can help researchers identify. Instead of using relationships, double-click into your table to get to the. I'm blending the 2 data sources by Service_Id. then i added a secondary data source from google sheet , which has the fuel amount. As 'Group' is from a secondary data source, I cannot simply use the sort buttons. Make the data source that contains the field that you want to use in the URL action the primary data source in. 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. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. 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. {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. Hi All, I have blended primary and secondary data sources. Data sources can contain logical tables not be used as secondary data sources for data blending. Dominic Laird(Member) 5 years ago. "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. FIXED ID, WEEK: CountD (accounts)). Expand Post. month([date])=month(Parameter. 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. Cannot blend the secondary data source because one or more fields use an unsupported aggregation issue. Unsupported aggregations in data blending Hello, I have a distributor dataset with product ships and returns (one report covering six months), and a retailer dataset with product retail sales and stock (covering the same six months but composed of. ) A LOD calc is also trying to do stuff at the row level. 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). Jim. All customer IDs are under a dimension called "Global ID". 💥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. You cannot filter data across secondary data sources. Tableau Desktop 2018. Ritesh Bisht (Member) 6 years ago. When you data changes, you need to redo the. Fee - Cost) over time. For more information, see Use Relationships for Multi-table Data Analysis. I am trying to use the below formula instead of countd function because my data comes from Impala. If the user select May 2018. Right-click in the Data window and then. I have two datasets; one is a shape file that contains regions and locations. "Cannot blend the secondary data source because one or more fields use the == function, which cannot be computed locally. Using existing secondary data sources can save researchers time and resources by providing access to pre-existing data that has already been collected and organized. Aggregate the date fields at the MY. I noticed that when the spatial file is the secondary data source, I cannot area plot it by double clicking the geometry variable. Loading. If this aggregation is ATTR() then the grand totals may be blank. The secondary data source just pulls in some names to associate with ID numbers in the primary and some filters for the staff data. I am confused, as I am not even trying to blend Data from both Data Sources. I have two data sets that are linked across Date and Product Category fields. 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. Instead, publish each data source separately (to the same server) and then blend the published data sources. 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. CSS ErrorAfter Blending, Now it is showing this error: Cannot blend the secondary data source because one or more fields use an unsupported aggregation. Russell Christopher (Member) 10 years ago. The version I am working with 10. I have been working on Blending feature for a while in different situations and. Functional cookies enhance functions, performance, and services on the website. (It is a field that contains account names (company) in the sample data. You must double-click a logical table in the Data Source page canvas to go to the physical layer of the canvas. I have two data sources which I have blended together on two fields: branch and date. Data blending is particularly useful when the blend relationship—the linking fields—need to vary on a sheet-by-sheet. I am using blending and created Relationship but i am having problem in terms of getting distinct count from one of the data sources. Better collaboration. . If you create a quick filter on a field from data source 1 and apply this quick filter to. 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. 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. However, I still get that message saying cannot blend the secondary data source because one or more fields use an unsupported aggregation". Excel . The Products set contain the individual products within an Opportunity whereas the Opportunities set contain Sales metrics (i. Loading. We use three kinds of cookies on our websites: required, functional, and advertising. Make the field(s) used to address the table calculation active linking fields. Filter each of the data sources independently on the more granular dimensions.