Additional Information While replacing ATTR() with MIN() will cause "Automatic" grand totals to show, the grand totals might not be the expected values. 3. " Expand Post. with blends, we are only able to support aggregates (like SUM, MIN, MAX. Because there are no linking fields in this view. Hi. The version I am working with 10. 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. 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. This feature would be really useful to ensure we can. We can see these by activating secondary data source and looking at the dimensions window, the linking dimensions will have an orange chain icon. Cube data sources do not support pass-through connections. Left. (It is a field that contains account names (company) in the sample data. However, it gives me following error: "Cannot blend the secondary data source because one or more fields use an unsupported aggregation"We have an enterprise data source that is an SSAS Tabular model. Data blending; Table Calculations; Resolution Use one of the following workarounds: If possible, join instead of blend your data. The Products set contain the individual products within an Opportunity whereas the Opportunities set contain Sales metrics (i. When I create an additional calculated field in the primary data source with: COUNTD(Person ID) + COUNTD(Person ID), I receive the cannot blend the secondary data source because. Data of any sort coming from a secondary source must come as an aggregate of some sort. Loading. 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). 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. 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. A datetime field in the primary data source, for example, will not blend with a date field in the secondary data source. Data. Data blending is a method for combining data from multiple sources. Data from secondary data sources must always be aggregated in calculations. My goal is to show CY Actuals as bars, with a line for PY Actuals and a line for Budget. CSS ErrorLoading. For more information, see Use Relationships for Multi-table Data Analysis. General Information. 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. The data is blended on customer. Status, Stage, etc). For more information, see Troubleshoot Data Blending; Blended data sources cannot be published as a unit. Here are the 7 major steps for putting this together: Set up your primary (main) and secondary (parameter) data sources. 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. 2 came the introduction of a brand-new data model. ×Sorry to interrupt. Now try to recreate the sheet and link the 2nd and 3rd data. Step 1: Create the Parameter. targets. You have a nice example to use for filing a support case, and I recommend that you do that. Some of my table calculation are the follow: RED FIELD Tableau Name of First Math Course= IF [Tableau Period of First Math Course]== [Academic Period] AND ( [Subject Desc]=='Mathematics' OR [Subject. LOD will not work if it is from the secondary datasource. Seemingly simple task is getting complicated in Tableau . The order in which fields are used determines which data source is the primary versus the secondary data source. 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 created calculated fields "Fiscal Year" and "Fiscal Month" on my secondary Superstore example to simulate this. This means that when a cube data source is published, you cannot make a connection from Tableau Server using the data source. ×Sorry to interrupt. Data blending is a good option when you have multiple data sources that cannot be combined through relationships. 3) COUNTD with Secondary DS (Blending) Thanks,. The blend is not activated meaning a field from secondary DS is not used in the view. All the data is in the secondary/blended data source. CSS ErrorData blending is based on two key components- Primary data sources and Secondary data sources. FIXED requires that you have row-level access to the rows in the 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. The date values you want to blend on must exist in both data sources. 3 and I have created aggregates AGG for fields from data extract and excel file. 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. 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. Resolution. , 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. Currently, data sources that contain logical tables cannot be used as secondary data sources for data blending. Expand Post. Data sources can contain logical tables not be used as secondary data sources for data blending. This can restrict many values from the secondary data source. Consider joining the two data sources together using Tableau Prep, and then you can use that data as a. Filter not recognizing blend relationship. ×Sorry to interrupt. 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. on Rows, Columns, Pages, or the Marks Card. This feature would be really useful to ensure we can. Complex as the problem may be, the solution is comfortingly simple. 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. Your secondary data source does not have the blend activated, you'll need to click on the link and turn it red to activate:. We cannot use ATTR if trying to create an LOD type calculation if blending data sources. Hi All, I have blended primary and secondary data sources. Loading. LOD calculation and blended data sources. It says, "fields cannot be used from [data name] data source, because there is no relationship to the primary. I like to have the ability to swap a primary data source with a secondary data source for data blending in a workbook. The date values you want to blend on must exist in both data sources. The limitation with Tableau and secondary data sources stinks. First data source looks like below. Observations : 1. For more information, see Troubleshoot Data Blending; Blended data sources cannot be published as a unit. We would like to show you a description here but the site won’t allow us. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. I'm trying to show a distinct count of claims by branch. 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. Data blending has some limitations regarding non-additive aggregates such as COUNTD, MEDIAN, and RAWSQLAGG. 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. Change the default sort order of the field using the various options, and then click OK. The reason of the errors being unsupported calculation in blend. In short, Tableau connects to multiple data sources, sends independent queries to those data sources, and then combines (or “blends”) the aggregated results of the independent queries on a single worksheet. ×Sorry to interrupt. 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. cannot blend aggregated data from secondary data source. In my primary, I define another calculated field to do the aggregation for each project by tier: VendorClass: if max [Secondary]. e. It's a technical limitation. 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. If you want to filter data across secondary data sources, consider. For more information, see Troubleshoot Data Blending; Blended data sources cannot be published as a unit. Resolution. My problem happens when I go to the dashboard, I want to filter on FW (fiscal week) and have crosstab. 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. if that is the case I could get same results by joining 2 data sources just by linking Area and Qtr not all 4 and without using LOD for secondary data source i. 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. Are use of grouped fields not allowed in data blending? I have two data sources: Opportunities and Products. Verify if one of the measures coming from the cube data source has a default aggregation different than SUM, MIN, MAX, COUNT. If there is another. You can create a federated database using linked tables/worksheets. 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. You combine data in the logical layer using relationships (or noodles). Hi Justin, Thanks for your quick reply. Give the action a sensible name and configure the action. There are a few possibilities: 1) Flip the blend so the primary is secondary and vice versa. When you data changes, you need to redo the. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. The secondary data source will have an orange checkmark on it. 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. In a blend, the secondary data source can only contribute aggregated values using the level of detail defined by the linking fields that appear in the view, so when you remove them, the. To provide comparative data: Secondary data can be used to compare and contrast findings across different studies or datasets. For example, select Analysis > Create Calculated Field, and in the Formula text box, type the. I have two data sources and doing a data blend. Hi Andy, Following up on this - Tableau has been promoting the jump to relationships, in place of joins. An orange tick indicates a secondary data source (Promotions). See Join Your Data for more information. id, A. 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. This is one of the disadvantages of data blending in Tableau. 1. Blending takes place in the 6th step of the order of operation after the data table for the individual worksheet is set and the filters applied - data from the secondary source are aggregated at the level of the link and brought to the primary as. Option 2: Join tables that are in the same data source, instead of blending them. IF ATTR([Offer Status]) = "Hired" Then AVG([Comp_File]. In this case the cross database join will effectively act like the. Output - End output which I need is a table with a single row data for each country with 3 columns Country name, Total Count of DD, Total Cost for DD. While using blending data source some of the function doesn't perform well in calculation like COUNTD(), LOD{}, MEDIAN() etc. Instead, publish each data source separately (to the same server) and then blend the published data sources. Please check the attached workbook for details. Secondary data sources cannot have logical tables (except when they satisfy specific conditions). Hello Jim, Thank You for your reply. With the release of Tableau 8. 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. thanks. 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. Cannot blend the secondary data source since one or more search use certain unsupported aggregation. You can use data blending when you have data in separate data sources that you want to analyze together on a single sheet. I have two data sets: the first data set is a shp file from data. Instead, publish each data. 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 . You want to apply a filter to related data sources - which is an option if multiple data sources have a field with the same name and data type, or if you define explicit relationships between data sources from the Data menu. 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" Attached is the workbook that could provide more clarity on my question. Step 3: Blend the fields with the target data source using simple blending method (clicking those broken links into red)Hi Saukarsha, The linking fields need to be somewhere on the view in order for the blend to work. Non-additive aggregates are aggregate functions that produce results that cannot be aggregated along a dimension. Filter each of the data sources independently on the more granular dimensions. As 'Group' is from a secondary data source, I cannot simply use the sort buttons. 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. Loading. Error: Cannot Blend the secondary data source because one or more fields use an unsupported aggregation. if you have blended data sources you can not use lods One of the drawbacks of blended sources . For more information, see Deciding Between Joining Tables and Blending Data. The concept of data blending is, for every match in the primary table there should be exactly one row item in your secondary table, in the view of this concept any aggregation on the secondary table will always be distinct by default. I am trying to blend the same data against the other because I wanted to show Same Period last Year. [Field_Name]":"Value_to_filter" in the Options will not work. . I have two data sources which I have blended together on two fields: branch and date. 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. I establish the blend relationships explicitly by going to Data -->Edit Blend Relationships, and selecting the fields that should be related. 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. As you can see I have 2 different data sources using a blend on the blood type. I have 2 separate data sources that have similar fields. If I cant go the above way then is there a possibility to do the duration calculation using table calculations or some other way. 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. You must double-click a logical table in the Data Source page canvas to go to the physical layer of the canvas. See. To blend on summary data, you can do the following: Create a. In your 2nd and 3rd data sources. 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 have three different data source . Select Default Properties > Sort. mdb which will be used to illustrate data blending. 3) Select the now grey link next to the original field in. LoadingWhen you try to add URL actions to dashboards, fields from secondary data sources cannot be added to the URL. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. Moreover, blending is a kind of left join, not exactly a join. Maxdate) There is one more way, make the datasource which is using the fixed calculation to primary data source. Make sure that you are blending on dimensions present in the view or on. Please post you twbx workbook so we can see if there a way . [tier] == 2 'Top Vendors' else 'Mid Vendors'. Then you can simply show one filter control on your dashboard and set it to apply to all related data sources. The aggregation is all on primary source data. 3 and I have created aggregates AGG for fields from data extract and excel file. I've blended on user ID. This means that it forces the view to display only relevant data in the secondary data source. 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. 3 and I have created aggregates AGG for fields from data extract and excel file. Relationships: Join: Combines columns: Yes: Cross database joins will not work with all data sources: Joins: Blend: Combines columns: No: Fields from the secondary data source cannot be brought in to the view unless there is a match on. 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. Blending requires primary and secondary data sources. I can add to filters from the data extracts. Twbx and also the . Data blending is a method for combining data from multiple sources. In this example, Superstore Sales is the primary data source and Coffee Chain is the secondary data source. Expand Post. Beginning with Tableau Desktop 2020. I tried to recreate the data as close as possible. the count of claims I'm getting from the secondary data source, by counting distinctly a measure called claimid. Common Issue #1: Cannot blend the secondary data source because one or more fields use an unsupported aggregation The aggregation methods of COUNTD,. Tableau will throw an error: “Cannot blend the secondary data source because one or more fields use an unsupported aggregation. Any help would be appreciated!Also a data blend is only a LEFT join. Aside from consulting the primary origin or source, data can also be collected through a third party, a process common with secondary data. This didn't work alas, "cannot blend secondary data source because one or more fields use an unsupported aggregation" I am using a filter from a different datasource to filter by region . The data source with the KMs is the primary source. In your workbook sheet2 does not contain 5/22 date. ×Sorry to interrupt. Currently, I have to rebuild the worksheet and bring in the secondary source first. Beyond that personally I tend to do the work necessary to avoid using data blending in production data sources & views. They must be in the same format. 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. Using Tableau; Upvote; Answer. 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 addition, you cannot blend Measure Values from a secondary data-source, so that rules out this approach as well. As 'Group' is from a secondary data source, I cannot simply use the sort buttons. Option 1: Join the data sources with a cross-database join instead of blending. We don't get row-level data from secondary sources on a blend. 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. Data coming from a secondary source is ALWAYS aggregated at the level of the link - even if there is 'no need to add anything' that's just the way blending works - it happens after the data table dimensions are set and you are loading values into the data table for the individual worksheet additionally, data coming from the secondary source are always aggregated at the level of the link when brought to the primary source - the individual records are no longer available and you are not able to filter across the various data sources at that point - that is the long way of saying you will have to join or use a relationship - not. Create a “Blend Field” with a value of 1 in both your primary and secondary. Thanks for your help everyone! I've found what was happening: I had some filters on the secondary data source. The data are sorted, but each row only shows one month of data with the other five columns blank. 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. Common field is the employee ID. Step 2: Make it a context filter. A Level of Detail (LOD) expression is being taken from the secondary data source. If I cant go the above way then is there a possibility to do the duration calculation using table calculations or some other way. When blending in Tableau, there is always a primary source and a secondary data source. This is the response I received from Tableau Support:Cause. When Bugs History is a live connection to Vertica living inside my workbook all is well. This would be a great time saver, with all of the calculations and linking changing as well. I didn't realize this until now, but it appears you cannot use blending when one of your data sources uses the new(ish) relationship model. Instead of using relationships, double-click into your table to get to the. Excel 1 pc. Advantages: Very easy to write and implement. Expand Post. Drag the 2016 Population measure to the Columns. The primary data source will be identified automatically from any metrics you put on the worksheet first. You can choose whether functional and advertising cookies apply. General Information. However when I use B as primary data source, drag [A]. To fix this, we had to add the fields being used in the blending relationship onto the view: Aside from a few of these, we didn’t need to combine the data in very complicated ways. The. 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. then i added a secondary data source from google sheet , which has the fuel amount. Effective visualization. I am creating a couple of formulas to display the total booking from the second data source to the first data source. You are trying to bring fields from a second data source into a calculation that is being created in the primary (first) data source and aggregations are not consistent - data from the second source comes over as an aggregate - look into what the aggregation is on and how does that relate to what you have in the primary data baseI'm trying to blend two data sources on a single field, say 'Program Description'. The data in the primary data source is the main data on which Tableau defines graphs and charts. From what I understand, it's because the link variable must be present in the view, or else it does not work. Primary Data Source: Extract S. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. "Data Sources that contain logical tables cannot be used as secondary data sources for blending". A datetime field in the primary data source, for example, will not blend with a date field in the secondary data source. I have the total number of headcounts on one data set, and the number of attritions on the other so I am trying to write number of records (datasource1)/total headcounts (datasource2) and i get the red pill telling me "cannot blend the secondary datasource because one or more fields use an unsupported aggregation". 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. "Cannot blend the secondary data source because one or more fields use the / function, which cannot be computed locally. ×Sorry to interrupt. Marked as. A datetime field in the primary data source, for example, will not blend with a date field in the secondary data source. Good morning . The unsupported aggregation happens when your aggregate requires row-level visibility to the secondary data source. I have some extra supplemental data in a CSV file that I would like to join to one of the common fields between the two so I can pull some of the SSAS measures by the supplemental data's dimensions that I've blended. Select Analysis > Create Calculated Field. Secondary Data Source: Contains data relating to the usage of a website (hits). Pick the secondary data source in of Secondary data source pane. 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. Data blending is particularly useful when the blend relationship. In this source create a calculated field to pull out the KMs on the date of oil change. 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. Click oField cannot breathe used from the [name by secondary data source] data original, because there is no mixed relationship to the primary data original. Secondary data source: spatial file containing the geometry. Resolution. In this source create a calculated field to pull out the KMs on the date of oil change. png - Ben-Sullins's library "Cannot blend the secondary data source because one or more fields use an unsupported. If you have to have row-level access on a. Chicken + Choice of Drink1 pc. Set up the primary and. 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. When you blend, you can only have aggregate access to the rows in the secondary source. The default view that you first see in the Data Source page canvas is the logical layer of the data source. 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. So make sure you're not using such function while blending. Click oLoading. But I cant add filter Month from the Budget Excel file. The attached workbook and the following steps illustrate the process. However, when I follow your advice, each group splits into 6 rows (one for each month - January through June). newBranchProjection (Secondary) When I try to add COUNTD([DistrictId]) from my primary to text table. In the secondary data source, select Data > Create Calculated Field. 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. A COUNTD of Order ID should be all I need to show this data but it always results in a "Cannot blend the secondary data source because one or more of the fields use an unsupported aggregation". Ritesh Bisht (Member) 6 years ago. 3. 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 . "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. So you don't get in the case of data blending. Fields from the secondary data source used in the view have an orange tick. Data blending: Cube data sources can only be used as the primary data source for blending data in Tableau. This link might help you: Cannot blend the secondary data source because one or more fields use an unsupported aggregation. Both Primary and Secondary data sources have duplicate rows due to multiple joins in data prep. 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. Data from a secondary source is displayed along with the primary source data. You can choose whether functional and advertising cookies apply. 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. "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'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. " I have seen a few posts on it and found an issue logged about it as far back as version 8. " Is there a way to circumvent this issue? Or perhaps a different method entirely. One on table it was all upper case on the other one it was a mix of upper and lower case. 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. You combine data in the logical layer using relationships (or noodles). "Budget" is only contained in an Excel file data source. Please find the complete blog here ----> COUNTD with secondary DS Tableau(Blending) Workbook is attached. Final Words. For more information,. All data from a secondary source comes back as an aggregate -- even if there is only one value from the secondary source. 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. Loading. I have two datasets; one is a shape file that contains regions and locations. Status, Stage, etc). 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 . 2. Cannot blend the secondary data source because one or more fields use an unsupported aggregation issue. 2) Use this duplicate field in the view instead of the original. 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). 2 and later. Any existing, automatic blend kontakte is visible (and pot be deleted by suspend over the row and clicking the x). We cannot publish a blended data source as a single data source on the server. 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. I'm trying to blend two data sources on a single field, say 'Program Description'. And I use Join data source, after divide measures / row duplicate. cannot blend aggregated data from the secondary data source with data on this sheet. For more information, see Use Relationships for Multi-table Data Analysis. Does anyone have any Ideas how I can apply a universal filter. Data blending tools can present their findings as visualizations, such as infographics and charts, after querying data sources and aggregating relevant information. 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. Cannot Blend Secondary Data Source - Unsupported Aggregation. Loading. You cannot change that. 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]). Blending from a polygon-based map to an existing data source which uses 1-to-many joins. Are you talking about Tableau Prep or Tableau Desktop? Any chance you can share a sample of your data? Expand Post. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. This type of bases does not allow for blend relationship, therefore, you cannot use a filter like this. Think of this layer as the Relationships canvas in the Data Source page. Filter each of the data sources independently on the more granular dimensions. - Dataset 1, records the amount spent on ads as "Cost" - Dataset 2 records the revenue generated by orders as "Proj. 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. Hi there, I got a question about how can I count distinct customer ID? I have 10k customer IDs, some of them appear more than once. I'm blending the 2 data sources by Service_Id. ×Sorry to interrupt. Make the data source that contains the field that you want to use in the URL action the primary data source in. an aggregated left join where the aggregation of the secondary data cannot be used to increase the level of detail of the primary data. There is a possibility that the values can be restricted from the secondary data. 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". Because in Tableau, you don't use COUNTD function when Blending data source. Better collaboration. Alternate names:. 0 but was disabled (greyed out) in 8. blending takes place in step 6 of the Order of Operation after all the context and dimension filters have been applied - you will not be able to filter across the data sets after that point - you would need to have joined data or use a relationship The issue comes when I try and add a metric that is an aggregate of the two different sources. To solve your issue you should ->go to Connections 2 , keep only facADP and remove all other relationships ->go to its physical layer (double click facADP)Two Data Sources A and B, one work sheet:W1 has used both this A and B to represent View. I'm using a cube data source as my primary and am attempting to blend with. In the data window, the blue tick indicates the Primary data source (Sales in the image below). It also means you cannot create a workbook using the. The data source with the KMs is the primary source. [% age]>=SUM([Percentage]) . 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. e. Here is situation I am facing, I have blended two data sources and created a worksheet. Data blending works only as a left join. Whichever data source you "use first" in a view (by dragging in a field) becomes Primary. 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. 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. I cannot change the case of the data to upper or lower. Instead, publish. I am trying to determine the Average Revenue per User by country for which my calculation is total revenue/unique subscribers. the blended data cannot be published to Tableau Online or Tableau Server. In this case the cross. I'm noticing you are using the Date field from the secondary data source you are working with. I can add to filters from the data extracts. - 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. Secondary data source has Order Date represented as separate Year and Month fields. 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. 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. amount into the view, it gives me the correct sum. From my primary data source I have a measure in rows, say 'Measure, which is 'distinct count of Pol Number' or 'sum of Premium' depending on a boolean parameter's values (TRUE or FALSE) The unsupported aggregation happens when your aggregate requires row-level visibility to the secondary data source.