Filter each of the data sources independently on the more granular dimensions. If it’s not supported, you may need to upgrade your. Tableau allows changing the aggregation of a field for specific use in the worksheet. Jim. Resolution. Creating a continuous aggregate for the other parts of your query, then; Using the window function on your continuous aggregate at query time; For example, say you have a hypertable named example with a time column and a value column. 5. IN/EXISTS predicate subqueries can only be used in filters, joins, aggregations, window functions, projections, and UPDATE/MERGE/DELETE commands <treeNode>. For example I might need to add a dimension to the view to get my non-additive aggregate or LOD to work and then I get a lot of extra marks, then I could use something like IF FIRST()=0 THEN SUM() END to get back to a single mark for each partition. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. I am trying to blend the same data against the other because I wanted to show Same Period last Year. if a host has 2 interfaces ports ( A & B ) connected to switch A on port 1 & port 2. Then use that field as the linking field for your blend. additional request properties set programmatically. It shows the next message: "Cannot blend the secondary data source because one or more fields use an unsupported aggregation". This section describes the summary, or aggregation, functions that are available in IBM® Cognos® Analytics - Reporting. An introduction to windowed aggregations. For more information, see Alias Field Values Using Data Blending. Innovate fast at scale with a unified developer experienceIn blending data source, I try to slove problem but I can't. Can anybody please help me with a solution. We use three kinds of cookies on our websites: required, functional, and advertising. Consider a books collection with the following document: {"_id": 1,Cannot blend the secondary data source because one or more fields use an unsupported aggregation. Currently windowed aggregations cannot be combined in the same SELECT statement with GROUP BY, HAVING, or any. clients. Thanks, PaoloThis didn't work alas, "cannot blend secondary data source because one or more fields use an unsupported aggregation" I am using a filter from a different datasource to filter by region . ” Its important to view the data using all the . Add a comment. A secondary data source can be used to re-alias the field values in a primary data source. We have to use two data sources for the visualization. Data blending has some limitations regarding non-additive aggregates such as COUNTD, MEDIAN, and RAWSQLAGG. AbstractFileSystem. You can use the variable REMOVE in aggregation expressions to conditionally suppress a field. In the Data pane, double-click a spatial field. From the Data pane, drag a dimension field to Label on the Marks card. i want to create a segmentation for my customer based on three things: Days since last purchase (This comes from a query that has user_id, min(day_since_last_purchase) from X) – i need to do the min because there are multiple profiles per user and i want to know the min per user regardless the profile % change in. Loading. 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 be. Hello Jim, Thank You for your reply. – Ripul. ) I need to revisit my understanding of the limitations here!I get error: “Cannot blend the secondary data source because one or more fields use an unsupported aggregation. Expand Post. (Ditto the FIXED countD. If you can find an implementation of that for S3, you can specify it using fs. 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. mean any array of object I pass to this function it executes. 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 am trying to sync the axis using a reference line. Ritesh Bisht (Member) 6 years ago. I'm using a cube data source as my primary and am attempting to blend with an Excel sheet. Select Edit > New > DWORD Value . Windowed aggregations partition the results from a SQL query into groups in order to perform calculations across adjacent rows of the query result. 1. The following SQL features are not supported in materialized views: Left/right/full outer joins. Usage In SortIf you have selected the modeling properties Activate Data and Write Change Log, you can choose from the following aggregation types: Summation, Maximum, Minimum and Overwrite. ×Sorry to interrupt. (So does the original [Pivot Field Names] field. Click on the different cookie categories to find out more about each category and. response “Cannot blend the secondary datasource because one or more field use . Wrap the Total KMs formula in: IF FIRST ()=0 THEN [Total KMs] END. countD requires row-level access to the data, not just aggregate access. And I use Join data source, after divide measures / row duplicate. Aggregate Functions #. We use three kinds of cookies on our websites: required, functional, and advertising. See Join Your Data for more information. CSS ErrorUnsupported Commands in Serverless Instances. Using { allowDiskUse: false } to prohibit writing temporary files out to disk when allowDiskUseByDefault is set to true. ELSE D1. cannot blend secondary data source because one or more fields use an unsupported aggregation beacuse of LOD. ELSE D1. Documents flowing through the aggregation pipeline are classified. Query Expressions. but no collectToAggregationThe SQL Language. Because in Tableau, you don't use COUNTD function when Blending data source. Here is a slimmed down version what I'm trying to do. QSS Overview; QuRouter. You can choose whether functional and advertising cookies apply. ) I need to revisit my understanding of the limitations here!Cannot blend the secondary data source because one or more fields use an unsupported aggregation. thomaspatzke commented Dec 9, 2018. Sorting by a tuple with 2 values is much slower. THEN add this total to the SUM of the projected_users from today's date through month X. 2. [Secondary Source Field]))}) This seems to be the only calculation that is valid. With LAC-A functions, you can specify at what level to group the computation. Then the pivot rearranges it, creating columns for the in values from the name column, and using the aggregate ( max (data)) for the value in that column, which should give the desired results. Wherever possible, the value of calculated is used, then sum where necessary, followed by unsupported. We are blending two data sources. ) Two approaches to consider: 1) Make your Stores data source your primary data source. You can choose whether functional and advertising cookies apply. _types. 06. Error: Cannot Blend the secondary data source because one or more fields use an unsupported aggregation. For more information on blends, check this out: Blend Your Data - Tableau . 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. By adding one argument into an existing aggregate function, such as sum() , max() , count(), you can define any group-by level that you want for the aggregation. We don't get row-level data from secondary sources on a blend. Set the table calculation to COMPUTE USING using the KM Date field. really need to see your twbx file to be of further help. Jim. There are corresponding countToAggregation , countDistinctToAggregation etc. Use a Join instead of Blending: If blending is not necessary for your analysis, you can try joining the data sources instead. They both share a common field (State), and that is what I'm filtering on. the second tab “by Industry”, if you try to filter by SBU or BU, “Held” or “Scheduled”3) Use aggregate measures instead of filters, for example by using ATTR(Dimension). I'm trying to get the total of the secondary data source field irrespective of the filters using something like this - SUM({FIXED :(SUM([Secondary Source]. I get the the following error: unsupported aggregate action Digging through the source code I found there is no handler for collect. Add the columns or the expression to the GROUP BY, aggregate the expression, or use <expressionAnyValue> if you do not care which of the values within a group is returned. (Ditto the FIXED countD. Unlike the other multi-bucket aggregations, you can use the composite aggregation to paginate all buckets from a multi-level aggregation efficiently. See Array Indexes are Unsupported. Most of the KPI's are straight forward to aggregate and compare but AVG FLEET requires the use of LOD expressions. From the Data pane, drag a dimension field to Label on the Marks card. You can choose whether functional and advertising cookies apply. Real-time aggregates automatically add the most recent data when you query your continuous aggregate. LOD expressions are used when running complex queries with multiple dimensions at the data source level. The chart should display: countd. All rights reserved. See more details I am doing on my workbook, ## KPI Calculation#Calculated Field03 - KPI_ExistenceCheck-E3D-COMOS-1SUM( [ExistenceCheck-E3D-COMOS-OK-1])/ COUNT ( [Number of Records])Error: Argument. Primary Data source - Actuals ( day grain) Secondary data source - Goals (quarter grain) Calculated Measures: Primary Data source :- CustCount = CountD( Cust_ID ). ×Sorry to interrupt. To indicate a cursor with the default batch size, specify cursor: {}. This happens only when the data sources are impala. Good morning @Fred Yu (Customer) . Thanks for your help . Basically, I am using filters with only one filter (thus only one bucket) so that we can have a max bucket pipeline aggregation (which only supports multi-bucket) and then the pipeline aggregation name can simply be the detector field name (metric1_value and matric2_value in this specific case):This time we're going to do what would have been a MongoDB aggregation pipeline, but this time using LINQ. Click on the different cookie categories to find out more about each category and to change the default settings. bucket. 3 and I have created aggregates AGG for fields from data extract and excel file. 1. Expand Post. I've tried that in the past, and I was always blocked by the unsupported aggregation message. Jim. The issue was that the bucket sensor that I had previously defined in my telegraf. Step 3: Create assignment or drag & drop key figure in target. You can also permanently remove the aggregated Ethernet interface from the device configuration by deleting it. category = c. coming from secondary data source There might be non-additive aggregates from a multi-connection data source with a live connection. in telegraf. Fleet for one year. 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. The version I am working with 10. Non-additive aggregates are aggregate functions that produce results that cannot be aggregated along a dimension. SQLSTATE: none assigned. If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the. Unlike the other multi-bucket aggregations, you can use the composite aggregation to paginate all buckets from a multi-level aggregation efficiently. However, to get to that point sometimes the granularity of the view has to be increased (so that a dimension filter from the secondary can be done using an aggregate filter, or to make sure all the linking dimensions are in the view, etc. Which almost works, but if I then try to use the resulting calculated field as the “angle” variable for a pie chart, I get the following error: Cannot blend the secondary data source because one or more fields use an unsupported aggregationnumber of records (datasource1)/total headcounts (datasource2) and i get the red pill telling me "cannot blend the secondary datasource because one or more fields use an unsupported aggregation". Add a comment. When you use such an expression in the view, Tableau will aggregate results up to the view level. 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. M". Unsupported aggregation in secondary data source using an LOD expression. Is there a way to do it in a single query like in. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. Name, Company. . 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. I tried using Excel as the primary and I kept getting errors when I tried to add the cube. Ask Question Asked 2 years, 7 months ago. We use three kinds of cookies on our websites: required, functional, and advertising. Unsupported aggregate subquery with non-equality correlated predicates. Change Default to be False — This tells the Format as HTML Pro step to not use the default data type as dictated by the recordset, but. The following aggregation operation on the orders collection converts the price to a decimal: // Define stage to add convertedPrice and convertedQty fields with // the converted price and qty values. 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 valueWe use three kinds of cookies on our websites: required, functional, and advertising. An old, now unsupported, aggregation strategy is provided here only for backward compatibility with old activities. So you're basically passing a string 'converted' to the python built-in sum function which expects an iterable of int. Unsupported SQL features. Cannot blend the secondary data source because one or more fields use an unsupported aggregationFollow this link for more information:We use three kinds of cookies on our websites: required, functional, and advertising. Cannot blend the secondary data source because one or more fields use. An expression has a finer level of detail than the view when it references a superset of the dimensions in the view. This should explain why when you are using the SUM aggregation it works. Click on the different cookie categories to find out more about each category and to change the default settings. really need to see your twbx file to be of further help. e. 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 be. As of Version 3. You can use aggregations in the analysis level calculated field. 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. Some functions, such as , are available only when you click the summarize button on the report object toolbar. It is not allowed to use an aggregate function in the argument of another aggregate function. java. ×Sorry to interrupt. Apache, Apache Spark, Spark, and the Spark logo are trademarks of the Apache Software Foundation. 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. I created a parameter with a simple calculated field so that I may toggle between two measures. To add aggregation to a field for a pivot table visual. (You need to get individual row access to evaluate DISTINCT functionality. PIVOT supports the COUNT, SUM, MIN, MAX, and AVG aggregate functions. Hello Jim, Thank You for your reply. Unknown, media type is unknown media type output flow-control is unsupported, input flow-control is unsupported ARP type: ARPA, ARP Timeout 04:00:00 Last input never, output never,. Elasticsearch organizes aggregations into three categories: Metric aggregations that calculate metrics, such as a sum or average, from field values. General Information. apply. Atlas Data Lake supports all the aggregation pipeline stages except the following: For the following stages in Atlas Data Lake queries, Atlas Data Lake introduces an alternate syntax, includes a caveat, or deviates from server. 75K subscribers 3K views 4 years ago Cannot blend the secondary data source because one or more fields use an unsupported aggregation It’s cable. Instead of processing the strings in application code, you can use the aggregation string operators to push the data processing down to the database. Tableau Tip 5. You'll always want to return the same type, so that in itself could be an issue. 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. The primary one is called Dim_Service_Status. ORDER BY clause) but you should expect the order not to match. NoDays >> * <<root. Click anywhere on the Field wells to expand them. I've created the first chart with no problem, but I. QNAP’s QuRouter OS simplifies managing high-speed and high-coverage LAN/WAN. Where the description. Upvote Upvoted Remove Upvote Reply. Can't see what you are actually doing but Blending data has its limits. api. We use three kinds of cookies on our websites: required, functional, and advertising. Chicken + Choice of DrinkBurger + Choice of DrinkSpaghetti + Choice of Drink . UNSUPPORTED_TABLE_ARGUMENTWindowed Aggregations. Blending provides a quick and simple way to bring information from multiple data sources into a view. What that will do is return a single record, the most recent transaction for each branch id (all other transactions will have a null blend ID) - then you can do a count. I had a query w. 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. You can use the variable REMOVE in aggregation expressions to conditionally suppress a field. Currency measure vs. ” Causes and Workarounds for a Blending Limitation Errors. Tested it manually by setting the load of odd GPU id’s to “Not supported” and sorting according to load. The second method, which is new to 11. Please use the. I took your LOF and did this { FIXED [PO Number]:sum([FIXED at the line level])} to total your values at the po levelCannot blend the secondary data source because one or more fields use an unsupported aggregation. As tableau automatically aggregates its value using predefined aggregate functions. I figured out why the exception aggregation is not pushed down to HANA. us/multipleconnections_troubleshooting. Please use the. Correlated references to a. We are going to explain the concepts mostly using the default micro-batch processing model, and then discuss Continuous Processing model. Collectives™ on Stack Overflow – Centralized & trusted content around the technologies you use the most. 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". filters on the worksheet, so we cannot drop filters out from the worksheet. In the secondary data I have a LOD field called Total_Category_Response defined as { FIXED [Category]: SUM([Respose_ValWe use three kinds of cookies on our websites: required, functional, and advertising. ) to such a degree that you need table calcs to re-aggregate to get to the desired granularity of the display. The driver does not provide methods for all aggregation pipeline operators in the Query API. cannot blend the secondary data source because one or more fields use an unsupported aggregation. If one. r. One common approach is meta-aggregation, as advocated by JBI. Tommy Sims (Member) 7 years ago. Solution using relationship:Aggregates functions we use only in SELECT block. The PIVOT aggregate expression has to be a call of a supported aggregate function. Yes, the near operator isn't very well supported by sigmac. Thus I have this calc below . Hopefully. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. If. We have a two data sources in Excel. Notice that order matters when the JSON snippets have some common properties: just as when setting property values programmatically, the last value that is set for a property overwrites the previous one. 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:. What the message is basically saying is that you can’t reference a value in one row and also have aggregations. CSS ErrorIn order to display all SPA counters on SPA Aggregation ASIC, use this command: Router#show platform hardware slot 1 plim statistics 1/0,. "-5. Table 9. But a filter or range gives org. step 1 : I do teaming for interface A & B, enable LACP on virtual teaming interface. I am trying to use the below formula instead of countd function because my data comes from Impala. If you need to use an unsupported operation in an aggregation, you must define the entire expression using the BSON Document type. g. For example, Sales becomes SUM (Sales). Use expressions to define the values that are sent from Tableau to the analytics model. Embedded Document Fields. But considering using it with Materialized View, the doc says SimpleAggregateFunction(name, types_of_arguments…) data type stores the current value of the aggregate function, and does not store its full state as AggregateFunction dose, which means. step 1 : I do teaming for interface A & B, enable LACP on virtual teaming interface. Extract and aggregate: Take an extract of your data and aggregate it based on the occurrences of Dimension X. Step 1: Adding Tableau Aggregation Measures. When using the function, the data types and order of the expressions must match that of the input arguments. Isilon - Link Aggregation LACP. The tff. this is the sample of getUser function public async getUser(aggregate: o. In the LACP section, click the +NEW symbol to create a new LAG. CallTime Avg (internal)>> because CallTime Avg (internal) is interpreted as being. I have two data sources to be used but need the count distinct of users from both the data sources. You can choose whether functional and advertising cookies apply. elastic. 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. Go to a new worksheet. PaulYou can still use the field with COUNTD() from the secondary data source if you remove all dimensions from the secondary data source (i. Loading. Hi All, I have blended primary and secondary data sources. I put a twb file. When I am joining the two data sources I wanted to use "F Name" column with "Name" column. We use three kinds of cookies on our websites: required, functional, and advertising. 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 . t Link Aggregation. We don't get row-level data from secondary. 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. You can choose whether functional and advertising cookies apply. ” Causes and Workarounds for a Blending Limitation Errors 1. When I am joining the two data sources I wanted to use "F Name" column with "Name" column. Group by with no aggregation expression is not supported. And I want to add one of the field from secondary dataset to be in the filter. Hadoop provides two fs interfaces - FileSystem and AbstractFileSystem. Golang mongodb Aggregation too many values in. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. If a function, must either work when passed a DataFrame or when passed to DataFrame. Refresh. Note you'll need the KM Date field on the Detail shelf. addShard () addShardToZone. This property guarantees that partial aggregation. CSS ErrorHi Ben, This comes from my own explorations and got confirmed by the Tableau dev who built the latest version of data blending (called DB2). Bucket aggregations that group documents into buckets, also called bins, based on field values, ranges, or other criteria. e. You should wait for the next scheduled. I've tried that in the past, and I was always blocked by the unsupported aggregation message. ERROR 2381: Cannot create a sequence with RESTART. Data blending limitations. 1 MongoDB Aggregate shows no result. I read that this is not possible. Argument to SUM (an aggregate function) is already an aggregation, and cannot be further aggregated. Step 4: Select key figure in “Target” and right lick on it. 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. You can choose whether functional and advertising cookies apply. Norbert, I'm baffled. For example, you would not be able to use a measure with the expression <<root. The limitation on mixing data often occurs with non-additive aggregates such as MEDIAN or COUNTD. You can choose whether functional and advertising cookies apply. You can choose whether functional and advertising cookies apply. Step 2: Setting the Default Aggregation for a Measure in Tableau. CSS ErrorI'd like to always use D1 except when it is NULL and then I'd like to use D2. I have linked 2 sources using 3 dimensions. I made a calc that mimicked your group, and if I use that on colors, the sheet works as you want. The version I am working with 10. 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 . Supported and Unsupported Aggregation Pipeline Stages. Select the data source you want to visualize. CSS ErrorHi, In case of blending some of functions like countd , Min, Max will not work if the dimensions are in any of shelfs or in filters . I couldn’t get anything to work. Output tables contain a single row with the aggregated value. I’ve found a couple examples in the forums. Loading. Be sure to use aggregation functions (SUM, AVG, etc. The Junos OS removes the configuration statements related to aex and sets this interface to down state. There are some data blending limitations around non-additive aggregates, such as COUNTD, MEDIAN, and RAWSQLAGG. Provide details and share your research! But avoid. Hi. In the Value field, enter the amount of time (in minutes) you want the old password to still be active after a password reset. Tommy Sims (Member) Set the table calculation to COMPUTE USING using the KM Date field. Rather than return incorrect results, Tableau turns the pill red, greys out the view, and generates the unsupported aggregation message. Asking for help, clarification, or responding to other answers. The ARRAY_CONTAINS method requires a second parameter to use in GROUP BY clause which I think will take 1 reason at a time. Let's say for example that you wanted. e. If if this is the case, you could try creating a calculation for. One is to create a pass-through SQL table. That's why you can't do COUNTD on a secondary blended data source. For example, there are aggregates to compute the count, sum, avg (average), max (maximum) and min (minimum) over a set. You can choose whether functional and advertising cookies apply. node. The current aggregation appears as part of the measure's name in the view. The result now should be correct BUT it'll return the result multiple times, once for each date. CSS Error In both instances, once I take customer country from my secondary source, I get this error: Cannot blend secondary data source as one or more fields use an unsupported aggregation . Click on the different cookie categories to find out more about each category and to change the default settings. No, the intention of the composite agg is to provide a way to systematically page through all results. Creating the flags in your query is best done with CTEs using a separate section for each of your module flags so you don’t. Change the aggregation of a measure in View. However, it gives me following error: "Cannot blend the secondary data source because one or more fields use an unsupported aggregation" Is there any workaround for this? Will I have to change the calculated fields? Best regards2. ) I need to revisit my understanding of the limitations here! Cannot blend the secondary data source because one or more fields use an unsupported aggregation. teacher) teacher_id,. For example, blend in the count of countries from. Unsupported aggregation type. To learn more about the Document type, see Documents. I get error: “Cannot blend the secondary data source because one or more fields use an unsupported aggregation. On this page you'll find information regarding errors that you might encounter when using our aggregation, enrichment, and payment initiation API, and how to solve them. Click on the different cookie categories to find out more about each category and. Hi Folks, I am trying to solve a typical requirement (at least for me ). How should I got about with this? Thank you. That is, an aggregate operates using a state value that is updated as each successive input row is processed. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. student) student_id, (SELECT MIN(b. Note you'll need the KM Date field on the Detail shelf. ×Sorry to interrupt. Connect and share knowledge within a single location that is structured and easy to search. That's why you can't do COUNTD on a secondary blended data source. SimpleAggregateFunction(name, typesofarguments…) data type stores current value of the aggregate function, and does not store its full state as AggregateFunction does. Hello. In . You can choose whether functional and advertising cookies apply. Hi All, I am an new user of tableau and have some issue with union join or blending ( I have being trying all of them without getting the end result I was looking for) Hereafter iThe text was updated successfully, but these errors were encountered:Hi all, I am new to Tableau and do not have very good knowledge of using it and calculations etc. I've attached a super quick example using 10. Click on the different cookie categories to find out more about each category and to change the default settings. filter. Aggregated values are computed by aggregating the elements of the expression rather than the result. It is now possible in Amazon QuickSight. if a host has 2 interfaces ports ( A & B ) connected to switch A on port 1 & port 2. You use the aggregation type to control how a key figure or. Step 4: Aggregation Dimensions in Tableau. 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".