Hi All, I have blended primary and secondary data sources. Add a comment | Your Answer Thanks for contributing an answer to Stack Overflow! Please be sure to answer the question. Jim. For more information on exception aggregations, refer to Disaggregation of Values During Data Entry. Materialized is an absolute requirement because of performance reasons, and it is required, that the view updates itself on commit. How to convert number to string using painless script and visualize it. An Aggregation represents a MongoDB aggregate operation and holds the description of the aggregation pipeline instructions. As for transform: date_histogram is supported as part of group_by, I wonder why you try to use it in the aggregation part. Can anyone tell me how I might get the aggregation of the secondary data source irrespective of the filters placed on the linked fields? Expand Post. Unsupported aggregation With the release of the MongoDB Analyzer for . In your config in the screenshot you specify date_histogram twice, however the definition is group_by is all you need. The one drawback is that DB2 blending does not support "non-additive aggregates" like COUNTD() and MEDIAN(). Connect and share knowledge within a single location that is structured and easy to search. My assumption and at least in my test it seems so, is that TOTAL applies the aggregation to all underlying entries in the partition whereas WINDOW_FX uses the function on the already aggregated values. I am trying to put my LOD calculation (below) on the rows shelf but encountering "cannot blend the secondary data source because one or more fields use an unsupported aggregation" {include [DATE MONTH],[STATE]: sum([Quantity. I've tried that in the past, and I was always blocked by the unsupported aggregation message. Amazon DocumentDB is compatible with the MongoDB 3. The InfoProvider contains the records shown below in the inbound queue table. Specifies that the aggregation type is unknown. For example, if the aggregate rule for QI_a is set to sum, and the. "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. UNSUPPORTED_TABLE_ARGUMENTThe Aggregation Framework support in Spring Data MongoDB is based on the following key abstractions: Aggregation, AggregationDefinition, and AggregationResults. If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the. NET/C# Driver automatically translates LINQ queries into aggregation operations. Q&A for work. Characteristics such as optical and catalytic activity may be lost if the dispersion of unsupported Ni NPs is not adequately modulated. Currently, we have 2 different data sources. The only tables allowed to use in a FROM. I tried a few workarounds but nothing has helped. The current aggregation appears as part of the measure's name in the view. apply. For example, Sales becomes SUM (Sales). The requirement is to provide Average aggregation for a measure in Fiori app (with dynamic sorting and filtering). LACP is currently unsupported with SR-IOV. hello. Steps to reproduce: run ES; create rollup job such as this exampleA New Home in New Year for SAP Community: Exciting times ahead for the SAP Community!Hi Shruthi, I am curious regarding your filters and LODs. Exception aggregation behavior. The version I am working with 10. I have this query in azure, what the script is trying to do is to get a date from current stamp. Try loading pyspark functions with an alias instead:. Data encrypted using the Public Preview is incompatible with the feature release. Learn more about TeamsThe aggregation rule is determined automatically at run time. In our example, we could write the original as: select Company. For example, Sales becomes SUM (Sales). How should I got about with this? Thank you. Cannot Blend Secondary Data Source - Unsupported Aggregation. Q&A for work. Unsupported Aggregation while implementing filters from secondary datasource. 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. g. Just aggregates (like SUM, MIN, MAX. privacy statement, for purposes that may include site operation, analytics, enhanced user experience, or advertising. So in my case where CKF1 = RKF1 - RKF2, I will need to store this result in the database as a key figure. The examples in this guide use the restaurants collection in the sample_restaurants database provided in the Atlas sample datasets . When creating a calculation, one of the following errors might occur: "Cannot mix aggregate and non-aggregate arguments with this function. CSS ErrorAn old, now unsupported, aggregation strategy provided here only for backward compatibility with old activities. Number of Views 2. Local Cumulative Computation makes the Process more Efficient. The aggregation is all on primary source data. You are getting the message because the data source can't support the the way you created the groups - it happens with some specific live data source when you try to do calculations that cross records (like counts(), Median() for example)You are not using the correct sum function but the built-in function sum (by default). ” Causes and Workarounds for a Blending Limitation Errors 1. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. Exception aggregation on a formula member: No data entry possible because an exception aggregation has been set on a formula member. NET, we hope to speed up your development cycle and increase your productivity in three ways: 1) by making it easier for you to see how your idiomatic queries map to the MongoDB Query API, 2) by helping you spot unsupported expressions and invalid queries faster (at compile time, baby), and 3). The . Dealing with them was not a walk in the park. You can retrieve the buckets page by page and do the counting based on the doc count. 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. Expand Post. Add the ’ [‘ open-square-brackets to the beginning and ‘]’ close-square-brackets to the end. Norbert, I'm baffled. i. average. For InfoObjects: Only the Overwrite option is available. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. You can. 0, is no longer supported. Max Archived November 30, 2022, 8:03pm 8. 62K. Blue and green arrows denote the aggregation on the neighborhood in the graph and the latent space, respectively. But a filter or range gives org. CompanyID =. All arguments in calculated fields have to be single values or they all. Ditto: { FIXED [Patient ID] : COUNTD([Patient ID]) } Yet there it is in your workbook, very happy and functional. unknown. Connect and share knowledge within a single location that is structured and easy to search. Unsupported aggregate subquery with non-equality correlated predicates Ask Question Asked 3 years, 2 months ago Modified 3 years, 2 months ago Viewed 533. We should add test cases for the scripted fields we currently support to make sure we maintain support. really need to see your twbx file to be of further help. The PipelineDefinitionBuilder class provides a type-safe interface for defining an aggregation pipeline. Wherever possible, the value of calculated is used, then sum. – Ripul. really need to see your twbx file to be of further help. 0 or later compatible drivers configured for automatic encryption. e. The problem is when I try to calculate the median of that same measure. DataFrameGroupBy. In your real world situation, if you have another dimension to split by, you may need to add that term to the left hand side of the LoD. unsupported. Hi. 0: Thu Sep 29 20:13:46 PDT 2022; root:xnu-8020. A value greater than 0 treats a grade item's grades as extra credit during aggregation. Supported Aggregation Expressions. " (Option 1,2,3 or. Suppose you want to create a pipeline that performs the following operations: Matches all documents with "spring" in the Season fieldNo matter how hard I try I cannot get the Order Count to display correctly. Loading. S. As an alternative I've tried to use Exception. InternalFilter as an unsupported. @V1NAY8 For some scripts we probably can't aggregate (like you've found with text). Jehutywong July 16, 2020,. The first part is the source data. formula one layer above to div the amount. Expand Post. You signed out in another tab or window. Let's say for example that you wanted. elasticsearch. Most used methods <init> Popular in Java. I have a User model and I want to perform generic aggregation. I’ve created this post in order to share my workaround for bringing over a Count Distinct (COUNTD) from a secondary data source. For more information, see Compatibility Changes in MongoDB 7. 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. Over Aggregation # Batch Streaming OVER aggregates compute an aggregated value for every input row over a range of ordered rows. 9 version and publish them as new (remove previous one). If a function, must either work when passed a DataFrame or when passed to DataFrame. However, some operators are only available in queries. Unsupported. since i want only offername from secondary source to the view and the measures are produced from primary datasource is pos_trn (default. Connect and share knowledge within a single location that is structured and easy to search. Expand Post. 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. Name: Distinct Count. name from t1 t inner join category c on t. Expand Post. Aggregate functions in S3 Select. Choose a reason for hiding this comment. The following commands do not require automatic encryption. It looks like these solutions are coming from 2013. You signed in with another tab or window. Python is confused between its built-in sum function and the pyspark aggregation sum function you want to use. Pipeline aggregations that take input from other aggregations instead of. We use three kinds of cookies on our websites: required, functional, and advertising. unknown. Alternate names:. Steps to Implement Tableau Aggregation. Unsupported Field Types Queryable Encryption with equality queries is generally available (GA) in MongoDB 7. THEN add this total to the SUM of the projected_users from today's date through month X. Golang aggregation group by multiple values with MongoDB. Cannot blend the secondary data source because one or more fields use an unsupported aggregation Hi. . 💥Check my Website💥 Troubleshoot Data Blending in Tableau Part 2 here SHOP values are being replicated, changing the aggregation for the relevant field in the view (for example, from AVG to SUM) will not change the result of the aggregation. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. Expand Post. 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. Also, what's the intention of the formula? Doing a COUNTD on DAY() will count the different calendar days that it happened, ignoring the month. ; Request you to please help me with. We have a calculated filed where an aggregation (COUNTD) is done on a filed of secondary data source. Unsupported DefaultAggregation: #AVG in analytical CDS. Non-additive aggregates are aggregate functions that produce results that cannot be aggregated along a dimension. LACP Compatibility with vDS Basic LACP (LACPv1) is only supported on vSphere versions 6. Ask Question Asked 3 years, 2 months ago. Stores pre-aggregated numeric values for metric aggregations. getnonce. Next, create a table calc using the [Start KM] to calculate the total KMs: LINQ allows you to construct queries against strongly typed collections of objects by using language keywords and operators. Cannot blend the secondary data source because one or more fields use an unsupported aggregation We are blending two data sources. A COUNTD calculation gives the answer as 5 since the sales for account B came through two separate units. However if I try to filter those fields, I seem to lose the ability. " Expand Post. My goal is simple, inflation adjust wage data, maybe there is a more simple way to accomplish what I used a table calculation for? It seems overly complicated in Tableau the way I am currently adjusting wages to. 55135 - Vivado Synthesis - Unsupported SystemVerilog Constructs. If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the. ) I need to revisit my understanding of the limitations here! 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 . 6, 4. Queryable Encryption with equality queries is generally available (GA) in MongoDB 7. Elasticsearch organizes aggregations into three categories: Metric aggregations that calculate metrics, such as a sum or average, from field values. Any currently unsupported aggregation operators and expressions can be used by implementing AggregationOperation or AggregationExpression respectively. really need to see your twbx file to be of further help. 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. 4. Description. The current aggregation appear as a part of the measures name in the view. non-currency measure. I've tried that in the past, and I was always blocked by the unsupported aggregation message. E make table 2 the primary. The data source with the KMs is the primary source. Aggregation is computed as an average of the values in the result set for this object. i will try to build some moke up data in excel and reproduce the same but before that could you please explain me in detail what calculation i need to perform in secondary source. Upvote Upvoted Remove Upvote Reply. In the Data page, go to the Data Diagram and locate the datasets to blend. 61042 - 2014. filter (name). In find, you cannot specify a query condition on the text score. 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. Data blending is a way to combine data in Tableau. Extract and aggregate: Take an extract of your data and aggregate it based on the occurrences of Dimension X. If you need to use an unsupported operation in an aggregation, you must define the entire expression using the BSON Document type. average. Cannot blend the secondary data source because one or more fields use an unsupported aggregationFollow this link for more information:×Sorry to interrupt. Aggregation is not supported for this object. My goal is to create a MONTHLY count of applications by ACADEMIC YEAR, SCHOOL CODE, and GRADE. Log In to Answer. Connect and share knowledge within a single location that is structured and easy to search. When I do the join between the SSAS Tabular Model (primary data. Ask a Question. Is the restriction on LOD expressions true even if. I am getting Cannot blend secondary data source because one or more fields used an unsupported aggregation. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. hello. I have the following BigQuery query, which returns results: SELECT a. When you add a measure to the view, Tableau automatically aggregates its values. The supported. Well. [OIL DATE]) THEN MIN ( [KMs]) END. $convert with target type string (aka $toString) should accept all supported bson types. {SUM([Total])} / {COUNTD([ID])} In the attached I've shown what each part of the formula is doing. Amazon's S3 Select allows a user to write SQL against S3 objects, but there's insufficient documentation around what standard SQL functionality is supported. 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. 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. Tableau can't mix these two types. What is the max length of the first characters are are in F Name? Is it always three or less? The issue with this join is the information on how much to join is in the one table, while the data to test is in the other. 12. [OIL DATE]) THEN MIN ( [KMs]) END. Some aggregation and exception aggregation types do not support data entry. getnonce. Returns true if the first parameter string value ends with the. In this source create a calculated field to pull out the KMs on the date of oil change. 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. Hello I am having a problem with the relationship between two data sources. The version I am working with 10. 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 - Teams. Unsupported Aggregation, Quick Table Calc Sets, and Filters from Secondary Data blends?. Data blending has some limitations regarding non-additive aggregates such as COUNTD, MEDIAN, and. 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. There are two types of calculated fields: on a data set level and on on analysis level. For more information on aggregation and exception aggregations, refer to Disaggregation of Values During Data Entry. Someone in the Community told me the following: "MAX isn't supported in. 2. I am trying to show an empty column on the X axis even when the aggregation value (the row) is 0. ”Unsupported aggregation type. ”. Q&A for work. Right click the vDS, then Settings > Export configuration to back up the existing configuration of the vDS. I get error: “Cannot blend the secondary data source because one or more fields use an unsupported aggregation. Hi Renad, I've poked around a bit, and this is not something you can do with data blending. Hevo is a No-code Data Pipeline. LINQ allows you to construct queries against strongly typed collections of objects by using language keywords and operators. In Elasticsearch, an aggregation is a collection or the gathering of related things together. Kindly see the screenshot as below:-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. Upvote Upvoted Remove Upvote Reply. getType() + "]"); Copy link Member Author. Functional cookies enhance functions, performance, and services on the website. Learn more about TeamsSupported and Unsupported Aggregation Pipeline Stages. average. While on a view, right click a data source, click replace data source. I get error: “Cannot blend the secondary data source because one or more fields use an unsupported aggregation. For example, a min aggregation on an aggregate_metric_double field returns. This aggregation method is not to be used. The Dept Target field is producing an integer (A). I am trying to blend the same data against the other because I wanted to show Same Period last Year. Hi Chris. Don Wise (Member) 3 years ago. 0CALDAY (YYYY-MM-DD) 0CALMONTHThis guide will help you check for common problems that cause the log ” Unsupported aggregation type [{}] ” to appear. The default_metric subfield is used for delegating queries, but not aggregations. This aggregation is unsupported: Month . Jim. We have a calculated filed where an aggregation (COUNTD) is done on a filed of secondary data source. I get error: “Cannot blend the secondary data source because one or more fields use an unsupported aggregation. 5 or below. You can use the variable REMOVE in aggregation expressions to conditionally suppress a field. and no matter how I try to structure it - even doing all the calculations out in one field - I get a perfectly valid object that cannot be dragged into a sheet that has ANYthing else in it, citing 'Unsupported Aggregation' and turning red. movieId GROUP BY a. If there is another aggregation type such as AGG_AVG being used, change it to one of the supported. 0. It shows the next message: "Cannot blend the secondary data source because one or more fields use an unsupported aggregation". Pipeline aggregations do not fit with the paging logic we. The unsupported aggregation happens when your aggregate requires row-level visibility to the secondary data source. hi Jay, So this should do the trick. 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. When I calculate the average of a measure and use the filter, it works perfectly fine. I did that in your example too. If I cant go the above way then is there a possibility to do the duration calculation using table calculations or some other way. Learn more about TeamsNote: Link Aggregation Control Protocol (LACP) can only be configured through the vSphere Web Client. Hi Justin, Thanks for your quick reply. If the conversion fails,. Hi everyone, I'm trying to blend two data sources on a single field, say 'Program Description'. What is an Elasticsearch aggregation?. This document lists the unsupported command in Cisco ASR 1000. I’m trying to find the date when customer leave by labeling who doesn’t have transaction the next day. My step-by-step blueprint for using Looker Studio (formerly Google Data Studio) Get the FREE ebook on Looker Studio (75 Pages)2. If the user select May 2018. What I'd really like to do though is define each of those metrics based on a filter unique to each metric. is there any way to rewrite below function and get the same result?JVM since 2. 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. Required parameters: type: budget; threshold: <amount> – cost threshold in configured currency units aggregation: <agg-parameter> – configurable, accepts all aggregations supported by the aggregated cost model API filter: <value> – configurable, accepts a single filter value. 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. Primary Data source - Actuals ( day grain) Secondary data source - Goals (quarter grain) Calculated Measures: Primary Data source :- CustCount = CountD( Cust_ID ). 51327 - Design Assistant for Vivado Synthesis - SystemVerilog Data Types Support. I tried suggestions from this link, but no luck. Teams. Try to use this calculation:. Many Tableau developers find data blending frustrating. Jun 1, 2021 at 9:05. This aggregation is unsupported: Median . This is the correlated subquery: (Select top 1 Column c From table A a_s Where a_s. EKPO-EBELN = EKET-EBELN. Correlated subquery patterns that are not supported. I'm using lookup to join two collections, the foreign key is a string value located in request_by array and the other one is ObjectIdaggregation. For this reason, I applied a work-around, in which I add an aggration around the nested-field aggregation, as shown in the code below:HI Prakhar, It may happen because of actually n/w went down or deadlock in query execution or connection time exhausted . I'm trying to create a frequency distribution as a percent of total for individual products in a single category on one chart, then dual axis a second chart with the frequency distribution of the category for comparison purposes. To learn more about the Document type, see Documents. With this option, new values are updated to the InfoObject. Official drivers compatible with MongoDB version 6. To understand the issues related to this log, read the explanation below about the following Elasticsearch concepts: plugin. The problem is that calculation on CDS views by default are done at records level and aggregated, hence my idea was to use the @DefaultAggregation: #FORMULA annotation to get the desire result. Blending with CountD and LODs. This is a bug and support for IntervalValueCount should be added. ver <> 0 ) The key is that the correlation clause is using a. 0, and 5. Keep asking questions as you progress on your journey with MongoDB, and soon you’ll be helping those who are new on the path. We are blending two data sources. Drill down to the leaf level to enter data. You misread it apparently, and downvoted everyone for not answering a different question. Share. Glad that worked out for you Puneeth. In effect, the correlated subquery is run after the aggregation, so it can only use columns and. What’s inside. A few types of correlated subqueries follow patterns that Amazon Redshift can't decorrelate and doesn't support. 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. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. functions as psf. Step 2: Setting the Default Aggregation for a Measure in Tableau. The following rules apply in determining the number and size of employers, as required by the MSP provisions for the aged and disabled: ( a ) All employers that are treated as a single employer under subsection (a) or (b) of section 52 of the Internal Revenue Code (IRC) of 1986 ( 26 U. ProductionDate)' is neither present in the group by, nor in an aggregate function. Upvote Upvoted Remove Upvote Reply. This aggregation is unsupported: Median . I am wondering if there is a better way now. Both Primary and Secondary data sources have duplicate rows due to multiple joins in data prep. In this source create a calculated field to pull out the KMs on the date of oil change. 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. Modified 3 years, 2 months ago. 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 . Expand Post. I understand that it happens but can some give me the high level why Tableau can't do it. keep the dimensions in the view. ” Causes and Workarounds for a Blending Limitation Errors. 3. It can be misunderstood, but, when using a data blend correctly, it is an efficient way to merge data sources in Tableau. The examples in this guide use the restaurants collection in the sample_restaurants database provided in the Atlas sample datasets . Optional: To change the match for a column, click the name of the column and select a different column. Non-additive aggregates from the secondary data source(All Number functions, except for MAX and MIN, are non-additive. This. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. 52 (a) and (b)) are. When projecting or adding/resetting a field within an embedded document, you can either use dot notation, as in. unsupported aggregation. . This is the calculation in the secondary data source for January's Application Volume: DATENAME ('month', [Date Application])='January' then [Applicant ID] end )} The calculation works fine, however,. Applications using explicit Queryable Encryption may use this page. query. Use a Data Extract: Creating a data extract can sometimes help resolve unsupported aggregation errors by creating a static, aggregated view of the data that is more compatible for blending. NET/C# Driver automatically translates LINQ queries into aggregation operations. Supported functions. 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>`. I get "unsupported aggregation type [multi_terms]" @Val – Orkun. The Queryable Encryption Public Preview, released in version 6. 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. It is not supported by ElasticSearch. i will try to build some moke up data in excel and reproduce the same but before that could you please explain me in detail what calculation i need to perform in secondary source. ) (if the join requires aggregation or grouping, you'll have to use a derived or virtual table: JOIN ( SELECT. Option 2: Rewrite your SELECT without a Correlated Subquery. 2. Non-additive aggregates are aggregate functions that produce results that cannot be aggregated along a dimension. 5 and have 2 data sources RPT and AD in the workbook which are currently extracts. I've tried using COUNTD() ID First Last 1 Jim Carrey 1 Jim Carrey 2 Liam Neeson 3 Wynona Ryder COUNT([ID]) = 4 COUNTD([ID]) results in error Cannot blend the secondary data source because one or more fields use an unsupported aggregation. 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. I'm pulling my hair out here. I did that in your example too. Any help would be appreciated! #1 COUNTD([ID]) / TOTAL(COUNTD([ID]))In the attached simple excel example I need to count that I have 4 accounts (Account A, B, C, and D) based on the Account Name field. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. Atlas Data Federation supports all the aggregation pipeline stages except the following: For the following stages in Atlas Data Federation queries, Atlas Data Federation introduces an alternate syntax, includes a caveat, or deviates from server.