Expand Post. When on the dashboard, click on the ‘Dashboard’ drop-down and select ‘Actions’. Call it [Start KM]: IF ATTR ( [KM Date])=ATTR ( [OIL]. Another way to approach this is to do a join of the data outside Tableau via a federated data source. " message. "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. Option 2: Create a calculation for a more dynamic sort. Common warnings and errors when blending data sources No relationship to the primary data source. This type of bases does not allow for blend relationship, therefore, you cannot use a filter like this. That's probably your problem. We don't get row-level data from secondary sources on a. please check the attached workbook. I've blended on user ID. 3. Another table is a a table that contains key fields such as date, region, location and hardware id (dimension). First data source looks like below. Data & Connectivity. 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). Expand Post. Why are values from the secondary data source not appearing in a blended data source view? They did not exist in the primary data source. I am getting Cannot blend secondary data source because one or more fields used an unsupported aggregation. This happens only when the data sources are impala. Instead, publish each data source separately (to the same server) and then blend the published data sources. I have two data sets that are linked across Date and Product Category fields. Here is situation I am facing, I have blended two data sources and created a worksheet. Unknown file type Total from Secondary Data Source. So, in the dummy data, there are two tables from two data sources. cannot blend aggregated data from secondary data source. Data of any sort coming from a secondary source must come as an aggregate of some sort. 1. When you data changes, you need to redo the. e. A datetime field in the primary data source, for example, will not blend with a date field in the secondary data source. The default view that you first see in the Data Source page canvas is the logical layer of the data source. Regards. General Information. For more information, see Use Relationships for Multi-table Data Analysis. the blended data cannot be published to Tableau Online or Tableau Server. an aggregated left join where the aggregation of the secondary data cannot be used to increase the level of detail of the primary data. Currently, data sources that contain logical tables cannot be used as secondary data sources for data blending. , 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. But I cant add filter Month from the Budget Excel file. This can help researchers identify. CustomOverall (Primary) 2. 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. 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". 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. Verify if one of the measures coming from the cube data source has a default aggregation different than SUM, MIN, MAX, COUNT. We can see these by activating secondary data source and looking at the dimensions window, the linking dimensions will have an orange chain icon. We use three kinds of cookies on our websites: required, functional, and advertising. I am trying to blend the same data against the other because I wanted to show Same Period last Year. We cannot use ATTR if trying to create an LOD type calculation if blending data sources. 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. Because data blending is an ad-hoc LEFT join that aggregates data from the secondary data source, Tableau cannot always perform aggregations that require the full domain. Cannot blend the secondary data source because one or more fields use the == function, which cannot be computed locally. Best solution. Become a Better Analyst in Just 5 Minutes a Week. Think of this layer as the Relationships canvas in the Data Source page. For example, COUNTD(). I am trying to use the below formula instead of countd function because my data comes from Impala {FIXED [Machine Nr] : COUNT([Machine Nr] )} / {FIXED [Machine Nr] : COUNT([Machine Nr] )} This works fine when there is no secondary data source but when I blend with a secondary data source it grays out my sheet i. Here is the sample. The syntax for calling secondary data source field is not. You cannot filter data across secondary data sources. This means that when a cube data source is published, you cannot make a connection from Tableau Server using the data source. Select Custom in the relationships list, and then get Attach. Solution in the image 📌 Non-additive aggregates from the primary data source 📌 Non-additive aggregates from the secondary data source 📌 Non-additive aggregates from a multi-connection. I have two data sources which I have blended together on two fields: branch and date. I think I need to define the relationship between the data sources. " Is there a way to circumvent this issue? Or perhaps a different method entirely. {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. In the formula text box, type the ZN function, the SUM. Ambiente. Instead, publish each data. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. I have two data sources and doing a data blend. 1. Hi Kurt! No, not really. For more information, see Deciding Between Joining Tables and Blending Data. [Work Hours]) So you have to make. I have a Remaining Value calculation, but it is not correct. The secondary data source need to be my transaction file and primary data source need to be my budget file. When you blend, you can only have aggregate access to the rows in the secondary. A datetime field may be converted to a date field using a calculation to remove the time portion. If you want to filter data across secondary data sources, consider. 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. 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)]. order_date. Final Words. 3 and I have created aggregates AGG for fields from data extract and excel file. Please see if it helps , here it says that problem is with COUNT & they have provided one alternative way as well . While using blending data source some of the function doesn't perform well in calculation like COUNTD(), LOD{}, MEDIAN() etc. 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". 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. We use three kinds of cookies on our websites: required, functional, and advertising. COUNTD is tough to work on while you. 2) Use this duplicate field in the view instead of the original. 1) Vizible Difference: Getting around Count Distinct in a secondary data source. I get error: “Cannot blend the secondary data source because one or more fields use an unsupported aggregation. 5 3 . While on a view, right click a data source, click replace data source. Filter not recognizing blend relationship. I use the Opp ID to relate them. Fields from the secondary data source used in the view have an orange check mark. 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. You combine data in the logical layer using relationships (or noodles). Primary Data Source: Contains a list of all employees and their role. SandhyaData from the secondary data source (via a data blend) can never be a dimension. The problem is when I try to calculate the median of that same measure. Think of this layer as the Relationships canvas in the Data Source page. 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. 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). THEN add this total to the SUM of the projected_users from today's date through month X. 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". If multiple logical tables are related in a Tableau data source that source cannot be used as the secondary data source in a Tableau data blend, it can only be used as the primary Therefore one workaround is the Create Primary Group function that you described which "copies" the field from B into A as a group. This is a dynamic way to make data in sets stand out and gain greater real-world context for users. Verify if one of the measures coming from the cube data source has a default aggregation different than SUM, MIN, MAX, COUNT. Answer. 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. Aside from consulting the primary origin or source, data can also be collected through a third party, a process common with secondary data. But since there are a few dates missing from the second data source i cannot blend on date as doing this will result in loosing data from Table 1. Hello Tableau world!! Am running into the strangest problem when data blending with V8. Hi All, I have blended primary and secondary data sources. When I put category on either the row or column shelf I am getting the erro r "Cannot blend the secondary data source because one or more field use an unsupported aggregation". Maxdate) There is one more way, make the datasource which is using the fixed calculation to primary data source. To fix this, we had to add the fields being used in the blending relationship onto the view: 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 Help Sorted by: 2. 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 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. So make sure you're not using such function while blending. I have 2 published datasource and i think i cannot perform JOIN, LOD and COUNTD. 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. Sometimes , it's automatically working but sometimes it says 'Unsupported Aggregation' . Upvote Upvoted Remove Upvote Reply. Thank you. Primary and Secondary sources in data blending. Blending runs a query on each data source and joins the aggregated results of those queries. Marked as. I was now trying to use both calculations you did on a different sheet through data blending. ×Sorry to interrupt. Change the default sort order of the field using the various options, and then click OK. In the Data pane, select the State data source (secondary). 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. since i want only offername from secondary source to the view and the measures are produced from primary datasource is pos_trn. The. It would be nice if when you blend two data sources, you could have the option to show "Only Relevant Values" on filters used from the secondary data source. 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 . 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. 3 and I have created aggregates AGG for fields from data extract and excel file. This is the final step and will result in filtering between the blended data sources at your desired level of granularity. I am trying to create a waffle chart. 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. When blending in Tableau, there is always a primary source and a secondary data source. Community Manager update. Option 2: Join tables that are in the same data source, instead of blending them. Click on the ‘Add Action’ button and choose ‘Change Set Values’. If the user select May 2018. I have the same issue, but Primary Data Source is a Tableau Server Data Source (I do not have direct access to the database), and Secondary Data Source is an excel flat file. 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. You can create a federated database using linked tables/worksheets. {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. 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. Status, Stage, etc). The version I am working with 10. I made a waffle chart grid using an excel data source that contains 3 fields: Rows, Columns and Percentage. Filter each of the data sources independently on the more granular dimensions. A data blend cannot filter on dimensions that do not exist in the Primary data source. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. 4. Hello Jim, Thank You for your reply. Fee". Data blend is like a Left outer join. I am using tableau 2020. This means a data blend can’t be published as a data source for others to use. Data blending have some limitations regarding non-additive total such like COUNTD, MEDIAN, and RAWSQLAGG. 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. like below . Summary:. Are use of grouped fields not allowed in data blending? I have two data sources: Opportunities and Products. 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 2 data sources, A and B, they are linked by data blending with A. "Budget" is only contained in an Excel file data source. 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. IF ATTR([Offer Status]) = "Hired" Then AVG([Comp_File]. I am creating a couple of formulas to display the total booking from the second data source to the first data source. Primary Source: Payment details (to get customer ID and revenue) Secondary Source: Customer details (to get customer country)from this data source i get the sum of basic salary. 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. 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. Each has a joining field with the same name. There's no way to "swap. A datetime field may be converted to a date field using a calculation to remove the time portion. 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. Here's the data blend view with the secondary data source selected so we can see what blend fields are used:. You can choose whether functional and advertising cookies apply. General Information. thanks. 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]). the branch field I'm using from the primary data source. 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. In your case, you're after the Total Cases by Employee, so just imagine Employee in place of Category. AUMTable (Secondary) 3. Now, in dashboard D1 : has two worksheets W1 and W2. Secondary data source: spatial file containing the geometry. Fixed, countd functions won't work with the secondary datasources. But I cant add filter Month from the Budget Excel file. 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. 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. CSS ErrorCannot blend the secondary data source because one or more fields use an unsupported aggregationFollow this link for more information:the secondary data source always has to be aggregated, there's no way to do a row level check to filter out any dimension members that match between the two data sources. 2)Count Distinct from Secondary workaround. ×Sorry to interrupt. Overall LOD will show correct result in Primary datasource. I'm blending the 2 data sources by Service_Id. 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. We use three kinds of cookies on our websites: required, functional, and advertising. Data blending works only as a left join. with blends, we are only able to support aggregates (like SUM, MIN, MAX. This means that it forces the view to display only relevant data in the secondary data source. 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. Primary Data Source: Extract S. 2. Resolution. Data blending has some limitations regarding non-additive aggregates such as COUNTD, MEDIAN, and RAWSQLAGG. 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 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. Tableau Desktop & Web Authoring. But seems we cannot blend 2 secondary data source with same field. 2, users would define joins and unions between physical tables in which Tableau would create a singular, flat table for analysis. If I remove the blend, I cannot use/filter the secondary data source, and If I use the blend, it will display only the values for the first data source, but not from the second one, excluding. I'm trying to show a distinct count of claims by branch. Cannot blend the secondary data source because one or more fields use an unsupported aggregation issue. Use blends when:. For more information, see Troubleshoot Data Blending; Blended data sources cannot be published as a unit. However, some days will have entries for "Cost" but not for "Proj. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. If I cant go the above way then is there a possibility to do the duration calculation using table calculations or some other way. Beyond that personally I tend to do the work necessary to avoid using data blending in production data sources & views. 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. Pick the secondary data source in of Secondary data source pane. Consider joining the two data sources together using Tableau Prep, and then you can use that data as a. Limitations of Data Blending in Tableau. I use the Opp ID to relate them. Remove all dimensions from the secondary data source and ensure that the primary data source’s linking field is in view. 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. the count of claims I'm getting from the secondary data source, by counting distinctly a measure called claimid. ) A LOD calc is also trying to do stuff at the row level. Blending with CountD and LODs. To provide comparative data: Secondary data can be used to compare and contrast findings across different studies or datasets. For secondary data source you get same result by managing relationships in your case just Area and Qtr. CSS ErrorLoading. Loading. Filtering data across a worksheet's secondary data source is not currently supported in Tableau Desktop. Functional cookies enhance functions, performance, and services on the website. ” Causes and Workarounds for a Blending Limitation Errors 1. Instead of using relationships, double-click into your table to get to the. In the Relationships dialog box, under Secondary data source select Custom, and then click Add. I want to do a basic data listing showing customer, order no, postcode & vat exempt. I have 2 separate data sources that have similar fields. Thanks. T or F: Blends, unlike relationships or joins, never truly combine the data. Data blending provides a way to combine data from more than one data source on a single worksheet. 1) Duplicate the field in primary datasource. I cannot able to use as one connection since am using the data source filter in my first connection have data source filter. Please attach. If you make sheet 1 as the primary data source and do the data blending with sheet 2. "Data Sources that contain logical tables cannot be used as secondary data sources for blending". id, A. 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. Please post you twbx workbook so we can see if there a way . 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. - Dataset 1, records the amount spent on ads as "Cost". This happens regardless if I drag it on the rows or on the Marks space as a 'text'. LOD expressions are used when running complex queries with multiple dimensions at the data source level. I am using blending and created Relationship but i am having problem in terms of getting distinct count from one of the data sources. Secondary Data Source: Extract W. Before I check Date filters, I got this results. I noticed there was an issue using Data Blend from 3 different source. 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. You cannot change that. Place Organisation Identifier on the level of detail shelf (from the primary source, or both sources) and the blend should work. This would be a great time saver, with all of the calculations and linking changing as well. 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. "Cannot blend the secondary data source because one or more fields use the / function, which cannot be computed locally. ) If only one of the tables requires row level information, consider making that the primary data source in the blend (I. Now you see a new group field listed in the Population data source (primary) called State (group). 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. AUMTable (Secondary) 3. 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. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. The date values you want to blend on must exist in both data sources. I. 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. General Information. Chicken + Choice of DrinkBurger + Choice of DrinkSpaghetti + Choice of Drink . Both fields are linked in worksheet. I have two data sources and I have blended them together. 0, but I imagine someone has been able to identify what is causing the issue. The relationship is on the facility ID. You can also define the relationship manually by right-clicking on the data source name in the Data pane, and selecting Relationships. Currently, I have to rebuild the worksheet and bring in the secondary source first. " I have seen a few posts on it and found an issue logged about it as far back as version 8. The data source with the KMs is the primary source. Fee - Cost) over time. “Cannot blend the secondary data source because one or more fields use an unsupported aggregation. In my primary, I define another calculated field to do the aggregation for each project by tier: VendorClass: if max [Secondary]. Dominic Laird(Member) 5 years ago. Next, create a table calc using the [Start KM] to calculate the total KMs:Error: Cannot blend the secondary data source because one or more fields use an unsupported aggregation. 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. 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. Nitish Pamarty (Member) 7 years ago. Twb, . the branch field I'm using from the primary data source. "Cannot blend the secondary data source because one or more fields use the == function, which cannot be computed locally. Make sure that you are blending on dimensions present in the view or on all of the. In this case the cross. For more information, see Use Relationships for Multi-table Data Analysis. newBranchProjection (Secondary) When I try to add COUNTD([DistrictId]) from my primary to text table. 4, I tried to blend products (secondary) to storefront (primary) based on Sku. e. 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. It sounds like there might be some complications with a blend? Can’t speak to what’s happening thereAre you blending on [Endtimestamp]? By using the formula DAY([Endtimestamp]), you're changing the dimensionality a little bit. 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. 2 came the introduction of a brand-new data model. I am using tableau 2020. 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. 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. Loading. Hello Ritish, You could use Size() and a Las() function as a filter and get the same output. Data from a secondary source is displayed along with the primary source data. It throws me cannot blend secondary data source one or more becuase one or more fields use unsupported aggregation . According to Tableau, this error can also appear when using a LOD expression in a blended view. If there is another. The condition is offer status = hired, but offer status can contain my different response types. Size() is a great choice for unique counts across data sources if you can create a view where every unique row is displayed. Additional Information While replacing ATTR() with MIN() will cause "Automatic" grand totals to show, the grand totals might not be the expected values. Current Year Actuals and Prior Year Actuals are housed in a corporate transnational data source. ×Sorry to interrupt. month([date])=month(Parameter. 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. order_date = B. " Expand Post. While on a view, right click a data source, click replace data source. The order in which fields are used determines which data source is the primary versus the secondary data source. 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. Cube data sources do not support pass-through connections. It says, "fields cannot be used from [data name] data source, because there is no relationship to the primary. 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. The default view that you first see in the Data Source page canvas is the logical layer of the data source. 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. Maxdate) There is one more way, make the datasource which is using the fixed calculation to. 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. Tableau Desktop; Blended data; Soluzione Use the following workaround: Create a new worksheet. I have quick filters from the primary data source and I am trying to represent distinct. Beginning with Tableau Desktop 2020. [OIL DATE]) THEN MIN ( [KMs]) END. ×Sorry to interrupt. 4, I tried to blend products (secondary) to storefront (primary) based on Sku. Hi . See Join your Data for instructions. Try one of the following options, as appropriate for your workbook: It may be possible to cross database join instead of blending. (It is a field that contains account names (company) in the sample data. In the data window, the blue tick indicates the Primary data source (Sales in the image below).