Date dimensions: For cube data sources, date dimensions are typically organized into hierarchies that contain levels such as year,. I can add to filters from the data extracts. data source. 2) DB2 blending doesn't support non-additive aggregates like COUNTD() from secondary 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 noticed that when the spatial file is the secondary data source, I cannot area plot it by double clicking the geometry variable. A secondary data source can be used to re-alias the field values in a primary data source. Also, data blending is useful for combining data from published. Use blends when:. Hi Andy, Following up on this - Tableau has been promoting the jump to relationships, in place of joins. This can help researchers identify. I like to have the ability to swap a primary data source with a secondary data source for data blending in a workbook. Thanks for your help everyone! I've found what was happening: I had some filters on the secondary data source. ”. 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. 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. g. We use three kinds of cookies on our websites: required, functional, and advertising. This is one of the disadvantages of data blending in Tableau. Thanks. In the secondary data I have a LOD field called Total_Category_Response defined as { FIXED [Category]: SUM([Respose_ValI am working on a dashboard where I am using the data blending feature to visualize the data from different data sources in to a single view. Beyond that personally I tend to do the work necessary to avoid using data blending in production data sources & views. Better collaboration. Hi. If you want to filter data across secondary data sources, consider the following alternatives: Join tables that are in the same data source, instead of blending them. I'm blending student data (primary) and staff data (second). - 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. Option 2: Create a calculation for a more dynamic sort. Next, create a table calc using the [Start KM] to calculate the total KMs: from Primary data source from Secondary data source. I have a Remaining Value calculation, but it is not correct. I have two data sources which I have blended together on two fields: branch and date. 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. Then you can simply show one filter control on your dashboard and set it to apply to all related data sources. Data blending is particularly useful when the blend relationship—the linking fields—need to vary on a sheet-by-sheet. A data blend cannot filter on dimensions that do not exist in the Primary data source. If the user select May 2018. You can choose whether functional and advertising cookies apply. Observations : 1. thanks. 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. Primary and Secondary sources in data blending. Ken Flerlage (Member) 5 years ago. 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. Therefore it cannot display null data. 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. Community Manager update. Loading. Chicken - VMBurger + Choice of DrinkBurger - VMSpaghetti + Choice of DrinkSpaghetti - VM Trying to do a COUNTD() from a secondary data source and got this dreaded error: > Cannot blend the secondary data source because one or more fields use an unsupported aggregation . According to Tableau, this error can also appear when using a LOD expression in a blended view. . Selected as Best Selected as Best Upvote Upvoted Remove Upvote 1 upvote. In the past, I've just changed my primary table to the one with the calculation. the count of claims I'm getting from the secondary data source, by counting distinctly a measure called claimid. A datetime field in the primary data source, for example, will not blend with a date field in the secondary data source. Expand Post. The secondary data source will have an orange checkmark on it. Any existing, automatic blend kontakte is visible (and pot be deleted by suspend over the row and clicking the x). the count of claims I'm getting from the secondary data source, by counting distinctly a measure called claimid. Then try using the LOD expression from a secondary data source. Please check the attached workbook for details. - Dataset 1, records the amount spent on ads as "Cost" - Dataset 2 records the revenue generated by orders as "Proj. Relationships cannot be formed between tables from data sources published to Tableau Server or Tableau Online. Another way to approach this is to do a join of the data outside Tableau via a federated data source. I'm using a cube data source as my primary and am attempting to blend with. 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. I've attached my workbook that contains 2 data sources that are blended by invoice number. 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]). I am blending (2) data sources based on the date. 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). An orange tick indicates a secondary data source (Promotions). 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. When I try to graph the distinct count of project ids vs the VendorClass, however, I see every project getting the. Cube data sources do not support pass-through connections. For secondary data source you get same result by managing relationships in your case just Area and Qtr. A datetime field may be converted to a date field using a calculation to remove the time. 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. While on a view, right click a data source, click replace data source. E make table 2 the primary. 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. I read that this is not possible. Yes - you can't bring COUNTD in data blending. Instead, publish each data. While on a view, right click a data source, click replace data source. 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. LOD expressions are used when running complex queries with multiple dimensions at the data source level. Here is an example of what I am trying to accomplish:Data blending is a method for combining data from multiple sources. Upvote Upvoted Remove Upvote Reply. Build whatever calculated fields from the secondary that need to be used in in the primary. Unknown file type Total from Secondary Data Source. Here is the sample. Data blending has some limitations regarding non-additive aggregates such as COUNTD, MEDIAN, and. " inner cross database join on BU Code with a data source filter set up on UPPER([ID])=UPPER(USERNAME()) on the DS2 source. Loading. You can also define the relationship manually by right-clicking on the data source name in the Data pane, and selecting Relationships. All data from a secondary source comes back as an aggregate -- even if there is only one value from the secondary source. 0, but I imagine someone has been able to identify what is causing the issue. 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. General Information. Data blending is used when the linking fields need to vary on a sheet-by-sheet basis for different visualizations. “Cannot blend the secondary data source because one or more fields use an unsupported aggregation. Change the default sort order of the field using the various options, and then click OK. 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. Size() is a great choice for unique counts across data sources if you can create a view where every unique row is displayed. * Supplemental data from a secondary data source is needed. In Tableau Desktop, navigate to Data > Edit Relationships. i. I have two data sources and doing a data blend. Ritesh Bisht (Member) 6 years ago. I am trying to use the below formula instead of countd function because my data comes from Impala {FIXED [Machine Nr] : COUNT([Machine Nr] )} / {FIXED [Machine Nr] : COUNT([Machine Nr] )} This works fine when there is no secondary data source but when I blend with a secondary data source it grays out my sheet i. Option 2: Join tables that are in the same data source, instead of blending them. 1. Cannot blend the secondary data source because one or more fields use an unsupported aggregation . One approach that succeeds in adding another measure is to add the measure in question to your. A datetime field in the primary data source, for example, will not blend with a date field in the secondary data source. 4, I tried to blend products (secondary) to storefront (primary) based on Sku. I have two data sources to be used but need the count distinct of users from both the data sources. Think of this layer as the Relationships canvas in the Data Source page. 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. Are use of grouped fields not allowed in data blending? I have two data sources: Opportunities and Products. 3 and I have created aggregates AGG for fields from data extract and excel file. From my primary data source I have a dimension in columns say 'Customer Segment'. I receive this error: "Cannot blend the data source because one or more fields uses an unsupported aggregation". One on table it was all upper case on the other one it was a mix of upper and lower case. Filtering data across a worksheet's secondary data source is not currently supported in Tableau Desktop. mdb which will be used to illustrate data blending. We use three kinds of cookies on our websites: required, functional, and advertising. 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. Current Year Actuals and Prior Year Actuals are housed in a corporate transnational data source. They must be in the same format. If you have to have row-level access on a. Now, in dashboard D1 : has two worksheets W1 and W2. I am trying to blend the same data against the other because I wanted to show Same Period last Year. Fields cannot be used from the [name of secondary data source] data source, because there is no blend relationship to the primary data source. Tableau Desktop; Blended data; Soluzione Use the following workaround: Create a new worksheet. Moreover, blending is a kind of left join, not exactly a join. Expand Post. Fields from the secondary data source used in the view have an orange tick. with blends, we are only able to support aggregates (like SUM, MIN, MAX. See Troubleshoot Data Blending - Tableau for more information on this and other errors that may occur while using data blending. Tableau has two inbuilt data sources named Sample-superstore and Sample coffee chain. 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. CSS ErrorLoading. CustomOverall (Primary) 2. Data & Connectivity. Cannot blend the secondary data source because one or more fields use an unsupported aggregation issue. I am using tableau 2020. I have three different data source . Best solution. Resolution. blending [cannot blend Measure Values from a secondary data source] -----> this approach failed . Secondary Data Source: Contains data relating to the usage of a website (hits). Currently, I have to rebuild the worksheet and bring in the secondary source first. The point is to do row-level work in the secondary source, so that when the blend pulls data it doesn't have to do the row-level work. 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. IF min([Current Period ]) = true then [Display Sum Media Cost] end / sum(IF [Current Period ] = true then. The default view that you first see in the Data Source page canvas is the logical layer of the data source. Option 2: Join tables that are in the same data source, instead of blending them. Whichever data source you "use first" in a view (by dragging in a field) becomes Primary. 3 and I have created aggregates AGG for fields from data extract and excel file. I'm trying to create a frequency distribution as a percent of total for individual products in a single category on one chart, then dual axis a second chart with the frequency distribution of the category for comparison purposes. ×Sorry to interrupt. Applies to: Tableau Cloud, Tableau Desktop, Tableau Server Data blending is a method for combining data from multiple sources. I would like to visualize number of distinct hardware. 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. I have been working on Blending feature for a while in different situations and. We can see these by activating secondary data source and looking at the dimensions window, the linking dimensions will have an orange chain icon. A Level of Detail (LOD) expression is being taken from the secondary data source. I'm blending the 2 data sources by Service_Id. No long-term contract. The first field you drop onto a worksheet defines the primary datasource. But I cant add filter Month from the Budget Excel file. Use the geographic role in the primary data source on detail instead of the dimension from the secondary data source. 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. It's a technical limitation. All three options are demonstrated in the attached workbook using the sample data set Superstore. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. If that does not help,. then i added a secondary data source from google sheet , which has the fuel amount. I am just trying to filter every Data source, by choosing a field that every Data source has. [OIL DATE]) THEN MIN ( [KMs]) END. 3. I want to do a basic data listing showing customer, order no, postcode & vat exempt. Also, in the attached I have added both Calc1 and Calc2 to the tooltip in Sheet 9. you will get 5/22 date. 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. [OIL DATE]) THEN MIN ( [KMs]) END. Case 1: If you are facing this issue before report is been developed then try to use data source filter to limit the data flow and finish the development. If 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. Maxdate) There is one more way, make the datasource which is using the fixed calculation to. 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. Cannot blend the secondary data source because one or more fields use the == function, which cannot be computed locally. I've blended on user ID. 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). I have two data sets that are linked across Date and Product Category fields. Currently, data sources that contain logical tables cannot be used as secondary data sources for data blending. I think I need to define the relationship between the data sources. Currently, I have to rebuild the worksheet and bring in the secondary source first. Because the question is related to how the data sources are being related, it would help to see the real data structure. 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. Let say from DS1 if i am making it as primary datasource then i can get the. [amount] into the view, it gives less than. Filtering data across a worksheet's secondary data source is not currently supported in Tableau Desktop. 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. In the Add/Edit Field Mapping dialog box, select the date fields from the primary and secondary data sources, and then click OK twice. 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. This will be identified with a blue checkmark. Thank you. CustomOverall (Primary) 2. The data is blended on customer. I have my primary data source with dimensions customer and order no and a secondary data source with customer, postcode and an 'is vat exempt' boolean field. 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. Option 2: Create a calculation using WINDOW_SUM() Drag the linking field(s) from the secondary data source to. Observations : 1. This is the response I received from Tableau Support:Cause. And I want to add one of the field from secondary dataset to be in the filter. Data blending brings in additional information from a secondary data source and displays it with data from the primary data source directly in the view. In data source A, I have COUNTD(Person ID) and in data source B, I have COUNTD(Person ID). The reason of the errors being unsupported calculation in blend. Hello Jim, Thank You for your reply. With the recent release of Tableau Desktop 2020. We cannot publish a blended data source as a single data source on the server. For more information,. Final Words. As it turns out, I didn't actually end up using an LOD, but thought I might have to, hence the reason for JOINING the data together as shown in. I have 2 data sources, A and B, they are linked by data blending with A. Data of any sort coming from a secondary source must come as an aggregate of some sort. The. I made a waffle chart grid using an excel data source that contains 3 fields: Rows, Columns and Percentage. From my primary data source I have a dimension in columns say 'Customer Segment'. I have two datasets; one is a shape file that contains regions and locations. 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 . 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. Overall LOD will show correct result in Primary datasource. Loading. 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). 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. The version I am working with 10. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. You can create a federated database using linked tables/worksheets. The two data sources are identical. cannot blend aggregated data from the secondary data source with data on this sheet. And I can't explain why it does that. 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. All the data is in the secondary/blended data source. 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 secondary data source need to be my transaction file and primary data source need to be my budget file. Seemingly simple task is getting complicated in Tableau . "Cannot blend the secondary data source because one or more fields use the == function, which cannot be computed locally. LoadingWhen you try to add URL actions to dashboards, fields from secondary data sources cannot be added to the URL. You can choose whether functional and advertising cookies apply. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. Give the action a sensible name and configure the action. I can get all the fields into the view apart from the 'is vat exempt'. I have two data sources and I have blended them together. I am using blending and created Relationship but i am having problem in terms of getting distinct count from one of the data sources. 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. Try one of the following options, as appropriate for your workbook: It may be possible to cross database join instead of blending. 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. [tier] == 0 then "Low vendors" elseif max [Secondary]. Additional Information While replacing ATTR() with MIN() will cause "Automatic" grand totals to show, the grand totals might not be the expected values. Your secondary data source does not have the blend activated, you'll need to click on the link and turn it red to activate:. Try one of the following options, as appropriate for your workbook: It may be possible to cross database join instead of blending. In addition, you cannot blend Measure Values from a secondary data-source, so that rules out this approach as well. Some examples include: cookies used to. This type of bases does not allow for blend relationship, therefore, you cannot use a filter like this. 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. [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. CSS ErrorBy default Tableau Desktop wraps fields from a secondary data source in an aggregation in calculated fields. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. Data > Edit Relationships . Calculates the number of distinct values of a field within a partition. I am confused, as I am not even trying to blend Data from both Data Sources. Hi . Which version of Desktop are you using? See attached the superstore workbook (. 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. This link might help you: Cannot blend the secondary data source because one or more fields use an unsupported aggregation. e. However, when I follow your advice, each group splits into 6 rows (one for each month - January through June). The unsupported aggregation happens when your aggregate requires row-level visibility to the secondary data source. I cannot change the case of the data to upper or lower. 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. To blend on summary data, you can do the following: Create a. Expand Post. To blend on summary data, you can do the following: Create a. 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. - Dataset 1, records the amount spent on ads as "Cost". In your 2nd and 3rd data sources. Expand Post. . 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. Tableau automatically adds an aggregation (SUM) around the column from the secondary source. 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. When I do the join between the SSAS Tabular Model (primary data. Remove all dimensions from the secondary data source and ensure that the primary data source’s linking field is in view. Community Manager update. Why are values from the secondary data source not appearing in a blended data source view? They did not exist in the primary data source. If you create a quick filter on a field from data source 1 and apply this. I'm noticing you are using the Date field from the secondary data source you are working with. The secondary data source just pulls in some names to associate with ID numbers in the primary and some filters for the staff data. 2. It says, "fields cannot be used from [data name] data source, because there is no relationship to the primary. Jim. When you blend, you can only have aggregate access to the rows in the secondary source. Now we have to use W2 as Filter - to filter out the data. 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. Hi . I am getting Cannot blend secondary data source because one or more fields used an unsupported aggregation. Data blending works like a ___ join. 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. They both share a common field (State), and that is what I'm filtering on. Trying to do a COUNTD() from a secondary data source and got this dreaded error: Cannot blend the secondary data source because one or more fields use an unsupported aggregation Did some research on this and found plenty of "workarounds" with no success, because apparently blending sucks and I shouldn't be using it. 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. . 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. If I cant go the above way then is there a possibility to do the duration calculation using table calculations or some other way. I am trying to blend the same data against the other because I wanted to show Same Period last Year. Trying to do a COUNTD() from a secondary data source and got this dreaded error: > Cannot blend the secondary data source because one or more fields use an unsupported aggregation . Then, after data blending, the final graph cannot show the data related to the South and East. So, in the dummy data, there are two tables from two data sources. See. Instead, publish each data source separately (to the same server) and then blend the published data sources. Non-additive engine are entirety functions that errichten outcomes that cannot be aggregated along a dimension. Expand Post. " Expand Post. 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. Step 1: Create the Parameter. This. Secondary data source has Order Date represented as separate Year and Month fields. This means that it forces the view to display only relevant data in the secondary data source. I need to get a count distinct of Patient ID from the Primary data source, as well as count distinct of Patient ID from the Secondary data source in one worksheet. A datetime field may be converted to a date field using a calculation to remove the time portion. For example, COUNTD(). 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. If you want to make sure you don't lose any measures from the secondary source then either. "Budget" is only contained in an Excel file data source. The Products set contain the individual products within an Opportunity whereas the Opportunities set contain Sales metrics (i. Hello Ritish, You could use Size() and a Las() function as a filter and get the same output. 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. targets. [Field_Name]":"Value_to_filter" in the Options will not work. Blended data sources. You combine data in the logical layer using relationships (or noodles). order_date. 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. drag the secondary measures to measure values section . I tried data blending keeping File C as primary and A & B as secondary data source with DD number as relationship. "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. I tried to recreate the data as close as possible. "Filtering Across Multiple Data Sources Using a Parameter; Cause A sheet cannot be filtered by a field from a secondary data source. ×Sorry to interrupt. The Products set contain the individual products within an Opportunity whereas the Opportunities set contain Sales metrics (i. Cannot blend the secondary data source because one or more fields use an unsupported aggregation Did some research on this and found plenty of "workarounds" with no. Data blending is particularly useful when the blend relationship—the linking fields—need to vary on a sheet-by-sheet. 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. Fee" I want to plot Gross Profit (i. Data blending is particularly useful when the blend relationship. A datetime field may be converted to a date field using a calculation to remove the time portion. 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. The date values must be in the same format. In order to create the waffle chart I am blending it with another datasource using the calculated field defined as [Week 5 (Week5Bond)]. With the release of Tableau 8. Now you see a new group field listed in the Population data source (primary) called State (group). 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 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. CSS ErrorData blending is based on two key components- Primary data sources and Secondary data sources. Data sources can contain logical tables not be used as secondary data sources for data blending. 4, I tried to blend products (secondary) to storefront (primary) based on Sku. 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". ×Sorry to interrupt. I have a primary data source coming from a published data extract blending with a secondary data source coming from an Oracle Database. amount into the view, it gives me the correct sum. Because there are no linking fields in this view. In the data window, the blue tick indicates the Primary data source (Sales in the image below). 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.