Local variables declared inside curly braces are allowed. Ritesh Bisht (Member) 6 years ago. NET/C# Driver automatically translates LINQ queries into aggregation operations. Databricks matches expressions on best effort : For example it will recognize: SELECT c1 + 5 FROM T GROUP BY 5 + c1 as mathing expressions. What I'd really like to do though is define. You can choose whether functional and advertising cookies apply. Data blending has some limitations regarding non-additive aggregates such as COUNTD, MEDIAN, and RAWSQLAGG. Ditto: { FIXED [Patient ID] : COUNTD([Patient ID]) } Yet there it is in your workbook, very happy and functional. An Aggregation represents a MongoDB aggregate operation and holds the description of the aggregation pipeline instructions. General Information. It can be misunderstood, but, when using a data blend correctly, it is an efficient way to merge data sources in Tableau. You can have a parallel level aggregation like: Cannot blend the secondary data source because one or more fields use an unsupported aggregation I have two datasets; one is a shape file that contains regions and locations. Having said this and following the discussion comments being posted by @Timo Rietveld and @Martin Weitzmann I assume that planning to visualize data in Google Data Studio and performing some aggregation functions it would probably required to flatten the data into the simple format using UNNEST operator achieving the best result. IN/EXISTS predicate subqueries can only be used in filters, joins, aggregations, window functions, projections, and UPDATE/MERGE/DELETE commands <treeNode>. Learn more about TeamsIn the Add Dataset dialog, select a dataset and click Add to Workbook. Local variables declared inside curly braces are allowed. The examples in this guide use the restaurants collection in the sample_restaurants database provided in the Atlas sample datasets . Sum, average, and median are common aggregations; for a complete list, see List of Predefined Aggregations in Tableau. I've created the first chart with no problem, but I. Hello I am having a problem with the relationship between two data sources. Unsupported aggregations in data blending Hello, I have a distributor dataset with product ships and returns (one report covering six months), and a retailer dataset with product retail sales and stock (covering the same six months but composed of. 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. I did that in your example too. Let's say for example that you wanted. non-currency measure. I took your LOF and did this { FIXED [PO Number]:sum([FIXED at the line level])} to total your values at the po levelunsupported. PaulWindowed Aggregations. Add it to group by using ordinal position or wrap it in first () (or first_value) if you don't care which value you get. Some of my table calculation are the follow: RED FIELD Tableau Name of First Math Course= IF [Tableau Period of First Math Course]== [Academic Period] AND ( [Subject Desc]=='Mathematics' OR [Subject Desc]=='Mathematics. Hi Justin, Thanks for your quick reply. Golang aggregation group by multiple values with MongoDB. Upvote Upvoted Remove Upvote Reply. hello. You need to show same values as long as you choose districts within a same area. unknown. Make sure that you are blending on dimensions present in the view or on all of the. Hi everyone, I'm trying to blend two data sources on a single field, say 'Program Description'. Get unsupported aggregation. Hi Jim, 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. . Name, Company. You'll need multiple requests to paginate over the composite aggregation but the retrieval of each page is optimized (the composite aggregation doesn't need to visit. Well. Glad that worked out for you Puneeth. Support for Redis Geo commands. This section describes the summary, or aggregation, functions that are available in IBM® Cognos® Analytics - Reporting. Non-additive aggregates are aggregate functions that produce results that cannot be aggregated along a dimension. Exception aggregation on a formula member: No data entry possible because an exception aggregation has been set on a formula member. Just aggregates (like SUM, MIN, MAX. g. Additional summary functions are available in the expression editor. The . The date aggregation operators enable you to extract different parts of a given date or a timestamp. 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". Step 3: Changing the Default Measures for Aggregation in Tableau. Hi @Ajay Velupula (Member) , I think Mahfooj's suggestion makes sense, if you have a common field between the two, in theory it sounds like a join should work and would give a better result than blending. [OIL DATE]) THEN MIN ( [KMs]) END. James--I believe your BLEND is the problem: you're not telling Tableau how to slice & dice the tables together, and including those fields within the view, so Tableau can't tell which Upper and Lower Limits to apply to the data to calculate them and you're getting unsupported aggregation errors. movies` a INNER JOIN `<snip>. And I want to add one of the field from secondary dataset to be in the filter. You can choose whether functional and advertising cookies apply. Queryable Encryption with equality queries is generally available (GA) in MongoDB 7. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. Unsupported Aggregation, Quick Table Calc Sets, and Filters from Secondary Data blends?. If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the. See Array Indexes are Unsupported. coming from secondary data source; There might be non-additive aggregates from a multi-connection data source with a live connection. Ditto: { FIXED [Patient ID] : COUNTD([Patient ID]) } Yet there it is in your workbook, very happy and functional. Since the mongod cannot generate encrypted fields, the resulting timestamp would be. CallTime Avg (internal)>> because CallTime Avg (internal) is interpreted as being. Observations : 1. I've read through the various posts on here, plus the general troubleshooting posts on the Tableau page on blending data, but can't find a solution. Supported aggregations min, max, sum, value_count and avg. To learn more about the Document type, see Documents. Amazon DocumentDB is compatible with the MongoDB 3. apply. elasticsearch. 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 is, and along the way I’ll explain why COUNTD(Customer Name) could be red and the “Cannot blend the secondary data source because one or more. The current aggregation appear as a part of the measures name in the view. Connect and share knowledge within a single location that is structured and easy to search. 1 MongoDB Aggregate shows no result. ) I need to revisit my understanding of the limitations here!Type: Budget. Then use that field as the linking field for your blend. Unsupported aggregation: The following aggregations cannot be inverted: <aggregations>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. $convert with target type string (aka $toString) should accept all supported bson types. At first, I made a lookup operator to link between the two collections, then I wanted to group the. For example, see Text Search in the Aggregation Pipeline. I've tried using COUNTD() ID First Last 1 Jim Carrey 1 Jim Carrey 2 Liam Neeson 3 Wynona Ryder COUNT([ID]) = 4 COUNTD([ID]) results in. For example, non-additive aggregations like COUNTD (count distinct) don’t work unless the blending fields are in the view. unsupported_in_exists_subquery IN/EXISTS predicate subqueries can only be used in filters, joins, aggregations, window functions, projections, and UPDATE/MERGE/DELETE commands`<treeNode>`. Golang aggregation group by multiple values with MongoDB. ) AS t . In other words: Column-references must either be part of the grouping keys, or they must be part of the aggregation. I thought the problems with Median and CountD being unsupported by DB2 blending were over as of version 9 (i am using. 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. 3 and I have created aggregates AGG for fields from data extract and excel file. There are situations like this where I’ve gone back to the data source to build out SQL views that did pre-aggregation, used Alteryx to join in additional information so I didn’t need a data blend, etc. When I calculate the average of a measure and use the filter, it works perfectly fine. Connect and share knowledge within a single location that is structured and easy to search. With DB2 blending and secondary LODs there are three levels of detail involved: the LOD expression, the linking dimensions, and the vizLOD and I don't think Tableau is at this time able to walk through all those levels to figure out exactly what needs what aggregation to get accurate results; so instead it throws up a red pill and the. 1. @Filip: No, the question was "generalize this" and not "generalize operations like this". The following aggregation operation on the orders collection converts the order_date to date before sorting by the date value: // Define stage to add convertedDate field with the converted order_date valueLocal variable usage in aggregations - A local variable cannot be used in an aggregation function if the variable is declared outside of the aggregation function. 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. Trying a different aggregation on DAY([Endtimestamp])? Trying to COUNTD a different field? This won't fix the problem but will help pinpoint which part of the expression Tableau objects to. However, transform requires at least 1 aggregation, the simplest one in this case is e. here is the link to Github issue. Pipeline aggregations do not fit with the paging logic we. Trending Topics. You can't use a measure when it's configured to use an unsupported aggregation type. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. movieIdResolution. privacy statement, for purposes that may include site operation, analytics, enhanced user experience, or advertising. Function to use for aggregating the data. Aggregate functions in S3 Select. The aggregation rule is determined automatically at run time. If you have selected the modeling properties Activate Data and All Characteristics are Key, Reporting on Union of Inbound and Active Table, you can choose from the following aggregation types: Summation, Maximum and Minimum. You may choose to manage your own preferences. FIXED ID, WEEK: CountD (accounts)). this is the sample of getUser function public async getUser(aggregate: o. " For more information on this aggregation method, please see the following link for further support. InternalFilter as an unsupported. CSS ErrorNon-aggregate measures do not perform any aggregation and thus will not perform a double or nested aggregation. For example, Sales becomes SUM (Sales). The data source with the KMs is the primary source. Chicken + Choice of DrinkBurger + Choice of DrinkSpaghetti + Choice of Drink . Good morning - see the attached. The first part is the source data. Tableau can't mix these two types. Driver 2. § 411. Sub-path [interactions-c] points to non single-bucket aggregation" } } ] }, "status" : 500 } this is my index mapping:I created a calculated field that checks to see if Subsidized Price is not null, and added that to the filters shelf, but doing so turns my median calculation into an unsupported aggregation. This aggregation is unsupported: Week Number . Required cookies are necessary for basic website functionality. For more information on exception aggregations, refer to Disaggregation of Values During Data Entry. automatic. This aggregation is unsupported: Median . column1 = a. The aggregation rule is determined automatically at run time. 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. Compatible drivers configured for automatic encryption do not support insert commands with the following behavior: Inserting a document with Timestamp(0,0) associated to an encrypted field. 0 Installed Plugins No response Java Version bundled OS Version Darwin Kernel Version 21. if the JOIN condition is NOT UNIQUE in the above, we assume there is one student with a matching row having both a common sid and. Unsupported aggregation function in Materialized view: string_agg. I keep getting an Unsupported Aggregation error for anything but "terms". When I try to add COUNTD([DistrictId]) from my primary to text table. There is not an specific reason. Maven coordinatesOne solution is to count unique users on client side using the composite aggregation. 0 may result in the physical switch disabling the LAG ports. Supported Aggregation Expressions. Blend ID (transaction datasource) =. Modified 3 years, 2 months ago. Cisco ASR 1000 Series Aggregation Services Routers Software Configuration Guide, Cisco IOS XE 17. Someone in the Community told me the following: "MAX isn't supported in. I would like to visualize number of distinct hardware. Most used methods <init> Popular in Java. The requirement is to provide Average aggregation for a measure in Fiori app (with dynamic sorting and filtering). Measures of type: number or type: yesno act as placeholders so other measures or combinations of measures can be referenced within them. Q&A for work. This is probably the approach I've used the most in my career – it's essentially a cursor disguised as a set-based operation. The Queryable Encryption Public Preview, released in version 6. Aggregation unsupported for type: System. The (0,0) value indicates that the mongod should generate the Timestamp. To achieve this you need to add Calculated Field to an Analysis ( as described here ). See Join Your Data for more information. Any change done to the system defined settings like "ID, Description, Account Type, Hierarchy, Unit & Currencies, Aggregation Type, Exception Aggregation Type, Scale, Decimal Places, Calculate On, Hide" will have impact across all the. Wherever possible, the value of calculated is used, then sum. Databricks matches expressions on best effort : For example it will recognize: SELECT c1 + 5 FROM T GROUP BY 5 + c1 as mathing expressions. It sounds like there might be some complications with a blend? Can’t speak to what’s happening thereIn this example, sort order may be inconsistent, since the borough field contains duplicate values for both Manhattan and Brooklyn. Name: Distinct Count. 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. NET/C# Driver automatically translates LINQ queries into aggregation operations. You switched accounts on another tab or window. I've read through the various posts on here, plus the general troubleshooting posts on the Tableau page on blending data, but can't find a solution. e. Instead OVER aggregates produce an aggregated value for every input row. Does the EXCLUDE function work in this case? Without the SUM/ATTR out of the EXCLUDE the calculation is not working and it asks for an aggregation. Connect and share knowledge within a single location that is structured and easy to search. LACP is currently unsupported with SR-IOV. Median of grades: The middle grade (or the mean of the two middle grades) when grades are arranged in order of size. 5 or below. Pipeline aggregations that take input from other aggregations instead of. So two data sources, blended, trying to do a count distinct on product or whatever in the secondary source. The current aggregation appears as part of the measure's name in the view. Hi Judy, Could you try 'swapping' the datasources, so the one with the [Customer_Code] would become your Primary? You could do it just for one view, Please see if it helps , here it says that problem is with COUNT & they have provided one alternative way as well . For more information, see Compatibility Changes in MongoDB 7. Description. Also, you should realize that "questions like this" is way more subjective and vague than my answer is "argumentative". Teams. Drill down to the leaf level to enter data. getnonce. According to the documentation, Amazon S3 Select supports AVG, COUNT, MAX, MIN, and SUM. 1. For example, a min aggregation on an aggregate_metric_double field returns. In the primary data source I have some calculations that work off of group membership too--some true false that feed into the measures via INT function for a Max aggregation. 106 Aggregation rules. Some aggregation and exception aggregation types do not support data entry. The chart should display: countd. This section lists the supported functionality. Verify if one of the measures coming from the cube data source has a default aggregation different than SUM, MIN, MAX, COUNT. Possible Reason How to resolve this issue; There's a dimension combination rule that defines this data cell as an invalid member combination for data entry. CompanyID =. Cannot blend the secondary data source because one or more fields use an unsupported aggregation Hi. Blending provides a quick and simple way to bring information from multiple data sources into a view. This aggregation is unsupported: Year . Upvote Upvoted Remove Upvote Reply. The workaround for this is that if you have to use one of the non-additive. When you blend, you can only have aggregate access to the rows in the secondary source. I am trying to use the below formula instead of countd function because my data comes from Impala. If I create my calculated field without using an aggregation with {Profit}, QuickSight doesn’t know from which row to get the value. Cannot blend the secondary data source because one or more fields use an unsupported aggregation We are blending two data sources. I'm building aggregations like: AggregationBuilders. 0 or later compatible drivers configured for automatic encryption. However if I try to filter those fields, I seem to lose the ability. getnonce. I am trying to use the below formula instead of countd function because my data comes from Impala. This aggregation is unsupported: Week Number . dataCategory: #CUBE. Call it [Start KM]: IF ATTR ( [KM Date])=ATTR ( [OIL]. I've tried that in the past, and I was always blocked by the unsupported aggregation message. Often the best solution is to rewrite your SELECT without using a correlated sub-query at all. When there is unsupported aggregated measure using WINDOWS Functions, COUNTD,LODs etc. While on a view, right click a data source, click replace data source. It supports pre-built data integrations from 100+ data sources. Mean of grades (with extra credits): Unsupported aggregation provided here only for backward compatibility with old activities. You signed out in another tab or window. However I keep getting the following error: co. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. ; Request you to please help me with. really need to see your twbx file to be of further help. average. {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. I have 2 collections (orders containing products Id and the date of the order (ISODate)) and customers that include the order as a field reference to the order collection. Calculates the number of distinct values of a field within a partition. 9 version and publish them as new (remove previous one). Returns the numerical value of the string as an integer. The measure is using one of the Defined in expression aggregation types, and the expression for the measure contains what looks like a hard-coded aggregate function. One small workaround which you can do is: 1) Create a calculation as {Max([Date])} 2) Create a parameter as follows: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 base . Non-additive aggregates are aggregate functions that produce results that cannot be aggregated along a dimension. Greetings, FranI tried to just blend the two data sources (I edited the relationships already), but then I receive this error: "Cannot blend the secondary data source because one or more fields use an unsupported aggregation. (Ditto the FIXED countD. It said one or more fields use an unsupported aggregation. A sample of Table 2 (secondary) structure. Chapter Title. column1 and -------^ a_s. Usually in this case it is recommended to upgrade the document to a newer version. NET/C# Driver automatically translates LINQ queries into aggregation operations. It can be misunderstood, but, when using a data blend correctly, it is an efficient way to merge data sources in Tableau. The . When you try to do that, Tableau generates the "Cannot blend the secondary data source because one or more fields use an unsupported aggregation" error, turns the offending pill red, and grays out the view. 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. When you add a measure to the view, Tableau automatically aggregates its values. e. When I run the above code, I receive the following error: Validation Failed: 1: Unsupported aggregation type [nested]. filter (name). It shows the next message: "Cannot blend the secondary data source because one or more fields use an unsupported aggregation". Extract and aggregate: Take an extract of your data and aggregate it based on the occurrences of Dimension X. Unsupported aggregation: The following aggregations cannot be inverted: Some aggregation types do not support data entry. To understand the issues related to this log, read the explanation below about the following Elasticsearch concepts: plugin. Unknown file type Secondary Data Source. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. cast. An aggregate_metric_double field is an object containing one or more of the following metric sub-fields: min, max, sum, and value_count. © 2003-2023 Tableau Software, LLC, a Salesforce Company. An introduction to windowed aggregations. Like below,. 61042 - 2014. Data blending in Tableau can be quite tricky, as data from the secondary data sources must be able to be aggregated. formula one layer above to div the amount. Drivers configured for automatic Client-Side Field Level Encryption pass these commands directly to the mongod: getMore [ 1] authenticate. 2. Loading. {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. We are allowed to reference the derived table totals1 in the WHERE clause, as you already do but here we are actually referencing a column, not the table as a whole:. I've tried that in the past, and I was always blocked by the unsupported aggregation message. MongoDB Aggregation pipeline problems. ) A LOD calc is also trying to do stuff at the row level. The examples in this guide use the restaurants collection in the sample_restaurants database provided in the Atlas sample datasets . Specifies that the aggregation type is unknown. Many Tableau developers find data blending frustrating. For example, Sales becomes SUM (Sales). Cannot Blend Secondary Data Source - Unsupported Aggregation. I’ve found a couple examples in the forums. 0. 2. Upvote Upvoted Remove Upvote Reply 1 upvote. Jun 1, 2021 at 9:05. I’ve created this post in order to share my workaround for bringing over a Count Distinct (COUNTD) from a secondary data source. We don't get row-level data from secondary. filter (FilterBuilders. The number is a factor by which the grade value will be multiplied before it is added to the sum of all grades, but the item itself will not. Log In to Answer. Can someone explain why you can't use a CountD from a blended datasource. I couldn’t get anything to work. hello. For more information on aggregation types, refer to Disaggregation of Values During Data Entry. There's a set of views/calcs that show a metric, (metric C) counting distinct number of accounts contacted per person per week (e. This aggregation method is not to be used. It looks like these solutions are coming from 2013. 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. For more information, see Compatibility Changes in MongoDB 7. . Elasticsearch Version 8. Reload to refresh your session. Mean of gradesWe have an enterprise data source that is an SSAS Tabular model. it depends. Aggregation is computed as an average of the values in the result set for this object. 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. ” Causes and Workarounds for a Blending Limitation Errors 1. I believe I first learned. Is the restriction on LOD expressions true even if. You'll need to. Sep 26, 2014 at 15:16. You can retrieve the buckets page by page and do the counting based on the doc count. All Rights ReservedAn old, now unsupported, aggregation strategy is provided here only for backward compatibility with old activities. Cannot blend the secondary data source because one or more fields use an unsupported aggregation can some one has faced this type of issue before or any idea please share. Issue. Bucket aggregations that group documents into buckets, also called bins, based on field values, ranges, or other criteria. since i want only offername from secondary source to the view and the measures are produced from primary datasource is pos_trn (default. Parameters: funcfunction, str, list, dict or None. ver <> 0 ) The key is that the correlation clause is using a. EKKO-EBELN = EKPO-EBELN (1:n) 2. benwtrent Jul 29, 2019. There are non-additive aggregates from a multi-connection data source with an active connection Temporary tables are not supported by multi-connection data sources that use active connections. Data encrypted using the Public Preview is incompatible with the feature release. CREATE MATERIALIZED VIEW V_TMP_PONYLIST BUILD IMMEDIATE REFRESH COMPLETE ON COMMIT AS SELECT. This aggregation is unsupported: Quarter . Loading. Grade aggregation; Grade categories; Extra credit --Grade aggregation. Aggregate using one or more operations over the specified axis. Since there were no actual relation between the tables, this is the way I tried assigning the relationship:In a grouped aggregation, aggregate values (e. Please see if it helps , here it says that problem is with COUNT & they have provided one alternative way as well . ×Sorry to interrupt. In this source create a calculated field to pull out the KMs on the date of oil change. Hi Renad, I've poked around a bit, and this is not something you can do with data blending. In other words: Column-references must either be part of the grouping keys, or they must be part of the aggregation. CSS ErrorAn old, now unsupported, aggregation strategy provided here only for backward compatibility with old activities. Try to use registered UserDefinedFunction to call your aggregation over window. It does not make sense to have different exception aggregation types for the same account in different models. Connect and share knowledge within a single location that is structured and easy to search. using select to. Table arguments are used in a function where. Another table is a a table that contains key fields such as date, region, location and hardware id (dimension). As an alternative I've tried to use Exception. The string value must be a base 10 integer (e. Buckets can only be sorted on a sub-aggregator path that is built out of zero or more single-bucket aggregations within the path and a final single-bucket or a metrics aggregation at the path end. 62K. sql. We use three kinds of cookies on our websites: required, functional, and advertising. Atlas Build on a developer data platform Database Deploy a multi-cloud database Search Deliver engaging search experiences Vector Search (Preview) Design intelligent apps with GenAI Stream Processing (Preview) Unify data in motion and data at restYou will need to transfer this logic into SQL. Related Conversations. 2. Supported Aggregation Stages. I created a machine learning job which uses two metrics as detectors defined as aggregations of fields in my index and everything was working great (Job_0, Datafeed_0 code below). @Point Partner BI Team (Member) hi there,. Max Archived November 30, 2022, 8:03pm 8. Unfortunately, I must use AWS DocumentDB as the production database, which claims to be compatible with MongoDB,. Yup. Aggregation is not supported for this object. The examples in this guide use the restaurants collection in the sample_restaurants database provided in the Atlas sample datasets . pos_trn) (default) . Choose a reason for hiding this comment. ” Group expressions: Expressions that partition the data into categories shown in a data visualization, like “by Region” or “by Sales. the SELECT statement has aggregates WHERE gpa in (SELECT max(gpa). Usually in this case it is recommended to upgrade the document to a newer version. Thank you,unit is corresponding to a geometric relationship to the red target node. Expand Post. The examples in this guide use the restaurants collection in the sample_restaurants database provided in the Atlas sample datasets . Please refer to the above link for usage and configuration details. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. ) If only one of the tables requires row level information, consider making that the primary data source in the blend (I. It is not possible to combine the secondary data source because one or more fields use an unsupported aggregate. The data source with the KMs is the primary source. Select Edit > New > DWORD Value . We use three kinds of cookies on our websites: required, functional, and advertising. Blending provides a quick and simple way to bring information from multiple data sources into a view. An expression has a finer level of detail than the view when it references a superset of the dimensions in the.