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. The data is blended on customer. and tried to plot chart, the chart complains that "Data sources that contain logical tables cannot be used as secondary data sources for data binding". i. Hi All, I have blended primary and secondary data sources. Filtering data across a worksheet's secondary data source is not currently supported in Tableau Desktop. There is a possibility that the values can be restricted from the secondary data. png - Ben-Sullins's library "Cannot blend the secondary data source because one or more fields use an unsupported. I think I need to define the relationship between the data sources. I'm trying to blend two data sources on a single field, say 'Program Description'. The unsupported aggregation happens when your aggregate requires row-level visibility to the secondary data source. Using Tableau; Upvote; Answer. When you blend, you can only have aggregate access to the rows in the secondary. 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. 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. e. Just aggregates (like SUM, MIN, MAX. Please see if it helps , here it says that problem is with COUNT & they have provided one alternative way as well . 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. Expand Post. No. 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. Loading. In the Data window, right-click the relevant field. The problem is when I try to calculate the median of that same measure. Common field is the employee ID. 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. 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. Option 1: Include all linking fields in the view, and aggregate secondary fields Data blending will work when the secondary data source uses logical tables, as long as the following conditions are met: All active linking fields from the primary data source must be included in the view on a shelf other than the Filters shelf Link Primary Source and all other secondary source on this Field Created from step 3- 4 using Edit Data blend Relationships 6. Data blending is particularly useful when the blend relationship. 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. FIXED requires that you have row-level access to the rows in the secondary source. I can get all the fields into the view apart from the 'is 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]). Tableau Desktop; Blended data; Soluzione Use the following workaround: Create a new worksheet. Place Organisation Identifier on the level of detail shelf (from the primary source, or both sources) and the blend should work. I've created the first chart with no problem, but I. Please refer the below link and let me know if this helps to you. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. 2 and later. 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. LOD expressions are used when running complex queries with multiple dimensions at the data source level. Option 2: Create a calculation for a more dynamic sort. 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. Tableau Desktop Resolution Try one of the following options, as appropriate for your workbook: It may be possible to cross database join instead of blending. A datetime field in the primary data source, for example, will not blend with a date field in the secondary data source. Summary:. Data source A has Role Column and Data source B also has Role Column. Can't see what you are actually doing but Blending data has its limits. This means a data blend can’t be published as a data source for others to use. Here's the data blend view with the secondary data source selected so we can see what blend fields are used:. 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. To provide comparative data: Secondary data can be used to compare and contrast findings across different studies or datasets. If this aggregation is ATTR() then the grand totals may be blank. Hey all, I'm trying to create a filter in my dashboard such as my two spreadsheets are linked with this filter. Filter each of the data sources independently on the more granular dimensions. I have two data sources which I have blended together on two fields: branch and date. Resolution. Thanks bharat ! but i think client column is common to both the source so i would able to blend the data. For details, see Troubleshoot 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. During Data Blending in Tableau, if the secondary data source has any LOD (Level of Detail) Expressions, they are taken down after the data blending process is finished. I have two data sources and I have blended them together. 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. 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). Data blending have some limitations regarding non-additive total such like COUNTD, MEDIAN, and RAWSQLAGG. Upvote Upvoted Remove Upvote Reply. 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. In the past, I've just changed my primary table to the one with the calculation. For more information, see Troubleshoot Data Blending; Blended data sources cannot be published as a unit. 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. But I cant add filter Month from the Budget Excel file. Data & Connectivity. Secondary data is one of the two main types of data, where the second type is the. duplicate the date field. I receive this error: "Cannot blend the data source because one or more fields uses an unsupported aggregation". "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. 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. 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. Which version of Desktop are you using? See attached the superstore workbook (. We use three kinds of cookies on our websites: required, functional, and advertising. Make sure that you are blending on dimensions present in the view or on all of the. Fields cannot be used from the [name of secondary data source] data source, because there is no blend relationship to the primary data source. 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. 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. Resolution. month([date])=month(Parameter. The first field you drop onto a worksheet defines the primary datasource. 3 and I have created aggregates AGG for fields from data extract and excel file. Click on the ‘Add Action’ button and choose ‘Change Set Values’. Next, drag Category from the Orders data source onto the view, then select the Orders data source and click the chain icon to blend on Order ID. I tried data blending using the zip codes as a common field but I am facing very slow performance. 3. Date dimensions: For cube data sources, date dimensions are typically organized into hierarchies that contain levels such as year,. It says, "fields cannot be used from [data name] data source, because there is no relationship to the primary. 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. Upvote Upvoted Remove Upvote Reply. twbx. Data blending is used when the linking fields need to vary on a sheet-by-sheet basis for different visualizations. with blends, we are only able to support aggregates (like SUM, MIN, MAX. please check the attached workbook. Jim. Left. Because there are no linking fields in this view. 3) COUNTD with Secondary DS (Blending) Thanks,. Data blending has some limitations regarding non-additive aggregates such as COUNTD, MEDIAN, and. 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. In your 2nd and 3rd data sources. 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. Hi Data Modeler , I have an idea which I cannot test right away. Beyond that personally I tend to do the work necessary to avoid using data blending in production data sources & views. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. The reason of the errors being unsupported calculation in blend. [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. This would be a great time saver, with all of the calculations and linking changing as well. 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. I'm blending student data (primary) and staff data (second). I have two data sets: the first data set is a shp file from data. Blending with CountD and LODs. the count of claims I'm getting from the secondary data source, by counting distinctly a measure called claimid. you will get 5/22 date. I am trying to blend the same data against the other because I wanted to show Same Period last Year. I have two data sources and I have blended them together. Blending requires primary and secondary data sources. " message. Data > Edit Relationships . Because the question is related to how the data sources are being related, it would help to see the real data structure. All data from a secondary source comes back as an aggregate -- even if there is only one value from the secondary source. I'm using a cube data source as my primary and am attempting to blend with. Some examples include: session cookies needed to transmit the website, authentication cookies, and security cookies. 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). Identify your data sources for common data types: both data sources must have a string or date field for linking data sources. 3. I am blending (2) data sources based on the date. I get a blank sheet on the dashboard using the secondary data source because it looks for CASE SENSITIVE ABC . If you have to have row-level access on a. Another way to approach this is to do a join of the data outside Tableau via a federated data source. But I cant add filter Month from the Budget Excel file. FIXED requires that you have row-level access to the rows in the secondary source. It takes advantage of the data collected from previous research and uses it to carry out new research. Data blending is a method for combining data from multiple sources. 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. 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. 2) DB2 blending doesn't support non-additive aggregates like COUNTD() from secondary sources. I am trying using { FIXED : SUM[(portfolioValue)]}. Overall LOD will show correct result in Primary datasource. 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. Sometimes , it's automatically working but sometimes it says 'Unsupported Aggregation' . The data source with the KMs is the primary source. [OIL DATE]) THEN MIN ( [KMs]) END. The order in which fields are used determines which data source is the primary versus the secondary data source. Give the action a sensible name and configure the action. ×Sorry to interrupt. 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)]. Instead, publish each data. My problem happens when I go to the dashboard, I want to filter on FW (fiscal week) and have crosstab. There's a set of views/calcs that show a metric, (metric C) counting distinct number of accounts contacted per person per week (e. ×Sorry to interrupt. If there is another aggregation type such as AGG_AVG being used, change it to one of the supported aggregation listed above in the cube database itself before using in Tableau Desktop. 1) Vizible Difference: Getting around Count Distinct in a secondary data source. This is the response I received from Tableau Support:Cause. 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. How do I blend these data sources by year? - The Tableau Community. xls files). then i added a secondary data source from google sheet , which has the fuel amount. Currently, I have to rebuild the worksheet and bring in the secondary source first. Can anybody please help me with a solution. In addition, you cannot blend Measure Values from a secondary data-source, so that rules out this approach as well. When blending in Tableau, there is always a primary source and a secondary data source. ” Causes and Workarounds for a Blending Limitation Errors. Data blending; Table Calculations; Resolution Use one of the following workarounds: If possible, join instead of blend your data. The aggregation is all on primary source data. on Rows, Columns, Pages, or the Marks Card. However, I still get that message saying cannot blend the secondary data source because one or more fields use an unsupported aggregation". Cannot blend the secondary data source because one or more fields use an unsupported aggregation. CSS ErrorLoading. targets. Marked as. Primary Data Source: Contains a list of all employees and their role. You must double-click a logical table in the Data Source page canvas to go to the physical layer of the canvas. For example, COUNTD(). Data of any sort coming from a secondary source must come as an aggregate of some sort. Ritesh Bisht (Member) 6 years ago. Become a Better Analyst in Just 5 Minutes a Week. ×Sorry to interrupt. 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 have two datasets; one is a shape file that contains regions and locations. However, when the linking dimension is not in the view, non-additive aLoading. They both share a common field (State), and that is what I'm filtering on. order_date = B. 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. The Products set contain the individual products within an Opportunity whereas the Opportunities set contain Sales metrics (i. ×Sorry to interrupt. 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. Chicken + Choice of DrinkBurger + Choice of DrinkSpaghetti + Choice of Drink . [tier] == 0 then "Low vendors" elseif max [Secondary]. Primary and Secondary sources in data blending. Expand Post. 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. You cannot filter data across secondary data sources. Twb, . cannot blend secondary data source because one or more fields use an unsupported aggregation beacuse of LOD. I have three different data source . 2, users would define joins and unions between physical tables in which Tableau would create a singular, flat table for analysis. You combine data in the logical layer using relationships (or noodles). I have 2 data sources, A and B, they are linked by data blending with A. ×Sorry to interrupt. This is one of the disadvantages of data blending in Tableau. "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. 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. Data blending is particularly useful when the blend relationship—the linking fields—need to vary on a sheet-by-sheet. Therefore it cannot display null data. amount into the view, it gives me the correct sum. This happens only when the data sources are impala. 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. 3) Select the now grey link next to the original field in. Calculates the number of distinct values of a field within a partition. 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. Instead, publish each data source separately (to the same server) and then blend the published data sources. Community Manager update. Thank you . Resolution. Marked as. the count of claims I'm getting from the secondary data source, by counting distinctly a measure called claimid. I read that this is not possible. This means that it forces the view to display only relevant data in the secondary data source. 2. Show moreA workbook or mock data would be a sure thing to comment and try upon it. The primary data source will be identified automatically from any metrics you put on the worksheet first. 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. Excel . id = B. 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. 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. You can create a federated database using linked tables/worksheets. Data from a secondary source is displayed along with the primary source data. Please check the attached workbook for details. e. 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. 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. You can choose whether functional and advertising cookies apply. Seemingly simple task is getting complicated in Tableau . Tableau will throw an error: “Cannot blend the secondary data source because one or more fields use an unsupported aggregation. e. while data blending is a great feature for exploratory analytics and data validation and incredibly useful to have as an extra tool when nothing else will meet the requirements I find that there's a tradeoff with added. I am trying to use the below formula instead of countd function because my data comes from Impala. For more information, see Use Relationships for Multi-table Data Analysis. 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). Both Primary and Secondary data sources have duplicate rows due to multiple joins in data prep. LOD will not work if it is from the secondary datasource. I use the Opp ID to relate them. What I'm trying to do is, create a new column in the 'data to map to' table, saying I only want to see 'PY Sales' numbers where the 'Period' column is equal to the MAXIMUM of 'Sales Cycle' column from 'Data to Map from' table, which is from. 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 . From what I understand, it's because the link variable must be present in the view, or else it does not work. If one of those measures is brought into a view with a linking dimension not in the view, or a linking dimension is turned on that is not in the view, the pill will turn red, the view will turn grey, and hovering over the pill reveals a "Cannot blend the secondary data source because one or more fields use an unsupported aggregation. If you want to filter data across secondary data sources, consider. Select Default Properties > Sort. It is important to understand which is the primary source, it can impact your view. ” We use three kinds of cookies on our websites: required,. If there is another. See Join your Data for instructions. 0 and 7. I am trying to use the measures name filter functionality with two data sources. an aggregated left join where the aggregation of the secondary data cannot be used to increase the level of detail of the primary data. 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. Upvote Upvoted Remove Upvote Reply. " I have seen a few posts on it and found an issue logged about it as far back as version 8. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. LOD will not work if it is from the secondary datasource. When you data changes, you need to redo the. 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, excluding. Regards. Are use of grouped fields not allowed in data blending? I have two data sources: Opportunities and Products. As 'Group' is from a secondary data source, I cannot simply use the sort buttons. The value gets reduced based on filters@@@ from all data source. And I want to add one of the field from secondary dataset to be in the filter. newBranchProjection (Secondary) When I try to add COUNTD([DistrictId]) from my primary to text table. Data blending: Cube data sources can only be used as the primary data source for blending data in Tableau. I can't do a join because they are two different file formats. 2) Use data source filters instead of the Filters Shelf. The version I am working with 10. Process for Creating the Dynamic “Parameter”. 2, Tableau introduces relationships and splits. Someone in the Community told me the following: "MAX isn't supported in. Proj. - Dataset 1, records the amount spent on ads as "Cost" - Dataset 2 records the revenue generated by orders as "Proj. According to Tableau, this error can also appear when using a LOD expression in a blended view. As 'Group' is from a secondary data source, I cannot simply use the sort buttons. When trying to use COUNTD() it gives this error: cannot blend secondary data source because one or more fields use an unsupported aggregation when hovering over the Measures because it is now red. 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. Community Manager update. 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. Secondary Data Source: Contains data relating to the usage of a website (hits). In the Data pane, select the Store - North data source. Filtering data across a worksheet's secondary data source is not currently supported in Tableau Desktop. In the secondary data source, select Data > Create Calculated Field. g. Step 1: Create the Parameter. In the data window, switch to [name1] data source, and click at least one link icon to blend these data sources. {FIXED [Machine Nr] : COUNT ( [Machine Nr] )} / {FIXED [Machine Nr] : COUNT ( [Machine Nr] )} This works fine when there is no secondary data source but when I blend with a secondary data source it grays. Functional cookies enhance functions, performance, and services on the website. General Information. Data blending is a method for combining data from multiple sources. 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. It's a technical limitation. 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. 1. See Join Your Data for more information. Aggregate the date fields at the MY. It is important to understand which is the primary source, it can impact. . However, when I follow your advice, each group splits into 6 rows (one for each month - January through June). I'm noticing you are using the Date field from the secondary data source you are working with. 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). Final Words. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. Now you see a new group field listed in the Population data source (primary) called State (group). 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 . We use three kinds of cookies on our websites: required, functional, and advertising. " inner cross database join on BU Code with a data source filter set up on UPPER([ID])=UPPER(USERNAME()) on the DS2 source. This type of bases does not allow for blend relationship, therefore, you cannot use a filter like this. 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. "Data Sources that contain logical tables cannot be used as secondary data sources for blending". I am confused, as I am not even trying to blend Data from both 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. " Filtering Across Multiple Data Sources Using a Parameter; Cause A sheet cannot be filtered by a field from a secondary data source. Note: If the geographic role does not exist in the primary data source, then it will be necessary to create the view with the data source that contains the geographic role as the primary data source. In the Data pane, select the State data source (secondary). This happens regardless if I drag it on the rows or on the Marks space as a 'text'. you get all data from main data source and ONLY matching data from secondary data source. Cube data sources do not support pass-through connections. Non-additive aggregates are aggregate functions that produce results that cannot be aggregated along a dimension. You cannot filter data across secondary data sources. BR, NBBlended data sources cannot be published as a unit. 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. Cannot Blend Secondary Data Source - Unsupported Aggregation. [Field_Name]":"Value_to_filter" in the Options will not work. Currently, I have to rebuild the worksheet and bring in the secondary source first. 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. 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. ) A LOD calc is also trying to do stuff at the row level. So if you drag Category from the Orders data source, it will automatically mark Orders as the primary data source. 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. Thank you. 1 because it can cause Tableau to unexpectedly quit. Filtering data across a worksheet's secondary data source is not currently supported in Tableau Desktop. CSS ErrorI want to blend data from two different sources but on blending the data the filters from primary data source do not work if the case is different in the secondary data source. The data in the primary data source is the main data on which Tableau defines graphs and charts. I have two data sources and doing a data blend. I am just trying to filter every Data source, by choosing a field that every Data source has. How ever # no of changes and # of Problems are calculating entire database values. From Primary Data Source drag the measure names and measure values . While on a view, right click a data source, click replace data source. Data blending is a method for combining data from multiple sources. ” Causes and Workarounds for a Blending Limitation Errors 1. 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. All customer IDs are under a dimension called "Global ID". 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. Tableau Desktop 2018. I'm able to successfully connect to both data sources and set up the relationship, with the Teradata extract being primary and the Excel sheet being secondary. The blend applies to that worksheet only. 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. In the Data pane, switch until the [name of subsidiary datas source] data root, and click at least one link icon to blend these datas sourcing. See the attached updated workbook. In a blend, secondary data sources are aggregated and the StoreID dimension would be aggregated to "*". To blend on summary data, you can do the following: Create a. From my primary data source I have a dimension in columns say 'Customer Segment'. Cannot blend the secondary data source because one or more fields use an unsupported aggregation . Try one of the following options, as appropriate for your workbook: It may be possible to cross database join instead of blending. This is a dynamic way to make data in sets stand out and gain greater real-world context for users. Call it [Start KM]: IF ATTR ( [KM Date])=ATTR ( [OIL].