This feature would be really useful to ensure we can. A Level of Detail (LOD) expression is being taken from the secondary data source. We are blending two data sources. But the source calc is a countD. g. Regards. In the Relationships dialog box, under Secondary data source select Custom, and then click Add. 2 and later. Viz cannot be filtered with secondary data source filter before loading the visualization so using "[DS_Name]. 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'. In this case the cross database join will effectively act like the. . One data source has some values, the other one has different values. AUMTable (Secondary) 3. I have two data sets that are linked across Date and Product Category fields. Expand Post. Thank you . Both Primary and Secondary data sources have duplicate rows due to multiple joins in data prep. In data blending, there is a primary data source and a secondary data source. In the Data pane, select the Store - North data source. When I make the data source as Primary, I am able to see the respective values, Kindly see the below screenshot:- But, when I consider this data source as secondary and then try to use it in primary data source sheet, I get this error:- Cannot blend the secondary data source because one or more fields use an unsupported aggregation. This feature would be really useful to ensure we can. I'm blending the 2 data sources by Service_Id. 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. CSS ErrorLoading. The chart should display: countd. I can't do a join because they are two different file formats. When you data changes, you need to redo the. 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. Selected as Best Selected as Best Upvote Upvoted Remove Upvote 1 upvote. Alternate names:. " Is there a way to circumvent this issue? Or perhaps a different method entirely. 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. The value gets reduced based on filters@@@ from all data source. Data blending is a good option when you have multiple data sources that cannot be combined through relationships. All the data is in the secondary/blended data source. In the secondary (user rights sheet), create a "Verify Username" calculation that has the fmula:. with blends, we are only able to support aggregates (like SUM, MIN, MAX. You have a nice example to use for filing a support case, and I recommend that you do that. " inner cross database join on BU Code with a data source filter set up on UPPER([ID])=UPPER(USERNAME()) on the DS2 source. 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". The Products set contain the individual products within an Opportunity whereas the Opportunities set contain Sales metrics (i. Resolution. 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. Community Manager update. 1. Data & Connectivity. "Cannot blend aggregated data from the secondary data source with the data on this sheet because there are no linking fields use din the view" I'm using 2 separate data sources connected to Oracle and published to the Tableau server. This link might help you: Cannot blend the secondary data source because one or more fields use an unsupported aggregation. Relationships cannot be formed between tables from data sources published to Tableau Server or Tableau Online. e. 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. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. drag the secondary measures to measure values section . Make the data source that contains the field that you want to use in the URL action the primary data source in. Step 1: Create the Parameter. For more information, see Deciding Between Joining Tables and Blending 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. Data blending is a method for combining data from multiple sources. Tableau v8 added a new style of data blending (DB2) where the linking field does not have to be in the view. Instead, publish each data source separately (to the same server) and then blend the published data sources. 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. 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". Upvote Upvoted Remove Upvote Reply. Option 1: Join the data sources with a cross-database join instead of blending. Now we have to use W2 as Filter - to filter out the data. LOD will not work if it is from the secondary datasource. 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. Open. Thank you. And I can't explain why it does that. thanks. 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. 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. Option 2: Create a calculation using WINDOW_SUM() Drag the linking field(s) from the secondary data source to. Upvote. Because the question is related to how the data sources are being related, it would help to see the real data structure. In the Add/Edit Field Mapping dialog box, select the date fields from the primary and secondary data sources, and then click OK twice. ×Sorry to interrupt. I am trying to create a waffle chart. In the Data window, switch to the [data name2] data source. However, when the linking dimension is not in the view, non-additive aLoading. It also means you cannot create a workbook using the. The data source with the KMs is the primary source. The secondary data source will have an orange checkmark on it. " Expand Post. ×Sorry to interrupt. To the Data pane, umschaltung in this [name of secondary data source] data source, real click at lowest one link icon to blend that data sources. Thanks bharat ! but i think client column is common to both the source so i would able to blend the data. Credits to Jonathan Drummey for the below workaround Cannot blend the secondary data source because one or more fields use an unsupported aggregation . For example, COUNTD(). 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. Date dimensions: For cube data sources, date dimensions are typically organized into hierarchies that contain levels such as year,. [OIL DATE]) THEN MIN ( [KMs]) END. " inner cross database join on BU Code with a data source filter set up on UPPER([ID])=UPPER(USERNAME()) on the DS2 source. 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. 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 . I'm trying to show a distinct count of claims by branch. Are use of grouped fields not allowed in data blending? I have two data sources: Opportunities and Products. The reason your blend breaks is that you're blending with Location as a linking field, so when you remove that from your view, Tableau can't blend any longer. I have two datasets; one is a shape file that contains regions and locations. The secondary data source need to be my transaction file and primary data source need to be my budget file. I've attached my workbook that contains 2 data sources that are blended by invoice number. Data blending works like a ___ join. The problem is when I try to calculate the median of that same measure. 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. 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". So you need to create a Date field in your Master Data Source, which is why I usedAlternative to CountD function in Blending. (It is a field that contains account names (company) in the sample data. "Data Sources that contain logical tables cannot be used as secondary data sources for blending". While on a view, right click a data source, click replace data source. 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. ×Sorry to interrupt. 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. If there is another. Data coming from a secondary source is ALWAYS aggregated at the level of the link - even if there is 'no need to add anything' that's just the way blending works - it happens after the data table dimensions are set and you are loading values into the data table for the individual worksheet additionally, data coming from the secondary source are always aggregated at the level of the link when brought to the primary source - the individual records are no longer available and you are not able to filter across the various data sources at that point - that is the long way of saying you will have to join or use a relationship - not. "Budget" is only contained in an Excel file data source. The limitation with Tableau and secondary data sources stinks. 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". Are you talking about Tableau Prep or Tableau Desktop? Any chance you can share a sample of your data? Expand Post. I like to have the ability to swap a primary data source with a secondary data source for data blending in a workbook. 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. All Answers. I cannot able to use as one connection since am using the data source filter in my first connection have data source filter. There's a set of views/calcs that show a metric, (metric C) counting distinct number of accounts contacted per person per week (e. 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. It sounds like there might be some complications with a blend? Can’t speak to what’s happening there Are you blending on [Endtimestamp]? By using the formula DAY([Endtimestamp]), you're changing the dimensionality a little bit. 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. - Data to Map from - Data to Map to . Error: Cannot Blend the secondary data source because one or more fields use an unsupported aggregation. Data blending provides a way to combine data from more than one data source on a single worksheet. the branch field I'm using from the primary data source. Option 1: Include all linking fields in the view, and aggregate secondary fields Data blending will work when the secondary data source uses logical tables, as long as the following conditions are met: All active linking fields from the primary data source must be included in the view on a shelf other than the Filters shelf Link Primary Source and all other secondary source on this Field Created from step 3- 4 using Edit Data blend Relationships 6. 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)]. In this case the cross. Tableau will throw an error: “Cannot blend the secondary data source because one or more fields use an unsupported aggregation. The first field you drop onto a worksheet defines the primary datasource. ” We use three kinds of cookies on our websites: required,. Beyond that personally I tend to do the work necessary to avoid using data blending in production data sources & views. 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). This would be a great time saver, with all of the calculations and linking changing as well. Currently, data sources that contain logical tables cannot be used as secondary data sources for data blending. Make sure that you are blending on dimensions present in the view or on all of the. The unsupported aggregation happens when your aggregate requires row-level visibility to the secondary data source. tds and . Data. The reason of the errors being unsupported calculation in blend. How do I blend these data sources by year? - The Tableau Community. Data blending has some limitations regarding non-additive aggregates such as COUNTD, MEDIAN, and. Additional Information While replacing ATTR() with MIN() will cause "Automatic" grand totals to show, the grand totals might not be the expected values. Observations : 1. 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. Best solution. ) A LOD calc is also trying to do stuff at the row level. {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. 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. Secondary data source: spatial file containing the geometry. IF ATTR([Offer Status]) = "Hired" Then AVG([Comp_File]. 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. 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". Cube data sources do not support pass-through connections. E make table 2 the primary and table. Instead, publish each data source separately (to the same server) and then blend the published data sources. 1) When we add fields from secondary data sources to a view Tableau “joins” the data as part of the blend on one or more linking dimensions. I am trying to use the below formula instead of countd function because my data comes from Impala. 1, the ability to "Show Empty Rows" (or columns) was removed when you use a secondary data source. We use three kinds of cookies on our websites: required, functional, and advertising. I am trying to use the measures name filter functionality with two data sources. 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. If this aggregation is ATTR() then the grand totals may be blank. 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. Right-click in the Data window and then. LOD will not work if it is from the secondary datasource. Error “Cannot blend the secondary data source because one or more fields use an unsupported aggregation. 4. Resolution. This is one of the disadvantages of data blending in Tableau. Consider joining the two data sources together using Tableau Prep, and then you can use that data as a. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. Yes - you can't bring COUNTD in data blending. Does anyone have any Ideas how I can apply a universal filter to 5 different unrelated data sources? Applies to: Tableau Cloud, Tableau Desktop, Tableau Server. 💥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. There is a possibility that the values can be restricted from the secondary data. Data blending has some limitations regarding non-additive aggregates such as COUNTD, MEDIAN, and RAWSQLAGG. Data blending is a method for combining data from multiple sources. I am trying to . I'm using a cube data source as my primary and am attempting to blend with. General Information. I can add to filters from the data extracts. To blend on summary data, you can do the following: Create a. Filter each of the data sources independently on the more granular dimensions. I've blended on user ID. 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. Data source A has Role Column and Data source B also has Role Column. LOD calculation and blended data sources. 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 made a waffle chart grid using an excel data source that contains 3 fields: Rows, Columns and Percentage. 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. It says, "fields cannot be used from [data name] data source, because there is no relationship to the primary. Secondary data source has Order Date represented as separate Year and Month fields. 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. A datetime field in the primary data source, for example, will not blend with a date field in the secondary data source. Secondary data source: (excel) master zip file with ~40k rows (all US zips) - each zip is tied to a territory I am looking to add the territories from the master zip to territory file as a filter. 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. To blend on summary data, you can do the following: Create a. 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. The primary data source will be identified automatically from any metrics you put on the worksheet first. ) So the issue is really the introduction of the group on the sheet. Fields from the secondary data source used in the view have an orange check mark. In addition, you cannot blend Measure Values from a secondary data-source, so that rules out this approach as well. In this example, Superstore Sales is the primary data source and Coffee Chain is the secondary data source. I am blending 2 data sets by employee id and when i am trying to group a field from the primary database, it is showing me below error: Cannot blend the secondary data source because one or more fields use an unsupported aggregation. My goal is to show CY Actuals as bars, with a line for PY Actuals and a line for Budget. This happens only when the data sources are impala. The order in which fields are used determines which data source is the primary versus the secondary data source. [OIL DATE]) THEN MIN ( [KMs]) END. BR, NBBlended data sources cannot be published as a unit. Think of this layer as the Relationships canvas in the Data Source page. Then, after data blending, the final graph cannot show the data related to the South and East. They both share a common field (State), and that is what I'm filtering on. " The only fields used in the view are the date fields, to which I did a . FIXED ID, WEEK: CountD (accounts)). Loading. 4, I tried to blend products (secondary) to storefront (primary) based on Sku. month([date])=month(Parameter. 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". Cannot blend the secondary data source because one or more fields use an unsupported aggregation. Hi, Because we can't see the entire picture, no detail in the view of the connected data sources, the workbook, etc. Marked as. Status, Stage, etc). Blending with CountD and LODs. We use three kinds of cookies on our websites: required, functional, and advertising. I have just realised why the blending was not working. The aggregation is all on primary source data. Proj. 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. I am blending dates in the secondary data source to dates from the primary source and looking to get a distinct count of the customer code from the secondary data source. Primary Data Source: Extract S. Help would be much. 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. The problem I'm running into is when I use another data source as the primary source and attempt to bring over the LOD calculation from a secondary source. Your secondary data source does not have the blend activated, you'll need to click on the link and turn it red to activate:. e. newBranchProjection (Secondary) When I try to add COUNTD([DistrictId]) from my primary to text table. Data blending; Table Calculations; Resolution Use one of the following workarounds: If possible, join instead of blend your data. You want to apply a filter to related data sources - which is an option if multiple data sources have a field with the same name and data type, or if you define explicit relationships between data sources from the Data menu. Name: Distinct Count. 3. Loading. In the data window, the blue tick indicates the Primary data source (Sales in the image below). 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. Expand Post Using TableauThe secondary data source is indicated with an orange check mark on the data source and an orange bar down the side of the Data pane. A datetime field in the primary data source, for example, will not blend with a date field in the secondary data source. Each has a joining field with the same name. Click oLoading. It is important to understand which is the primary source, it can impact. I am trying to determine the Average Revenue per User by country for which my calculation is total revenue/unique subscribers. Remove all dimensions from the secondary data source and ensure that the primary data source’s linking field is in view. Loading. I have two data sets: the first data set is a shp file from data. Reference line -----> in this approach able to show sub-category items measures like sales and quantity totals as reference lines shown in below figure . I am trying using { FIXED : SUM[(portfolioValue)]}. In my primary, I define another calculated field to do the aggregation for each project by tier: VendorClass: if max [Secondary]. That's probably your problem. Set up the primary and. Data blending tools can present their findings as visualizations, such as infographics and charts, after querying data sources and aggregating relevant information. E make table 2 the primary. 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. the blended data cannot be published to Tableau Online or Tableau Server. If we are working with one data source that is not relatable or joinable (such as Google Analytics) you are not able to blend a secondary data source with logical tables to it. Data blending is used when the linking fields need to vary on a sheet-by-sheet basis for different visualizations. Relationships: Join: Combines columns: Yes: Cross database joins will not work with all data sources: Joins: Blend: Combines columns: No: Fields from the secondary data source cannot be brought in to the view unless there is a match on. Expand Post. 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. 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. Another way to approach this is to do a join of the data outside Tableau via a federated data source. I have two data sources and doing a data blend. e. If I cant go the above way then is there a possibility to do the duration calculation using table calculations or some other way. data source. Data blending is particularly useful when the blend relationship—the linking fields—need to vary on a sheet-by-sheet. "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. We don't get row-level data from secondary sources on a. 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. Hi Justin, Thanks for your quick reply. Change the default sort order of the field using the various options, and then click OK. I have a calculated field in the Excel data source that returns a binary 1 if the username matches the list in Excel for the facility ID and a 0. Cannot blend the secondary data source because one or more fields use an unsupported aggregation" when Data Blending. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. Final Words. I am creating a couple of formulas to display the total booking from the second data source to the first data source. The relationship is on the facility ID. Twbx and also the . In the Data window, right-click the relevant field. We would like to show you a description here but the site won’t allow us. Russell Christopher (Member) 10 years ago. Use blends when:. I have two data sources and I have blended them together. Filtering data across a worksheet's secondary data source is not currently supported in Tableau Desktop. ” Causes and Workarounds for a Blending Limitation Errors 1. If I cant go the above way then is there a possibility to do the duration calculation using table calculations or some other way. ×Sorry to interrupt. When blending in Tableau, there is always a primary source and a secondary data source. As 'Group' is from a secondary data source, I cannot simply use the sort buttons. 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. "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. 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. Hi . 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. In the past, I've just changed my primary table to the one with the calculation. Data blend is like a Left outer join. Secondary data is one of the two main types of data, where the second type is the. Are use of grouped fields not allowed in data blending? I have two data sources: Opportunities and Products. 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. Loading. I have 2 data sources, A and B, they are linked by data blending with A. Fields from the secondary data source used in the view have an orange tick. 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. Common warnings and errors when blending data sources No relationship to the primary data source. I would like to visualize number of distinct hardware. Before I check Date filters, I got this results. Excel 1 pc. 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. I think I need to define the relationship between the data sources. 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. When trying to use COUNTD() it gives this error: cannot blend secondary data source because one or more fields use an unsupported aggregation when hovering over the Measures because it is now red. Fee". Can anybody please help me with a solution. From what I understand, it's because the link variable must be present in the view, or else it does not work. ×Sorry to interrupt. If you are blending a cube data source, it must be the primary data source. This. Option 2: Join tables that are in the same data source, instead of blending them. 2, Tableau introduces relationships and splits. Primary and Secondary sources in data blending. How ever # no of changes and # of Problems are calculating entire database values. Hi, I have a scenario where I have to use Data Blending option to get certain metric values from Secondary Data Source. See Join Your Data for more information. 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. The two data sources are identical. I am just trying to filter every Data source, by choosing a field that every Data source has. 2. Chicken + Choice of Drink1 pc. 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. 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". Cannot blend the secondary data source because one or more fields use an unsupported aggregation. id, A. 2)Count Distinct from Secondary workaround. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. The version I am working with 10. 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. This can restrict many values from the secondary data source. You can choose whether functional and advertising cookies apply. an aggregated left join where the aggregation of the secondary data cannot be used to increase the level of detail of the primary data. Call it [Start KM]: IF ATTR ( [KM Date])=ATTR ( [OIL]. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. A secondary data source can be used to re-alias the field values in a primary data source. Marked as. . The data is tracked at the subsite level, so I've utilized LOD calculations to determine the min login time and the max logout time fixed on the site level. id = B. Select Default Properties > Sort. Fee" I want to plot Gross Profit (i. ×Sorry to interrupt. Also, data blending is useful for combining data from published. Verify if one of the measures coming from the cube data source has a default aggregation different than SUM, MIN, MAX, COUNT. 3. So, basically, I am having issues with 2 calculations - the FIXED LOD and Remaining Value. 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 . In order to create the waffle chart I am blending it with another datasource using the calculated field defined as [Week 5 (Week5Bond)]. 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. I have three different data source . The syntax for calling secondary data source field is not. First data source looks like below. Mihai Constantinescu (Member) 6 years ago. Ken Flerlage (Member) 5 years ago. Then try using the LOD expression from a secondary 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. When on the dashboard, click on the ‘Dashboard’ drop-down and select ‘Actions’. 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. Cannot blend the secondary data source because one or more fields use the == function, which cannot be computed locally.