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. Pick the secondary data source in of Secondary data source pane. Blending with CountD and LODs. Please attach. Cannot blend the secondary data source because one or more fields use the == function, which cannot be computed locally. While on a view, right click a data source, click replace data source. So make sure you're not using such function while blending. 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'. Aside from consulting the primary origin or source, data can also be collected through a third party, a process common with secondary data. Best solution. However, if you do a full outer join on [Dimension] = [Dimension] then we can know which records match up, and do a calculation like:I like to have the ability to swap a primary data source with a secondary data source for data blending in a workbook. If there is another aggregation type such as AGG_AVG being used, change it to one of the supported aggregation listed above in the cube database itself before using in Tableau Desktop. Make the field(s) used to address the table calculation active linking fields. I establish the blend relationships explicitly by going to Data -->Edit Blend Relationships, and selecting the fields that should be related. There is a possibility that the values can be restricted from the secondary data. When you drag a field from a secondary data source to the view, you might see a warning that says: Fields cannot be used from the [name of secondary data source] data source, because there is no blend relationship to the primary data source. Viz cannot be filtered with secondary data source filter before loading the visualization so using "[DS_Name]. Please refer the below link and let me know if this helps to you. the branch field I'm using from the primary data source. Hi Kurt! No, not really. Thanks. 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. This happens regardless if I drag it on the rows or on the Marks space as a 'text'. We don't get row-level data from secondary sources on a blend. 1. Loading. e. Limitations of Data Blending in Tableau. 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. For example, COUNTD(). Now we have to use W2 as Filter - to filter out the data. Filter not recognizing blend relationship. I need to get a count distinct of Patient ID from the Primary data source, as well as count distinct of Patient ID from the Secondary data source in one worksheet. Next, create a table calc using the [Start KM] to calculate the total KMs: from Primary data source from Secondary data source. Ken Flerlage (Member) 5 years ago. 4, I tried to blend products (secondary) to storefront (primary) based on Sku. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. 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'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. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. From what I understand, it's because the link variable must be present in the view, or else it does not work. I noticed there was an issue using Data Blend from 3 different source. I am just trying to filter every Data source, by choosing a field that every Data source has. Data blending has some limitations regarding non-additive aggregates such as COUNTD, MEDIAN, and. cannot blend aggregated data from secondary data source. " inner cross database join on BU Code with a data source filter set up on UPPER([ID])=UPPER(USERNAME()) on the DS2 source. [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. Data blending works only as a left join. 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. This happens only when the data sources are impala. 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. They must be in the same format. 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. FIXED requires that you have row-level access to the rows in the secondary source. One of the Dimension which is part of the Relationship between Primary and Secondary Data Source is being used in Filter and the same field cannot be displayed in Report as it changes the Level of grain of the reportIm using two data source to develop the workbook. If 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. Tableau will throw an error: “Cannot blend the secondary data source because one or more fields use an unsupported aggregation. Any help would be appreciated!Also a data blend is only a LEFT join. then i added a secondary data source from google sheet , which has the fuel amount. This type of bases does not allow for blend relationship, therefore, you cannot use a filter like this. 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. The first field you drop onto a worksheet defines the primary datasource. Using existing secondary data sources can save researchers time and resources by providing access to pre-existing data that has already been collected and organized. 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. ×Sorry to interrupt. I am using blending and created Relationship but i am having problem in terms of getting distinct count from one of the data sources. One approach that succeeds in adding another measure is to add the measure in question to your. The two data sources are identical. 1. We use three kinds of cookies on our websites: required, functional, and advertising. We don't get row-level data from secondary sources on a. From my primary data source I have a dimension in columns say 'Customer Segment'. Size() is a great choice for unique counts across data sources if you can create a view where every unique row is displayed. 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 . All Answers. In the secondary data source, select Data > Create Calculated Field. I'm trying to show a distinct count of claims by branch. Hello Tableau world!! Am running into the strangest problem when data blending with V8. This is the final step and will result in filtering between the blended data sources at your desired level of granularity. Step 1: Create the Parameter. The blend applies to that worksheet only. Data blending is particularly useful when the blend relationship—the linking fields—need to vary on a sheet-by-sheet. Option 2: Create a calculation for a more dynamic sort. 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. The aggregation is all on primary source data. When on the dashboard, click on the ‘Dashboard’ drop-down and select ‘Actions’. I made a waffle chart grid using an excel data source that contains 3 fields: Rows, Columns and Percentage. Loading. I have uploaded this dummy file since I cannot upload my real data here. 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". Loading. Data blending works like a ___ join. Moreover, blending is a kind of left join, not exactly a join. 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. Call it [Start KM]: IF ATTR ( [KM Date])=ATTR ( [OIL]. Change the default sort order of the field using the various options, and then click OK. I have a primary data source coming from a published data extract blending with a secondary data source coming from an Oracle Database. 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. ). It is important to understand which is the primary source, it can impact. Now the nightmare starts: when I try to add the data source B and make all the relationships, it gives me the lovely error: "Cannot blend the secondary data source because one or more fields use the ZN function, which cannot be computed locally. I'm trying to show a distinct count of claims by branch. png - Ben-Sullins's library "Cannot blend the secondary data source because one or more fields use an unsupported. {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. Data blending is a good option when you have multiple data sources that cannot be combined through relationships. This is the response I received from Tableau Support:Cause. Excel 1 pc. Please check the attached workbook for details. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. 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. Overall LOD will show correct result in Primary datasource. We use three kinds of cookies on our websites: required, functional, and advertising. 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. T or F: Blends, unlike relationships or joins, never truly combine the data. There are a few possibilities: 1) Flip the blend so the primary is secondary and vice versa. General Information. 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. 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. My goal is to show CY Actuals as bars, with a line for PY Actuals and a line for Budget. CSS ErrorData blending is based on two key components- Primary data sources and Secondary data sources. Ambiente. However, when the linking dimension is not in the view, non-additive aLoading. id, A. “Cannot blend the secondary data source because one or more fields use an unsupported aggregation. I ended up purchasing an Alteryx license for our company (we now have a lot. For more information, see Troubleshoot Data Blending; Blended data sources cannot be published as a unit. From my primary data source I have a dimension in columns say 'Customer Segment'. I can add to filters from the data extracts. And I can't explain why it does that. 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". 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. The version I am working with 10. Unknown file type Total from Secondary Data Source. tds and . thanks. if you have blended data sources you can not use lods One of the drawbacks of blended sources . It takes advantage of the data collected from previous research and uses it to carry out new research. BR, NBBlended data sources cannot be published as a unit. I didn't realize this until now, but it appears you cannot use blending when one of your data sources uses the new(ish) relationship model. Instead, publish each data source separately (to the same server) and then blend the published data sources. 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. Selected as Best Selected as Best Upvote Upvoted Remove Upvote 1 upvote. Therefore it cannot display null data. 2. This means a data blend can’t be published as a data source for others to use. Calculates the number of distinct values of a field within a partition. In your workbook sheet2 does not contain 5/22 date. I think I need to define the relationship between the data sources. Secondary data sources cannot have logical tables (except when they satisfy specific conditions). Reference line -----> in this approach able to show sub-category items measures like sales and quantity totals as reference lines shown in below figure . An orange tick indicates a secondary data source (Promotions). I am trying using { FIXED : SUM[(portfolioValue)]}. The unsupported aggregation happens when your aggregate requires row-level visibility to the secondary data source. ×Sorry to interrupt. 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]). you will get 5/22 date. Expand Post. 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. g. In the secondary data source, select Data > Create Calculated Field. 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. Can't see what you are actually doing but Blending data has its limits. I get error: “Cannot blend the secondary data source because one or more fields use an unsupported aggregation. Because the question is related to how the data sources are being related, it would help to see the real data structure. I've attached my workbook that contains 2 data sources that are blended by invoice number. CSS ErrorAfter Blending, Now it is showing this error: Cannot blend the secondary data source because one or more fields use an unsupported aggregation. The version I am working with 10. 3. Use blends when:. This can restrict many values from the secondary data source. with blends, we are only able to support aggregates (like SUM, MIN, MAX. Data blending is a method for combining data from multiple sources. i. I am getting Cannot blend secondary data source because one or more fields used an unsupported aggregation. Yes - you can't bring COUNTD in data blending. Hello Jim, Thank You for your reply. Both fields are linked in worksheet. Secondary Data Source: Contains data relating to the usage of a website (hits). CSS ErrorBy default Tableau Desktop wraps fields from a secondary data source in an aggregation in calculated fields. If I cant go the above way then is there a possibility to do the duration calculation using table calculations or some other way. 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. What I'm trying to do is, create a new column in the 'data to map to' table, saying I only want to see 'PY Sales' numbers where the 'Period' column is equal to the MAXIMUM of 'Sales Cycle' column from 'Data to Map from' table, which is from. Fields from the secondary data source used in the view have an orange check mark. The reason of the errors being unsupported calculation in blend. e. Currently, data sources that contain logical tables cannot be used as secondary data sources for data blending. Some examples include: cookies used to. 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. 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. The attached workbook and the following steps illustrate the process. General Information. I noticed that when the spatial file is the secondary data source, I cannot area plot it by double clicking the geometry variable. For more information, see Troubleshoot Data Blending; Blended data sources cannot be published as a unit. 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. This feature would be really useful to ensure we can. 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. 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. Hi All, Is there a way to use a parameter to work for secondary data source in blending. You can create a federated database using linked tables/worksheets. 4, I tried to blend products (secondary) to storefront (primary) based on Sku. Here is situation I am facing, I have blended two data sources and created a worksheet. This functionality was available in versions 8. 1) When we add fields from secondary data sources to a view Tableau “joins” the data as part of the blend on one or more linking dimensions. 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. The "Create Primary Group" operation is bringing the dimension from the secondary into the primary, but it is static, and does not update when your data updates. Please check the attached workbook for details. Thank you. I can get all the fields into the view apart from the 'is vat exempt'. This is one of the disadvantages of data blending in Tableau. Make the data source that contains the field that you want to use in the URL action the primary data source in. Few things you need to keep in mind while blending data sources in tableau. Secondary Data Source: Extract W. If you are blending a cube data source, it must be the primary data source. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. 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. 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. You can choose whether functional and advertising cookies apply. Make sure that you are blending on dimensions present in the view or on. You combine data in the logical layer using relationships (or noodles). I. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. LOD will not work if it is from the secondary datasource. How do I blend these data sources by year? - The Tableau Community. I am confused, as I am not even trying to blend Data from both Data Sources. 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. This is interesting. See Join Your Data for more information. Cannot blend the secondary data source because one or more fields use an unsupported aggregation issue. IF min([Current Period ]) = true then [Display Sum Media Cost] end / sum(IF [Current Period ] = true then. Fixed, countd functions won't work with the secondary datasources. CSS ErrorHi Mavis Liu. Thanks for your help everyone! I've found what was happening: I had some filters on the secondary data source. If you want to filter data across secondary data sources, consider the following alternatives: Join tables that are in the same data source, instead of blending them. In the secondary (user rights sheet), create a "Verify Username" calculation that has the fmula:. Does the. Instead of using relationships, double-click into your table to get to the. Data blending have some limitations regarding non-additive total such like COUNTD, MEDIAN, and RAWSQLAGG. The blend applies to that worksheet only. 3) Select the now grey link next to the original field in. In order to create the waffle chart I am blending it with another datasource using the calculated field defined as [Week 5 (Week5Bond)]. good morning you have blended your data sources - data from the secondary source always comes to the primary and an aggregate so Budg_date needs to be aggregate with min max or attr but that will probably not give you the result you expect the data from the secondary source will come over as an * if there is more than one date filtered from that. For more information, see Troubleshoot Data Blending; Blended data sources cannot be published as a unit. Drag the 2016 Population measure to the Columns. Instead, the. Upvote. For example, select Analysis > Create Calculated Field, and in the Formula text box, type the. In this source create a calculated field to pull out the KMs on the date of oil change. Effective visualization. For example, sheet A uses data source 1 as the primary data source; sheet B uses data source 1 as the secondary data source. * Blend in the summary of a large dataset to reduce query time. 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. Option 1: Join the data sources with a cross-database join instead of blending. cannot blend aggregated data from the secondary data source with data on this sheet. 1, the ability to "Show Empty Rows" (or columns) was removed when you use a secondary data source. Advantages: Very easy to write and implement. Some of the function doesn't work properly when we use blending like COUNTD(), LOD{} expression. So you need to create a Date field in your Master Data Source, which is why I usedAlternative to CountD function in Blending. "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. The two values you mentioned, 5315 - Radio and 5345 - Public Relations, do not appear in your primary data source for 2012, but do appear in the secondary data source, so they cannot be included in the data. You can read details here: Logical Tables in Secondary data source. From my primary data source I have a measure in rows, say 'Measure, which is 'distinct count of Pol Number' or 'sum of Premium' depending on a boolean parameter's values (TRUE or. 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. 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. Upvote Upvoted Remove Upvote Reply. We would like to show you a description here but the site won’t allow us. A secondary data source can be used to re-alias the field values in a primary data source. We cannot publish a blended data source as a single data source on the server. 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. order_date. Unfortunately can't share the data, and can't come up with a mock cause I can't figure out what's not/is working as expected. A Level of Detail (LOD) expression is being taken from the secondary data source. In addition, you cannot blend Measure Values from a secondary data-source, so that rules out this approach as well. There's no way to "swap. 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". In the Data window, right-click the relevant field. Tableau Desktop; Blended data; Soluzione Use the following workaround: Create a new worksheet. Also, data blending is useful for combining data from published. There's a set of views/calcs that show a metric, (metric C) counting distinct number of accounts contacted per person per week (e. ODBC is a pretty universal technology for doing this, you can find more by doing a web search on "linked tables" or "linked worksheets" for your specific data sources. Expand Post. ×Sorry to interrupt. Ritesh Bisht (Member) 6 years ago. Create a “Blend Field” with a value of 1 in both your primary and secondary. LOD expressions are used when running complex queries with multiple dimensions at the data source level. drag the secondary measures to measure values section . 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 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. Loading. The default view that you first see in the Data Source page canvas is the logical layer of the data source. Select Default Properties > Sort. The two data sources are identical. 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. 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 have two data sources and I have blended them together. Nitish Pamarty (Member) 7 years ago. Jim. ) A LOD calc is also trying to do stuff at the row level. Required cookies are necessary for basic website functionality. The order in which fields are used determines which data source is the primary versus the secondary data source. 1) Vizible Difference: Getting around Count Distinct in a secondary 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. Then you can simply show one filter control on your dashboard and set it to apply to all related data sources. [tier] == 0 then "Low vendors" elseif max [Secondary]. See Join your Data for instructions. 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". In Tableau Desktop, navigate to Data > Edit Relationships. Relationships cannot be formed between tables from data sources published to Tableau Server or Tableau Online. Cannot blend the secondary data source because one or more fields use an unsupported aggregation It’s cable reimagined No DVR space limits. In the formula text box, type the ZN function, the SUM. 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. ”. I have two data sets that are linked across Date and Product Category fields. Can anybody please help me with a solution. Data from a secondary source is displayed along with the primary source data. 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. You combine data in the logical layer using relationships (or noodles). 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. Verify if one of the measures coming from the cube data source has a default aggregation different than SUM, MIN, MAX, COUNT. Identify your data sources for common data types: both data sources must have a string or date field for linking data sources. Fields cannot be used from the [name of secondary data source] data source, because there is no blend relationship to the primary data source. You can choose whether functional and advertising cookies apply. I'm blending student data (primary) and staff data (second). . THEN add this total to the SUM of the projected_users from today's date through month X. " I have seen a few posts on it and found an issue logged about it as far back as version 8. The limitation with Tableau and secondary data sources stinks. The condition is offer status = hired, but offer status can contain my different response types. The data source with the KMs is the primary source. LOD will not work if it is from the secondary datasource. The secondary data source need to be my transaction file and primary data source need to be my budget file. Remove all dimensions from the secondary data source and ensure that the primary data source’s linking field is in view. Data blending is particularly useful when the blend relationship—the linking fields—need to vary on a sheet-by-sheet. It throws me cannot blend secondary data source one or more becuase one or more fields use unsupported aggregation . I am trying to use the below formula instead of countd function because my data comes from Impala. The primary data source will be identified automatically from any metrics you put on the worksheet first. All customer IDs are under a dimension called "Global ID". Upvote. The solution. It says, "fields cannot be used from [data name] data source, because there is no relationship to the primary. 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). 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). I was now trying to use both calculations you did on a different sheet through data blending. In the Data pane, select the Store - North data source. Expand Post. 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. . Please find the complete blog here ----> COUNTD with secondary DS Tableau(Blending) Workbook is attached. It's a technical limitation. Marked as. Data & Connectivity. I have just realised why the blending was not working. If there is another. 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. Hi Data Modeler , I have an idea which I cannot test right away. Community Manager update. I have quick filters from the primary data source and I am trying to represent distinct. But I cannot for the life of me comprehend why the data blending would behave differently based solely on the chart type that was selected. Hello Jim, Thank You for your reply. e. I am trying to determine the Average Revenue per User by country for which my calculation is total revenue/unique subscribers. If you create a quick filter on a field from data source 1 and apply this. I'm using a data blending method, where: Primary data source: Contains the ID I'm trying to count. 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. Cube (multidimensional) data sources have certain characteristics that make them unique in Tableau. To blend on summary data, you can do the following: Create a. 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. Tableau has two inbuilt data sources named Sample-superstore and Sample coffee chain. Set up the primary and. According to Tableau, this error can also appear when using a LOD expression in a blended view. Each has a joining field with the same name. targets. Cannot Blend Secondary Data Source - Unsupported Aggregation. xls files). 1. Change the default sort order of the field using the various options, and then click OK. However, when I follow your advice, each group splits into 6 rows (one for each month - January through June). 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 have two data sources which I have blended together on two fields: branch and date. Data source A has Role Column and Data source B also has Role Column.