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. And I can't explain why it does that. I'm blending the 2 data sources by Service_Id. Filter each of the data sources independently on the more granular dimensions. 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". We have a calculated filed where an aggregation (COUNTD) is done on a filed of secondary data source. 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 the user select May 2018. "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. I am confused, as I am not even trying to blend Data from both Data Sources. The version I am working with 10. Data blending is particularly useful when the blend relationship—the linking fields—need to vary on a sheet-by-sheet. All customer IDs are under a dimension called "Global ID". This would be a great time saver, with all of the calculations and linking changing as well. 2. Use blends when:. We cannot publish a blended data source as a single data source on the server. 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". The data are sorted, but each row only shows one month of data with the other five columns blank. I have two data sets that are linked across Date and Product Category fields. I have a Remaining Value calculation, but it is not correct. Tableau Desktop; Blended data; Soluzione Use the following workaround: Create a new worksheet. Hi, Because we can't see the entire picture, no detail in the view of the connected data sources, the workbook, etc. Select Default Properties > Sort. Common warnings and errors when blending data sources No relationship to the primary data source. Please check the attached workbook for details. When I calculate the average of a measure and use the filter, it works perfectly fine. The blend applies to that worksheet only. when I use A as primary data source and drag A. No. When blending in Tableau, there is always a primary source and a secondary data source. It would be nice if when you blend two data sources, you could have the option to show "Only Relevant Values" on filters used from the secondary data source. Resolution. Verify if one of the measures coming from the cube data source has a default aggregation different than SUM, MIN, MAX, COUNT. The unsupported aggregation happens when your aggregate requires row-level visibility to the secondary data source. I am trying using { FIXED : SUM[(portfolioValue)]}. Error: Cannot Blend the secondary data source because one or more fields use an unsupported aggregation. newBranchProjection (Secondary) When I try to add COUNTD([DistrictId]) from my primary to text table. CSS ErrorHi Mavis Liu. i. 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. xls files). The data is blended on customer. Thanks. The default view that you first see in the Data Source page canvas is the logical layer of the data source. You must double-click a logical table in the Data Source page canvas to go to the physical layer of the canvas. This means that it forces the view to display only relevant data in the 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). Selected as Best Selected as Best Upvote Upvoted Remove Upvote 1 upvote. Upvote Upvoted Remove Upvote Reply. Does anyone have any Ideas how I can apply a universal filter to 5 different unrelated data sources? Applies to: Tableau Cloud, Tableau Desktop, Tableau Server. Left. A data blend cannot filter on dimensions that do not exist in the Primary data source. Loading. 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. * Supplemental data from a secondary data source is needed. This means a data blend can’t be published as a data source for others to use. 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. Name: Distinct Count. 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. All Answers. Cube data sources can be used only as a primary data source to blend data in Tableau, and cannot be used as secondary data sources. 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. But I cant add filter Month from the Budget Excel file. Instead, publish each data. Resolution. Data blending tools can present their findings as visualizations, such as infographics and charts, after querying data sources and aggregating relevant information. Call it [Start KM]: IF ATTR ( [KM Date])=ATTR ( [OIL]. Non-additive engine are entirety functions that errichten outcomes that cannot be aggregated along a dimension. I have two datasets; one is a shape file that contains regions and locations. I have 2 published datasource and i think i cannot perform JOIN, LOD and COUNTD. 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 branch field I'm using from the primary data source. One on table it was all upper case on the other one it was a mix of upper and lower case. 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. Blended data sources. Filtering data across a worksheet's secondary data source is not currently supported in Tableau Desktop. Secondary data is one of the two main types of data, where the second type is the. A Level of Detail (LOD) expression is being taken from the secondary data source. Primary and Secondary Data Sources in Tableau: To perform blending in a Tableau sheet, there should be at least one secondary data source. 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. Hope this helps kindly mark this answer as correct or helpful so that it will help others . Primary Data Source: Extract S. Instead, publish. 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. 0 and 7. 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. This. Blending with CountD and LODs. And I want to add one of the field from secondary dataset to be in the filter. 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. Primary and Secondary sources in data blending. 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 would be a great time saver, with all of the calculations and linking changing as well. Secondary data source has Order Date represented as separate Year and Month fields. Then try using the LOD expression from a secondary data source. Make sure that you are blending on dimensions present in the view or on all of the. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. I have two data sources and I have blended them together. CSS ErrorCannot blend the secondary data source because one or more fields use an unsupported aggregationFollow this link for more information:the secondary data source always has to be aggregated, there's no way to do a row level check to filter out any dimension members that match between the two data sources. " And after that I can't make my workbook work at all. For more information, see Troubleshoot Data Blending; Blended data sources cannot be published as a unit. The version I am working with 10. e. . While on a view, right click a data source, click replace data source. Data. 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. Moreover, blending is a kind of left join, not exactly a join. LoadingWhen you try to add URL actions to dashboards, fields from secondary data sources cannot be added to the URL. However, when the linking dimension is not in the view, non-additive aLoading. So, to do Data Blending, the steps that I would suggest would be: - Connect to the data sources that you need to use. id, A. "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. " Expand Post. {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. If attempting to use COUNTD in a secondary data source when blending, see the following additional workarounds: If Tableau Prep cannot be used, see: Getting around Count Distinct in a secondary data source (third party website) Creating a primary group: Bring a Field into the Primary Data Source in Tableau HelpWhen I am using apply filter to related data sources, other data sources add this field as a secondary data source and the worksheets which uses that as a primary data source gives me errors. Data blending brings in additional information from a secondary data source and. 1, the ability to "Show Empty Rows" (or columns) was removed when you use a secondary data source. mdb which will be used to illustrate data blending. 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. Resolution. Tableau will throw an error: “Cannot blend the secondary data source because one or more fields use an unsupported aggregation. 4, I tried to blend products (secondary) to storefront (primary) based on Sku. The two data sources are identical. ” Causes and Workarounds for a Blending Limitation Errors. FIXED requires that you have row-level access to the rows in the secondary source. Using Tableau; Upvote; Answer. Data blending is a method for combining data from multiple sources. In the secondary (user rights sheet), create a "Verify Username" calculation that has the fmula:. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. Data blending brings in additional information from a secondary data source and displays it with data from the primary data source directly in the view. I am blending dates in the secondary data source to dates from the primary source and looking to get a distinct count of the customer code from the secondary data source. Option 2: Create a calculation for a more dynamic sort. I tried data blending using the zip codes as a common field but I am facing very slow performance. Now we have to use W2 as Filter - to filter out the data. 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. on Rows, Columns, Pages, or the Marks Card. When you blend, you can only have aggregate access to the rows in the secondary source. I use the Opp ID to relate them. It throws me cannot blend secondary data source one or more becuase one or more fields use unsupported aggregation . 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. Hi . In the calculation dialog box, do the following: In the name text box, enter Sales for Store - South. Limitations of Data Blending in Tableau. newBranchProjection (Secondary) When I try to add COUNTD([DistrictId]) from my primary to text table. you will get 5/22 date. Hello Jim, Thank You for your reply. We don't get row-level data from secondary sources on a blend. 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. I get error: “Cannot blend the secondary data source because one or more fields use an unsupported aggregation. ODBC is a pretty universal technology for doing this, you can find more by doing a web search on "linked tables" or "linked worksheets" for your specific data sources. Few things you need to keep in mind while blending data sources in tableau. 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. [Cash PTM]) Else [Null] ENDIn your example, this doesn't work, because your primary data source needs to be Master Store List, because you want to list all the store IDs. 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. 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. It has data from 2003-2012. 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. 1) Vizible Difference: Getting around Count Distinct in a secondary data source. Additional Information While replacing ATTR() with MIN() will cause "Automatic" grand totals to show, the grand totals might not be the expected values. Expand Post. All the data is in the secondary/blended data source. 3 and I have created aggregates AGG for fields from data extract and excel file. 4. T or F: Blends, unlike relationships or joins, never truly combine the data. In your case, you're after the Total Cases by Employee, so just imagine Employee in place of Category. I have two data sets that are linked across Date and Product Category fields. You combine data in the logical layer using relationships (or noodles). Cannot blend the secondary data source because one or more fields use an unsupported aggregation. [Field_Name]":"Value_to_filter" in the Options will not work. Data sources can contain logical tables not be used as secondary data sources for data blending. 3) Select the now grey link next to the original field in. I am trying to blend the same data against the other because I wanted to show Same Period last Year. I get error: “Cannot blend the secondary data source because one or more fields use an unsupported aggregation. If I cant go the above way then is there a possibility to do the duration calculation using table calculations or some other way. Upvote. 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. Non-additive aggregates are aggregate functions that produce results that cannot be aggregated along a dimension. Thanks bharat ! but i think client column is common to both the source so i would able to blend the data. , 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. Build whatever calculated fields from the secondary that need to be used in in the primary. amount into the view, it gives me the correct sum. I cannot change the case of the data to upper or lower. Set up the primary and. 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. Data blending works only as a left join. 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. If I cant go the above way then is there a possibility to do the duration calculation using table calculations or some other way. Now you see a new group field listed in the Population data source (primary) called State (group). 2)Count Distinct from Secondary workaround. CSS ErrorBy default Tableau Desktop wraps fields from a secondary data source in an aggregation in calculated fields. 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. (It is a field that contains account names (company) in the sample data. then i added a secondary data source from google sheet , which has the fuel amount. I have two data sets: the first data set is a shp file from data. 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. We can see these by activating secondary data source and looking at the dimensions window, the linking dimensions will have an orange chain icon. Marked as. Currently, data sources that contain logical tables cannot be used as secondary data sources for data blending. 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. I was now trying to use both calculations you did on a different sheet through data blending. Russell Christopher (Member) 10 years ago. Good morning @Fred Yu (Customer) . This feature would be really useful to ensure we can. In my primary, I define another calculated field to do the aggregation for each project by tier: VendorClass: if max [Secondary]. data source. Thanks for your help everyone! I've found what was happening: I had some filters on the secondary data source. 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. However when I use B as primary data source, drag [A]. Hey all, I'm trying to create a filter in my dashboard such as my two spreadsheets are linked with this filter. In the Data pane, select the State data source (secondary). See the attached updated workbook. I ended up purchasing an Alteryx license for our company (we now have a lot. In the data window, the blue tick indicates the Primary data source (Sales in the image below). This is a table calculation equivalent of the COUNTD() database function, which may be required either because the result needs to be used in a calculation at a different level of detail to the level at which it is calculated, or because the datasouce. 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. I think I need to define the relationship between the data sources. The chart should display: countd. 4, I tried to blend products (secondary) to storefront (primary) based on Sku. Data blending is a method for combining data from multiple sources. 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. 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. Call it [Start KM]: IF ATTR ( [KM Date])=ATTR ( [OIL]. 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 you create a quick filter on a field from data source 1 and apply this. For more information,. This is one of the disadvantages of data blending in Tableau. Also, data blending is useful for combining data from published. ×Sorry to interrupt. Calculates the number of distinct values of a field within a partition. According to Tableau, this error can also appear when using a LOD expression in a blended view. ×Sorry to interrupt. 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. You will need a common column between the two tables in order to blend. 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. 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. 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. In the actual data I get the error: Cannot blend the secondary data source because one or more fields use an unsupported aggregation. When you blend, you can only have aggregate access to the rows in the secondary. I have a primary data source coming from a published data extract blending with a secondary data source coming from an Oracle Database. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. It is important to understand which is the primary source, it can impact. This feature would be really useful to ensure we can. Blending runs a query on each data source and joins the aggregated results of those queries. 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. LOD will not work if it is from the secondary datasource. Remove all dimensions from the secondary data source and ensure that the primary data source’s linking field is in view. Data blending; Table Calculations; Resolution Use one of the following workarounds: If possible, join instead of blend your data. Someone in the Community told me the following: "MAX isn't supported in. 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. I'm trying to show a distinct count of claims by branch. Hi, I have a scenario where I have to use Data Blending option to get certain metric values from Secondary Data Source. 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. You cannot filter data across secondary data sources. Currently, data sources that contain logical tables cannot be used as secondary data sources for data blending. 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. The unsupported aggregation happens when your aggregate requires row-level visibility to the secondary data source. I am trying to use the measures name filter functionality with two data sources. In a blend, secondary data sources are aggregated and the StoreID dimension would be aggregated to "*". Chicken + Choice of DrinkBurger + Choice of DrinkSpaghetti + Choice of Drink . I can add to filters from the data extracts. The first field you drop onto a worksheet defines the primary datasource. This happens only when the data sources are impala. 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. Summary:. This functionality was available in versions 8. 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". cannot blend aggregated data from secondary data source. Expand Post. As you can see I have 2 different data sources using a blend on the blood type. Filtering data across a worksheet's secondary data source is not currently supported in Tableau Desktop. 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. I'm using a cube data source as my primary and am attempting to blend with. If you are blending a cube data source, it must be the primary data source. CustomOverall (Primary) 2. I am blending (2) data sources based on the date. 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. ×Sorry to interrupt. The Products set contain the individual products within an Opportunity whereas the Opportunities set contain Sales metrics (i. It is important to understand which is the primary source, it can impact your view. Select Custom in the relationships list, and then get Attach. Now the nightmare starts: when I try to add the data source B and make all the relationships, it gives me the lovely error: "Cannot blend the secondary data source because one or more fields use the ZN function, which cannot be computed locally. Seemingly simple task is getting complicated in Tableau . I'm trying to show a distinct count of claims by branch. I want to display all values for all different data sources, and use them as filters, and filter the relevant records from both datasources at the same time. For more information, see Deciding Between Joining Tables and Blending Data. Chicken + Choice of Drink1 pc. I am trying to determine the Average Revenue per User by country for which my calculation is total revenue/unique subscribers. Answer. 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. For example, sheet A uses data source 1 as the primary data source; sheet B uses data source 1 as the secondary data source. In the secondary data source, select Data > Create Calculated Field. 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. So, basically, I am having issues with 2 calculations - the FIXED LOD and Remaining Value. 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. It says, "fields cannot be used from [data name] data source, because there is no relationship to the primary. 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. Data blending is particularly useful when the blend relationship—the linking fields—need to vary on a sheet-by-sheet. Data source filters. This feature would be really useful to ensure we can. Filter not recognizing blend relationship. “Cannot blend the secondary data source because one or more fields use an unsupported aggregation. 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. LOD will not work if it is from the secondary datasource. 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. In the Data window, right-click the relevant field. Data blending is particularly useful when the blend relationship—the linking fields—need to vary on a sheet-by-sheet. Before I check Date filters, I got this results. I have two data sources to be used but need the count distinct of users from both the data sources. I am trying to determine the Average Revenue per User by country for which my calculation is total revenue/unique subscribers. Therefore it cannot display null data. "Data Sources that contain logical tables cannot be used as secondary data sources for blending". Ken Flerlage (Member) 5 years ago. 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. 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. BR, NBBlended data sources cannot be published as a unit. The problem is when I try to calculate the median of that same measure. I have two data sources and doing a data blend. Secondary Data Source: Extract W. See Join your Data for instructions. Fee" I want to plot Gross Profit (i. Data from secondary data sources must always be aggregated in calculations. General Information. But I cant add filter Month from the Budget Excel file. But I cant add filter Month from the Budget Excel file. I am trying to blend the same data against the other because I wanted to show Same Period last Year. Resolution. The date values must be in the same format. Cannot blend the secondary data source because one or more fields use an unsupported aggregation It’s cable reimagined No DVR space limits. We cannot use ATTR if trying to create an LOD type calculation if blending data sources. And I use Join data source, after divide measures / row duplicate. Currently, I have to rebuild the worksheet and bring in the secondary source first. You can also define the relationship manually by right-clicking on the data source name in the Data pane, and selecting Relationships. gov which displays certain regions in the US (a geometry field is auto created in tableau which allows me to create this map easily), the second data source is a data pull from a data warehouse holding lat/long coordinates of specific points (able to create a point via calculated tableau field using the make point function). As 'Group' is from a secondary data source, I cannot simply use the sort buttons. Are use of grouped fields not allowed in data blending? I have two data sources: Opportunities and Products. A secondary data source can be used to re-alias the field values in a primary data source. Community Manager update. e. This happens only when the data sources are impala. Loading. IF min([Current Period ]) = true then [Display Sum Media Cost] end / sum(IF [Current Period ] = true then. "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. The version I am working with 10. Community Manager update. The data source with the KMs is the primary source. 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. I noticed that when the spatial file is the secondary data source, I cannot area plot it by double clicking the geometry variable. "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 blended data cannot be published to Tableau Online or Tableau Server. Notice that Calc1 gives you an asterisk if there are multiple values returned from the secondary source. Think of this layer as the Relationships canvas in the Data Source page. 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. 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. Give the action a sensible name and configure the action. A datetime field in the primary data source, for example, will not blend with a date field in the secondary data source. The secondary data source is indicated with an orange tick on the data source and an orange bar down the side of the Data pane. Date dimensions: For cube data sources, date dimensions are typically organized into hierarchies that contain levels such as year,. How to calculate Delta value. Right-click in the Data window and then. "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. There are a few possibilities: 1) Flip the blend so the primary is secondary and vice versa. Expand Post. The blend applies to that worksheet only. They both share a common field (State), and that is what I'm filtering on. I am creating a couple of formulas to display the total booking from the second data source to the first data source. Expand Post. 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). Loading. 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. For example, COUNTD(). In Tableau Desktop, navigate to Data > Edit Relationships. If you have to have row-level access on a. 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. I have 2 duplicate data sources that I am blending together (they are duplicate because I want to filter the same data source 2 different ways but show it in. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. Overall LOD will show correct result in Primary datasource. In your 2nd and 3rd data sources. Hi, I'll expand a bit on what @Chris wrote: There are some fundamental limits to what can be done with data blending and while there are workarounds that can get us the desired results in some circumstances those workarounds will not work in all circumstances (because Tableau never built out data blending to handle every. Are use of grouped fields not allowed in data blending? I have two data sources: Opportunities and Products. Excel . Cannot blend the secondary data source because one or more fields use an unsupported aggregation. 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. We don't get row-level data from secondary sources on a. There's no way to "swap.