Secondary data source has Order Date represented as separate Year and Month fields. Cannot blend the secondary data source because one or more fields use an unsupported aggregation . 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. Upvote Upvoted Remove Upvote Reply. Verify if one of the measures coming from the cube data source has a default aggregation different than SUM, MIN, MAX, COUNT. 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 . thanks. Think of this layer as the Relationships canvas in the Data Source page. I noticed that when the spatial file is the secondary data source, I cannot area plot it by double clicking the geometry variable. I am trying to use the below formula instead of countd function because my data comes from Impala. If I cant go the above way then is there a possibility to do the duration calculation using table calculations or some other way. 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. Error “Cannot blend the secondary data source because one or more fields use an unsupported aggregation. Data from a secondary source is displayed along with the primary source data. 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. blending [cannot blend Measure Values from a secondary data source] -----> this approach failed . E make table 2 the primary. If the user select May 2018. The date values you want to blend on must exist in both data sources. IF ATTR([Offer Status]) = "Hired" Then AVG([Comp_File]. 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. 2) Use data source filters instead of the Filters Shelf. The unsupported aggregation happens when your aggregate requires row-level visibility to the secondary data source. Data blending is a method for combining data from multiple 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. Use the geographic role in the primary data source on detail instead of the dimension from the secondary data source. I'm blending the 2 data sources by Service_Id. Any help would be appreciated!Also a data blend is only a LEFT join. 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'. Russell Christopher (Member) 10 years ago. The blend applies to that worksheet only. Some examples include: session cookies needed to transmit the website, authentication cookies, and security cookies. Another sheet:W2 is created with Data source A - taking Role in Row shelf. A datetime field in the primary data source, for example, will not blend with a date field in the secondary data source. There are a few possibilities: 1) Flip the blend so the primary is secondary and vice versa. Fee" I want to plot Gross Profit (i. 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. 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. Filtering data across a worksheet's secondary data source is not currently supported in Tableau Desktop. AUMTable (Secondary) 3. This is indicated by the following icon: The view you are trying to build will function if you use the date from the primary data source (Shipped): Let us know if this is clear, or if more explanation is required! Cheers, TimothyCube data sources are used as primary data sources to blend data in Tableau and cannot be used as secondary data sources. CSS ErrorIF user chooses month X and parameters/filters like gender/age/etc, THEN count all distinct users from data set #2 where the date of data set #2 is from 2017-08-01 through today's date. THEN add this total to the SUM of the projected_users from today's date through month X. The first field you drop onto a worksheet defines the primary datasource. So, in the dummy data, there are two tables from two data sources. The blend is not activated meaning a field from secondary DS is not used in the view. But I cant add filter Month from the Budget Excel file. Tableau Desktop; Blended data; Soluzione Use the following workaround: Create a new worksheet. I have 2 separate data sources that have similar fields. Now you see a new group field listed in the Population data source (primary) called State (group). The order in which fields are used determines which data source is the primary versus the secondary data source. Currently, I have to rebuild the worksheet and bring in the secondary source first. Change the default sort order of the field using the various options, and then click OK. ×Sorry to interrupt. And I can't explain why it does that. ” Causes and Workarounds for a Blending Limitation Errors 1. I receive this error: "Cannot blend the data source because one or more fields uses an unsupported aggregation". The data source with the KMs is the primary source. When I do the join between the SSAS Tabular Model (primary data. COUNTD is tough to work on while you. Viz cannot be filtered with secondary data source filter before loading the visualization so using "[DS_Name]. Resolution. In the actual data I get the error: Cannot blend the secondary data source because one or more fields use an unsupported aggregation. ×Sorry to interrupt. 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. Then try using the LOD expression from a secondary data source. 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. Hi . " And after that I can't make my workbook work at all. Here are the 7 major steps for putting this together: Set up your primary (main) and secondary (parameter) data sources. ) If only one of the tables requires row level information, consider making that the primary data source in the blend (I. 0 but was disabled (greyed out) in 8. 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. CustomOverall (Primary) 2. Ambiente. How to calculate Delta value. One data source has some values, the other one has different values. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. Call it [Start KM]: IF ATTR ( [KM Date])=ATTR ( [OIL]. Hello Everyone, I am using one data source which is a LIVE connection and I have duplicated same data source , the reason behind duplication is i want to have total of category which will be constant and it will not. Data source A has Role Column and Data source B also has Role Column. [OIL DATE]) THEN MIN ( [KMs]) END. Fields from the secondary data source used in the view have an orange tick. The reason of the errors being unsupported calculation in blend. 5 3 . Now when I drag and drop the transaction data, everything works just fine, but if I try to use the "Add all Subtotals" option to get the AVG Transactions value for each Market then I am getting the dreaded "Cannot blend the secondary data source because one or more fields use an unsupported aggregation" on my worksheet when I change the "Total. I am blending (2) data sources based on the date. For more information, see Use Relationships for Multi-table Data Analysis. e. 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. when I use A as primary data source and drag A. 2. Data blending is a method for combining data from multiple sources. If I cant go the above way then is there a possibility to do the duration calculation using table calculations or some other way. Yes - you can't bring COUNTD in data blending. The primary data source is just to filter for the invoices I want to look at. Therefore it cannot display null data. We don't get row-level data from secondary sources on a. Select Default Properties > Sort. Data & Connectivity. Fee". I. Please refer the below link and let me know if this helps to you. Loading. For more information, see Use Relationships for Multi-table Data Analysis. A datetime field may be converted to a date field using a calculation to remove the time. 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. 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. ). I can get all the fields into the view apart from the 'is vat exempt'. The two data sources are identical. When you blend, you can only have aggregate access to the rows in the secondary source. Currently, data sources that contain logical tables cannot be used as secondary data sources for data blending. [amount] into the view, it gives less than. This can restrict many values from the secondary data source. 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. 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". Filtering data across a worksheet's secondary data source is not currently supported in Tableau Desktop. You can create a federated database using linked tables/worksheets. Thanks. Drag the State (group) dimension over the Region dimension on the Rows shelf to replace it. I've blended on user ID. Loading. Some of the function doesn't work properly when we use blending like COUNTD(), LOD{} expression. 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. Credits to Jonathan Drummey for the below workaround Cannot blend the secondary data source because one or more fields use an unsupported aggregation . Loading. 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. 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. How to tackle “Cannot blend the secondary data source because one or more fields use an… How to tackle “Cannot blend the secondary data source because one or more fields use an unsupported aggregation” while blending Multiple data sources. Primary and Secondary sources in data blending. then i added a secondary data source from google sheet , which has the fuel amount. Data sources can contain logical tables not be used as secondary data sources for data blending. You have a nice example to use for filing a support case, and I recommend that you do that. I have been working on Blending feature for a while in different situations and. There is a possibility that the values can be restricted from the secondary data. 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. Data blending is particularly useful when the blend relationship. All three options are demonstrated in the attached workbook using the sample data set Superstore. There's a set of views/calcs that show a metric, (metric C) counting distinct number of accounts contacted per person per week (e. Expand Post. [OIL DATE]) THEN MIN ( [KMs]) END. The unsupported aggregation happens when your aggregate requires row-level visibility to the secondary data source. In the Data window, right-click the relevant field. The value gets reduced based on filters@@@ from all data source. I would like to visualize number of distinct hardware. 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. 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. No. order_date. 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 . As you can see I have 2 different data sources using a blend on the blood type. {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. We cannot publish a blended data source as a single data source on the server. 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. I have two data sources to be used but need the count distinct of users from both the data sources. COUNTD - Blended data. Non-additive engine are entirety functions that errichten outcomes that cannot be aggregated along a dimension. Data blending: Cube data sources can only be used as the primary data source for blending data in Tableau. " inner cross database join on BU Code with a data source filter set up on UPPER([ID])=UPPER(USERNAME()) on the DS2 source. Both fields are linked in worksheet. They must be in the same format. You cannot filter data across secondary data sources. 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. When you blend, you can only have aggregate access to the rows in the secondary. See Join Your Data for more information. 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. See Join Your Data for more information. Jim. 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. I have two data sources and I have blended them together. I get around it by adding "max" in front of the first one again, and it says calculation is valid, but once I try to add it to the view it gives the error "Cannot blend the secondary data. 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. But the source calc is a countD. I am trying to blend the same data against the other because I wanted to show Same Period last Year. 1) Duplicate the field in primary datasource. One on table it was all upper case on the other one it was a mix of upper and lower case. Tableau has two inbuilt data sources named Sample-superstore and Sample coffee chain. I am just trying to filter every Data source, by choosing a field that every Data source has. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. Instead, publish each data source separately (to the same server) and then blend the published data sources. But I cant add filter Month from the Budget Excel file. 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. the blended data cannot be published to Tableau Online or Tableau Server. Currently, I have to rebuild the worksheet and bring in the secondary source first. I am trying to . then i added a secondary data source from google sheet , which has the fuel amount. See the attached updated workbook. Before I check Date filters, I got this results. ×Sorry to interrupt. Secondary data source: spatial file containing the geometry. Here's the data blend view with the secondary data source selected so we can see what blend fields are used:. 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. A datetime field in the primary data source, for example, will not blend with a date field in the secondary data source. duplicate the date field. 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. Chicken + Choice of DrinkBurger + Choice of DrinkSpaghetti + Choice of Drink . This means a data blend can’t be published as a data source for others to use. Data blending is particularly useful when the blend relationship—the linking fields—need to vary on a sheet-by-sheet. since i want only offername from secondary source to the view and the measures are produced from primary datasource is pos_trn. Also, in the attached I have added both Calc1 and Calc2 to the tooltip in Sheet 9. "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. 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. You can choose whether functional and advertising cookies apply. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. 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 . Aside from consulting the primary origin or source, data can also be collected through a third party, a process common with secondary data. Data blending is a method for combining data from multiple sources. Data blending is a good option when you have multiple data sources that cannot be combined through relationships. I'm noticing you are using the Date field from the secondary data source you are working with. It says, "fields cannot be used from [data name] data source, because there is no relationship to the primary. I have two data sets that are linked across Date and Product Category fields. For more information, see Troubleshoot Data Blending; Blended data sources cannot be published as a unit. I am using tableau 2020. e. From my primary data source I have a dimension in columns say 'Customer Segment'. Advantages: Very easy to write and implement. 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. In the secondary data source, select Data > Create Calculated Field. While on a view, right click a data source, click replace data source. [Field_Name]":"Value_to_filter" in the Options will not work. Place Organisation Identifier on the level of detail shelf (from the primary source, or both sources) and the blend should work. For more information, see Troubleshoot Data Blending; Blended data sources cannot be published as a unit. Cannot Blend Secondary Data Source - Unsupported Aggregation. Nitish Pamarty (Member) 7 years ago. " message. Filtering data across a worksheet's secondary data source is not currently supported in Tableau Desktop. I'm using a data blending method, where: Primary data source: Contains the ID I'm trying to count. 3. Common warnings and errors when blending data sources No relationship to the primary data source. 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. I tried data blending keeping File C as primary and A & B as secondary data source with DD number as relationship. I made a waffle chart grid using an excel data source that contains 3 fields: Rows, Columns and Percentage. General Information. e. Option 2: Create a calculation using WINDOW_SUM() Drag the linking field(s) from the secondary data source to. 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]). 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. A datetime field may be converted to a date field using a calculation to remove the time portion. Fee - Cost) over time. Process for Creating the Dynamic “Parameter”. Expand Post. This is the final step and will result in filtering between the blended data sources at your desired level of granularity. Applies to: Tableau Cloud, Tableau Desktop, Tableau Server Data blending is a method for combining data from multiple sources. All customer IDs are under a dimension called "Global ID". 1, the ability to "Show Empty Rows" (or columns) was removed when you use a secondary data source. I want to display all values for all different data sources, and use them as filters, and filter the relevant records from both datasources at the same time. The data in the primary data source is the main data on which Tableau defines graphs and charts. 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. The limitation with Tableau and secondary data sources stinks. 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. This feature would be really useful to ensure we can. BR, NBBlended data sources cannot be published as a unit. Hi Andy, Following up on this - Tableau has been promoting the jump to relationships, in place of joins. 0 and 7. 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). " Filtering Across Multiple Data Sources Using a Parameter; Cause A sheet cannot be filtered by a field from a secondary data source. 4. Currently, data sources that contain logical tables cannot be used as secondary data sources for data blending. In the data window, switch to [name1] data source, and click at least one link icon to blend these data sources. If that does not help,. In the secondary data source, select Data > Create Calculated Field. We use three kinds of cookies on our websites: required, functional, and advertising. 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. 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 get all data from main data source and ONLY matching data from secondary data source. Let say from DS1 if i am making it as primary datasource then i can get the. 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. 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. 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. In the Data window, switch to the [data name2] data source. You combine data in the logical layer using relationships (or noodles). In the calculation dialog box, do the following: In the name text box, enter Sales for Store - South. Loading. All data from a secondary source comes back as an aggregate -- even if there is only one value from the secondary source. Please post you twbx workbook so we can see if there a way . Final Words. 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 the == function, which cannot be computed locally. I am trying to use the measures name filter functionality with two data sources. 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. 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. 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. Create a “Blend Field” with a value of 1 in both your primary and secondary. Using Tableau; Upvote; Answer. 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. 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. If you make sheet 1 as the primary data source and do the data blending with sheet 2. ×Sorry to interrupt. For details, see Troubleshoot Data Blending. Currently, it's not working, the filter I try to add in the dashboard appears red in my spreadsheet and tells me that : "Data sources containing logical tables cannot be used as a secondary data source for data blending". Fixed, countd functions won't work with the secondary datasources. with blends, we are only able to support aggregates (like SUM, MIN, MAX. "Filtering Across Multiple Data Sources Using a Parameter; Cause A sheet cannot be filtered by a field from a secondary data source. Upvote Upvoted Remove Upvote Reply. If you want to filter data across secondary data sources, consider. I have three different data source . 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 It’s cable reimagined No DVR space limits. In Tableau Desktop, navigate to Data > Edit Relationships. Now, in dashboard D1 : has two worksheets W1 and W2. 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. See. [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. As we know the link cant be established unless we use this common dimension (Region Filter) in the view, we can mimic the view by adding the Region Filter Dimension to rows/Columns shelf and uncheck the show header. Consider joining the two data sources together using Tableau Prep, and then you can use that data as a. the branch field I'm using from the primary data source. Verify if one of the measures coming from the cube data source has a default aggregation different than SUM, MIN, MAX, COUNT. What does this mean? I want to create a city filter and apply it both to the SAS data source as well as the pivoted CSV file. If you create a quick filter on a field from data source 1 and apply this quick filter to. 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)]. But seems we cannot blend 2 secondary data source with same field. But there are few workaround for it. , 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. Expand Post. Also, after I get the total per PO Number, I want to get a remaining value that subtracts the Total Cost (from the secondary data source) from the Total per PO Number. Select Custom in the relationships list, and then get Attach. ×Sorry to interrupt. Some examples include: cookies used to. The version I am working with 10. 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). Instead, the. 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. I tried to recreate the data as close as possible. 2) Use this duplicate field in the view instead of the original. The chart should display: countd. I establish the blend relationships explicitly by going to Data -->Edit Blend Relationships, and selecting the fields that should be related. Resolution. The solution. In the Relationships dialog box, under Secondary data source select Custom, and then click Add. " inner cross database join on BU Code with a data source filter set up on UPPER([ID])=UPPER(USERNAME()) on the DS2 source. 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. 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. I am able to achieve the desired results but I am getting a warning ' Fields cannot be used from the [name of secondary data source] data source, because there is no blend relationship to the primary data source. 2)Count Distinct from Secondary workaround. 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. targets. Your secondary data source does not have the blend activated, you'll need to click on the link and turn it red to activate:. This happens only when the data sources are impala. When Bugs History is a live connection to Vertica living inside my workbook all is well. e. Open. 1. When I calculate the average of a measure and use the filter, it works perfectly fine. Whichever data source you "use first" in a view (by dragging in a field) becomes Primary. CSS ErrorBy default Tableau Desktop wraps fields from a secondary data source in an aggregation in calculated fields. 4, I tried to blend products (secondary) to storefront (primary) based on Sku. with blends, we are only able to support aggregates (like SUM, MIN, MAX. I am trying to determine the Average Revenue per User by country for which my calculation is total revenue/unique subscribers. Community Manager update. "Cannot blend the secondary data source because one or more fields use an unsupported aggregation" I have tried the following calculations but have not been able to figure this out. In this source create a calculated field to pull out the KMs on the date of oil change. Thank you . Date dimensions: For cube data sources, date dimensions are typically organized into hierarchies that contain levels such as year,. 1.