In my primary, I define another calculated field to do the aggregation for each project by tier: VendorClass: if max [Secondary]. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. I use the Opp ID to relate them. A secondary data source can be used to re-alias the field values in a primary data source. The Products set contain the individual products within an Opportunity whereas the Opportunities set contain Sales metrics (i. And I want to add one of the field from secondary dataset to be in the filter. As you can see I have 2 different data sources using a blend on the blood type. 1 because it can cause Tableau to unexpectedly quit. [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. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. No long-term contract. - Dataset 1, records the amount spent on ads as "Cost" - Dataset 2 records the revenue generated by orders as "Proj. The unsupported aggregation happens when your aggregate requires row-level visibility to the secondary data source. I have quick filters from the primary data source and I am trying to represent distinct. e. I tried data blending using the zip codes as a common field but I am facing very slow performance. đ„Check my Websiteđ„ Troubleshoot Data Blending in Tableau Part 2 here SHOP After you have used the secondary data source to provide aliases for the primary data source, you no longer need the secondary data source and can close it. I am getting Cannot blend secondary data source because one or more fields used an unsupported aggregation. Tableau Community (Tableau)Data blending creates a link on common dimensions--where those commonalities do not exist in the two data sources, values will be excluded. i. Select Default Properties > Sort. Also, data blending is useful for combining data from published. I am trying to create a waffle chart. From Primary Data Source drag the measure names and measure values . This can restrict many values from the secondary data source. ) So the issue is really the introduction of the group on the sheet. I'm blending the 2 data sources by Service_Id. Status, Stage, etc). If there is another. The date values you want to blend on must exist in both data sources. 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. 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. That's probably your problem. 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. What steps do I need to do to do this?It shows the next message: "Cannot blend the secondary data source because one or more fields use an unsupported aggregation". 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. So yes, in [Actual Hrs] you can only use the value from the secondary as an aggregate, and that's why you see: SUM([Networkdays (Test blend data calculation)]. Instead, publish each data. Data blending is a method for combining data from multiple sources. month([date])=month(Parameter. Not able to share for time being. Notice that Calc1 gives you an asterisk if there are multiple values returned from the secondary source. The date values must be in the same format. For more information, see Troubleshoot Data Blending; Blended data sources cannot be published as a unit. Here is the sample. 2, users would define joins and unions between physical tables in which Tableau would create a singular, flat table for analysis. Show moreA workbook or mock data would be a sure thing to comment and try upon it. I am already using a Custom SQL query as an additional data source and trying to do blending based on the relationship on BU code field from RPT and AD. duplicate the date field. newBranchProjection (Secondary) When I try to add COUNTD([DistrictId]) from my primary to text table. 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. like below . ×Sorry to interrupt. However, I still get that message saying cannot blend the secondary data source because one or more fields use an unsupported aggregation". 1. One on table it was all upper case on the other one it was a mix of upper and lower case. Data & Connectivity. [amount] into the view, it gives less than. * Blend in the summary of a large dataset to reduce query time. Step 1: Connect to your data and set up. - Data to Map from - Data to Map to . In the calculation dialog box, do the following: In the name text box, enter Sales for Store - South. 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. But the source calc is a countD. The secondary data source consists of 1 Fact table (Agg_ActualVsExpected) and 4 Dim tables, one of the Dim tables is Dim_Service, whose primary key is Service_Id, which appears also in the Fact table. please check the attached workbook. We have a calculated filed where an aggregation (COUNTD) is done on a filed of secondary data source. Error: Cannot Blend the secondary data source because one or more fields use an unsupported aggregation. Instead, the. 2) DB2 blending doesn't support non-additive aggregates like COUNTD() from secondary 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. " I have seen a few posts on it and found an issue logged about it as far back as version 8. If this aggregation is ATTR() then the grand totals may be blank. 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. Dominic Laird(Member) 5 years ago. 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. I am already using a Custom SQL query as an additional data source and trying to do blending based on the relationship on BU code field from RPT and AD. 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. The solution. Common Issue #1: Cannot blend the secondary data source because one or more fields use an unsupported aggregation The aggregation methods of COUNTD, MEDIAN, and other non-additive aggregate functions can cause fields to become invalid. To 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). It has data from 2003-2012. 3. It is important to understand which is the primary source, it can impact. Hi everyone, my first attempt to blend 2 data sets was not successful (Sheet called 1st attempt - attached), because its appears the following message "Cannot blend the secondary data source because one or more fields use an unsupported aggregation". Before I check Date filters, I got this results. We are blending two data sources. 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. 5 3 . You combine data in the logical layer using relationships (or noodles). In the secondary data source, select Data > Create Calculated Field. Modify the calculation to not use table functions;. To blend on summary data, you can do the following: Create a. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. In the Data pane, select the Store - North 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. Blending runs a query on each data source and joins the aggregated results of those queries. For more information, see Troubleshoot Data Blending; Blended data sources cannot be published as a unit. You have a nice example to use for filing a support case, and I recommend that you do that. 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. Fields from the secondary data source used in the view have an orange tick. My problem happens when I go to the dashboard, I want to filter on FW (fiscal week) and have crosstab. Resolution. Common warnings and errors when blending data sources No relationship to the primary data source. Note: If the geographic role does not exist in the primary data source, then it will be necessary to create the view with the data source that contains the geographic role as the primary data source. The blend applies to that worksheet only. Community Manager update. 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 a parameter with a calculated field to filter the secondary data source at the row level. So, in the dummy data, there are two tables from two data sources. In order to create the waffle chart I am blending it with another datasource using the calculated field defined as [Week 5 (Week5Bond)]. 3. In addition, you cannot blend Measure Values from a secondary data-source, so that rules out this approach as well. Expand Post. And I use Join data source, after divide measures / row duplicate. The aggregation is all on primary source data. Size() is a great choice for unique counts across data sources if you can create a view where every unique row is displayed. Cube (multidimensional) data sources have certain characteristics that make them unique in Tableau. 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. 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. The data are sorted, but each row only shows one month of data with the other five columns blank. Viz cannot be filtered with secondary data source filter before loading the visualization so using "[DS_Name]. 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". Instead, publish each data source separately (to the same server) and then blend the published data sources. 2. " And after that I can't make my workbook work at all. â. 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 two data sets: the first data set is a shp file from data. I have a primary data source coming from a published data extract blending with a secondary data source coming from an Oracle Database. In the Add/Edit Field Mapping dialog box, select the date fields from the primary and secondary data sources, and then click OK twice. 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 sets that are linked across Date and Product Category fields. Selected as Best Selected as Best Upvote Upvoted Remove Upvote 1 upvote. I'm using a cube data source as my primary and am attempting to blend with. Hi Kurt! No, not really. While on a view, right click a data source, click replace data source. The primary data source will be identified automatically from any metrics you put on the worksheet first. Relationships cannot be formed between tables from data sources published to Tableau Server or Tableau Online. General Information. I noticed there was an issue using Data Blend from 3 different source. Verify if one of the measures coming from the cube data source has a default aggregation different than SUM, MIN, MAX, COUNT. Change the default sort order of the field using the various options, and then click OK. 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. order_date. Loading. 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. Now, in dashboard D1 : has two worksheets W1 and W2. 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. I am trying to blend the same data against the other because I wanted to show Same Period last Year. But I cant add filter Month from the Budget Excel file. Moreover, blending is a kind of left join, not exactly a join. Fee" I want to plot Gross Profit (i. I have three different data source . Option 2: Create a calculation using WINDOW_SUM() Drag the linking field(s) from the secondary data source to. Required cookies are necessary for basic website functionality. Can anybody please help me with a solution. This. . I'm trying to show a distinct count of claims by branch. This is interesting. targets. 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. I am trying to determine the Average Revenue per User by country for which my calculation is total revenue/unique subscribers. I have two data sources and I have blended them together. 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. 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. In your 2nd and 3rd data sources. Sometimes , it's automatically working but sometimes it says 'Unsupported Aggregation' . Data blending brings in additional information from a secondary data source and displays it with data from the primary data source directly in the view. Russell Christopher (Member) 10 years ago. This is the response I received from Tableau Support:Cause. 2, Tableau introduces relationships and splits. 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. In a blend, secondary data sources are aggregated and the StoreID dimension would be aggregated to "*". We cannot publish a blended data source as a single data source on the server. Secondary data source: spatial file containing the geometry. This is a new complexity in Tableau v8: In v7 and earlier, to blend we had to have the linked dimensions in the view, i. Select Custom in the relationships list, and then get Attach. [% age]>=SUM([Percentage]) . " Is there a way to circumvent this issue? Or perhaps a different method entirely. ). The data source with the KMs is the primary source. Tableau v8 added a new style of data blending (DB2) where the linking field does not have to be in the view. 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 . 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. Instead, we need to publish the two data sources separately on the same server and then. 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 date values you want to blend on must exist in both data sources. You can also define the relationship manually by right-clicking on the data source name in the Data pane, and selecting Relationships. 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. 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. Fields cannot be used from the [name of secondary data source] data source, because there is no blend relationship to the primary data source. The relationship is on the facility ID. We use three kinds of cookies on our websites: required, functional, and advertising. Data blending; Table Calculations; Resolution Use one of the following workarounds: If possible, join instead of blend your data. Click oLoading. Good morning . You cannot filter data across secondary data sources. Effective visualization. The two data sources are identical. In the Data pane, select the State data source (secondary). When on the dashboard, click on the âDashboardâ drop-down and select âActionsâ. All Answers. Filter each of the data sources independently on the more granular dimensions. Please find the complete blog here ----> COUNTD with secondary DS Tableau(Blending) Workbook is attached. data source. We don't get row-level data from secondary sources on a. No. Which version of Desktop are you using? See attached the superstore workbook (. since i want only offername from secondary source to the view and the measures are produced from primary datasource is pos_trn. From what I can tell, joining on Tableau Server Data Sources has been a requested feature for 6 years (Idea: Ability to join Tableau Server data sources). 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. ×Sorry to interrupt. 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. Option 2: Join tables that are in the same data source, instead of blending them. Use the geographic role in the primary data source on detail instead of the dimension from the secondary data source. CustomOverall (Primary) 2. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. ×Sorry to interrupt. Overall LOD will show correct result in Primary datasource. 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. 1 Connected to Tableau Server as Main DS and Live Connection to an excel file as secundary DSStep 2: Bring summary data from the secondary data source into the primary data source. Upvote. Hi All! I would like to ask for your help, I do have two data sources: BI Cube (primary source) & Excel file (secondary) BI Cube Data 1 pc. All the data is in the secondary/blended data source. 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. 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. id = B. Just aggregates (like SUM, MIN, MAX. CustomOverall (Primary) 2. This will be identified with a blue checkmark. When I calculate the average of a measure and use the filter, it works perfectly fine. Then, after data blending, the final graph cannot show the data related to the South and East. When you blend, you can only have aggregate access to the rows in the secondary source. Excel . Give the action a sensible name and configure the action. I've blended on user ID. 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. Date dimensions: For cube data sources, date dimensions are typically organized into hierarchies that contain levels such as year,. So make sure you're not using such function while blending. From my primary data source I have a dimension in columns say 'Customer Segment'. Therefore it cannot display null data. 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. I've tried using COUNTD() ID First Last 1 Jim Carrey 1 Jim Carrey 2 Liam Neeson 3 Wynona Ryder COUNT([ID]) = 4 COUNTD([ID]) results in error I can add to filters from the data extracts. Both fields are linked in worksheet. then i added a secondary data source from google sheet , which has the fuel amount. We can see these by activating secondary data source and looking at the dimensions window, the linking dimensions will have an orange chain icon. Summary:. Another way to approach this is to do a join of the data outside Tableau via a federated data source. I. (It is a field that contains account names (company) in the sample data. Alternate names:. I have 2 published datasource and i think i cannot perform JOIN, LOD and COUNTD. See. 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. 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. 0 but was disabled (greyed out) in 8. In this case the cross. The version I am working with 10. 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". LOD (exclude) - Filtering using a different data source I've used LOD (exclude) to create a % of total calc field (and then created a moving average off that). For more information, see Use Relationships for Multi-table Data Analysis. I have two data sources and doing a data blend. A data blend cannot filter on dimensions that do not exist in the Primary data source. E make table 2 the primary and table. In the past, I've just changed my primary table to the one with the calculation. If I cant go the above way then is there a possibility to do the duration calculation using table calculations or some other way. Expand Post. I'm trying to blend two data sources on a single field, say 'Program Description'. As 'Group' is from a secondary data source, I cannot simply use the sort buttons. 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. So the only way, it was possible was to connect one of the data sources with a calendar table joined with previous year and then blend it against the same data to get the Current Year and Same Period Last Year values in a single view. Calculates the number of distinct values of a field within a partition. (I created calculated fields "Fiscal Year" and "Fiscal Month" on my secondary Superstore example to simulate this. 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. Go to Data menu on top and go to Edit Relationships (Data -> Edit Relationships) Create a custom relationship between the 2 new created in 2nd and 3rd source. 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. Loading. Both Primary and Secondary data sources have duplicate rows due to multiple joins in data prep. Data blending is a method for combining data from multiple sources. ×Sorry to interrupt. You combine data in the logical layer using relationships (or noodles). e. Fee". 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". In the secondary (user rights sheet), create a "Verify Username" calculation that has the fmula:. Beginning with Tableau Desktop 2020. Hi . I ended up purchasing an Alteryx license for our company (we now have a lot. e. LoadingWhen you try to add URL actions to dashboards, fields from secondary data sources cannot be added to the URL. 3 and I have created aggregates AGG for fields from data extract and excel file. In the Data window, right-click the relevant field. Best solution. According to Tableau, this error can also appear when using a LOD expression in a blended view. Resolution. This can help researchers identify. Cannot blend the secondary data source because one or more fields use the == function, which cannot be computed locally. " inner cross database join on BU Code with a data source filter set up on UPPER([ID])=UPPER(USERNAME()) on the DS2 source. Because there are no linking fields in this view. the branch field I'm using from the primary data source. Process for Creating the Dynamic âParameterâ. I thought about using a parameter but you cant search with a parameter in a prompt, on the other charts that are like this there are hundreds on items. I have 2 data sources, A and B, they are linked by data blending with A. 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. 2)Count Distinct from Secondary workaround. Filtering data across a worksheet's secondary data source is not currently supported in Tableau Desktop. 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. LOD will not work if it is from the secondary datasource. If you create a quick filter on a field from data source 1 and apply this quick filter to. This happens regardless if I drag it on the rows or on the Marks space as a 'text'. SandhyaData from the secondary data source (via a data blend) can never be a dimension. Call it [Start KM]: IF ATTR ( [KM Date])=ATTR ( [OIL]. Click on the âAdd Actionâ button and choose âChange Set Valuesâ. png - Ben-Sullins's library "Cannot blend the secondary data source because one or more fields use an unsupported. then i added a secondary data source from google sheet , which has the fuel amount. How do I blend these data sources by year? - The Tableau Community. It takes advantage of the data collected from previous research and uses it to carry out new research. T or F: Blends, unlike relationships or joins, never truly combine the data. E make table 2 the primary. Case 2: If you are done with the dashboard development then create a empty extract and publish it on server and run the refresh so that data gets loaded. Proj. Common Issue #1: Cannot blend the secondary data source because one or more fields use an unsupported aggregation The aggregation methods of COUNTD,. An orange tick indicates a secondary data source (Promotions). 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. 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. when I use A as primary data source and drag A. 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). This is a dynamic way to make data in sets stand out and gain greater real-world context for users. AUMTable (Secondary) 3. 4, I tried to blend products (secondary) to storefront (primary) based on Sku. Credits to Jonathan Drummey for the below workaround 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. 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. All three options are demonstrated in the attached workbook using the sample data set Superstore. e. Please see if it helps , here it says that problem is with COUNT & they have provided one alternative way as well . 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). This means that it forces the view to display only relevant data in the secondary data source. Data blending has some limitations regarding non-additive aggregates such as COUNTD, MEDIAN, and RAWSQLAGG. This means a data blend canât be published as a data source for others to use. 0, but I imagine someone has been able to identify what is causing the issue. Now we have to use W2 as Filter - to filter out the data. I like to have the ability to swap a primary data source with a secondary data source for data blending in a workbook. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. Here are the 7 major steps for putting this together: Set up your primary (main) and secondary (parameter) data sources. There are a few possibilities: 1) Flip the blend so the primary is secondary and vice versa. As 'Group' is from a secondary data source, I cannot simply use the sort buttons. 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. Twbx and also the . Also, in the attached I have added both Calc1 and Calc2 to the tooltip in Sheet 9. The order in which fields are used determines which data source is the primary versus the secondary data source. the branch field I'm using from the primary data source. âCannot blend the secondary data source because one or more fields use an unsupported aggregation. 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. thanks. 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. Data blending is particularly useful when the blend relationshipâthe linking fieldsâneed to vary on a sheet-by-sheet. A datetime field may be converted to a date field using a calculation to remove the time portion. mdb which will be used to illustrate data blending. Resolution. 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. Tableau automatically adds an aggregation (SUM) around the column from the secondary source. âCannot blend the secondary data source because one or more fields use an unsupported aggregation. 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. The secondary data source need to be my transaction file and primary data source need to be my budget file.