The composite buckets are built from the combinations of the values. Change the C# code in the Program. And put both views on a dashboard. I've tried that in the past, and I was always blocked by the unsupported aggregation message. To resolve this issue, you should first verify the spelling and case of the aggregation name. CallTime Avg (internal)>> because CallTime Avg (internal) is interpreted as being. addShardToZone () applyOps. date, t. Apache, Apache Spark, Spark, and the Spark logo are trademarks of the Apache Software Foundation. step 1 : I do teaming for interface A & B, enable LACP on virtual teaming interface. Count Distinct in Secondary Data Source - "cannot blend secondary data source because one or more fields use an unsupported aggregation" Hi! I'm trying to blend 2 data sources. Click on the different cookie categories to find out more about each category and. 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. UNSUPPORTED_TABLE_ARGUMENTWindowed Aggregations. We are blending two data sources. Hi All, I have blended primary and secondary data sources. Note you'll need the KM Date field on the Detail shelf. Click anywhere on the Field wells to expand them. Click ounsupported_in_exists_subquery IN/EXISTS predicate subqueries can only be used in filters, joins, aggregations, window functions, projections, and UPDATE/MERGE/DELETE commands`<treeNode>`. If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the. Use a Join instead of Blending: If blending is not necessary for your analysis, you can try joining the data sources instead. Amount) as Total from Company left outer Orders on Orders. Use expressions to define the values that are sent from Tableau to the analytics model. With LAC-A functions, you can specify at what level to group the computation. t Link Aggregation. QuRouter. Had a chance to test it, and it seems to work in both py2 and py3. Documentation on relationship: Relate Your Data - Tableau. Expand Post. CallTime Avg (internal)>> because CallTime Avg (internal) is interpreted as being. ×Sorry to interrupt. Data blending has some limitations regarding non-additive aggregates such as COUNTD, MEDIAN, and RAWSQLAGG. Q&A for work. teacher) teacher_id,. Just aggregates (like SUM, MIN, MAX. 2. If you’ve tried to show a COUNTD from a secondary before, you’ve undoubtedly seen the message stating “Cannot blend the secondary data source because one or more fields use an unsupported aggregation”. Sum, average, and median are common aggregations; for a complete list, see List of Predefined Aggregations in Tableau. 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. And now if I bring that Fixed calculation ( called as "Duration" in my worksheet. Thanks for your help . These dimensions were also used as filters in the particular sheet. SimpleAggregateFunction(name, typesofarguments…) data type stores current value of the aggregate function, and does not store its full state as AggregateFunction does. I would like to visualize number of distinct hardware. There are some data blending limitations around non-additive aggregates, such as COUNTD, MEDIAN, and RAWSQLAGG. I get the the following error: unsupported aggregate action Digging through the source code I found there is no handler for collect. Output tables contain a single row with the aggregated value. An introduction to windowed aggregations. 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. e. In the actual data I get the error: Cannot blend the secondary data source because one or more fields use an unsupported aggregation. There is now a considerable number of published reviews that claim to follow the JBI approach to meta-aggregation. Cannot blend the secondary data source because one or more fields use an unsupported aggregation" when Data Blending Hello Everyone, I am using one data source which is a LIVE connection and I have duplicated same data source , the reason behind duplication is i want to have total of category which will be constant and it will not change even. 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. [Secondary Source Field]))}) This seems to be the only calculation that is valid. The aggregate functions array_agg, string_agg, and xmlagg, as well as similar user-defined aggregate functions, produce meaningfully different result values depending on the order of the input values. 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. However I only managed to make it work for abap cds queries (@Analytics. As tableau automatically aggregates its value using predefined aggregate functions. Non-additive aggregates are aggregate functions that produce results that cannot be aggregated along a dimension. I have two datasets; one is a shape file that contains regions and locations. Parameters: funcfunction, str, list, dict or None. Unsupported Aggregation means that the action requested at one of the sources or the act of bringing them together can not be done - in your case you have used a table calculation to determine a performance score - Table calculations are performed on the underlying table for a specific worksheet and can not be carried or transferred from one. See the Description column for details. twbx. Default aggregation for Exclude LOD is ATTR. countD requires row-level access to the data, not just aggregate access. I was now trying to use both calculations you did on a different sheet through data blending. Wherever possible, the value of calculated is used, then sum where necessary, followed by unsupported. JimI have linked 2 sources using 3 dimensions. Cannot blend the secondary data source because 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. "cannot blend the secondary data source because one or more fields use an unsupported aggregation" Attached is the workbook that could provide more clarity on my question. 9 KB. 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. An old, now unsupported, aggregation strategy is provided here only for backward compatibility with old activities. Click on the different cookie categories to find out more about each category and to change the default settings. Currency measure vs. Dimension plus instance of that dimension. For example, see Text Search in the Aggregation Pipeline. 2. name from t1 t inner join category c on t. 38. Unsupported SQL features. An expression has a finer level of detail than the view when it references a superset of the dimensions in the view. Build the future of fintech in Latin America by connecting your. I'd like to always use D1 except when it is NULL and then I'd like to use D2. I am trying to sync the axis using a reference line. For example, there are aggregates to compute the count, sum, avg (average), max (maximum) and min (minimum) over a set. elasticsearch. And I want to add one of the field from secondary dataset to be in the filter. Non-aggregate measures — such as type: yesno and type: number — are the only measures that can reference other measures or aggregations. 5 and have 2 data sources RPT and AD in the workbook which are currently extracts. If you then need to flatten the response for use in your visualisation this flattening will need to be done client side. It doesn’t understand the use of LIMIT 1: delete it and wrap your sub queries in an aggregate function - MIN() looks like a good choice - adding the obligatory GROUP BY SELECT (SELECT MIN(b. Loading. For more information, see Troubleshoot. 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. You can choose whether functional and advertising cookies apply. You can choose whether functional and advertising cookies apply. I know that count distinct can not be used in the data blending. ) to such a degree that you need table calcs to re-aggregate to get to the desired granularity of the display. 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. Norbert, I'm baffled. 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". Tip. I receive this error: "Cannot blend the data source because one or more fields uses an unsupported aggregation". CSS ErrorI'd like to always use D1 except when it is NULL and then I'd like to use D2. This happens only when the data sources are impala. You can choose whether functional and advertising cookies apply. In other words, they include data more recent than your last materialized bucket. Sorting by a tuple with 2 values is much slower. . 60 shows aggregate functions typically used in statistical analysis. Detailed procedure: Open the vSphere Web client. additional request properties set programmatically. This includes _time. (It is a field that contains account names (company) in the sample data. Hi, Thanks for your reply. 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. I have this query in azure, what the script is trying to do is to get a date from current stamp. For example, if the aggregate rule for QI_a is set to sum, and the. I have 2 filters (BU ISNull and CORPID) applied from secondary data source. The expression <expr> does not support more than one source. Try one of the following options, as appropriate for your workbook: It may be possible to cross database join instead of blending. We use three kinds of cookies on our websites: required, functional, and advertising. Let's say for example that you wanted. 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. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. Please use the. Query Expressions. CSS ErrorIf I create my calculated field without using an aggregation with {Profit}, QuickSight doesn’t know from which row to get the value. Hello Jim, Thank You for your reply. 8 for information about use of aggregate functions as window functions. Make sure that you are blending on dimensions present in the view or on all of the. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. Now select a data source you want to connect to, and click Next. Claims Paid for Treatment and Testing. CSS ErrorDeveloper Data Platform. To specify collation when you query documents in the MongoDB Atlas UI, see Specify Collation. Modified 2 years, 4 months ago. cs file to look like the following: Code Snippet In the above LINQ query, we're doing a series of steps, just like stages in an aggregation pipeline. 7. Cannot blend the secondary data source because one or more fields use an unsupported aggregation . ORDER BY clause) but you should expect the order not to match. I read that this is not possible. We use three kinds of cookies on our websites: required, functional, and advertising. Unsupported Aggregation while implementing filters from secondary datasource. There are two types of calculated fields: on a data set level and on on analysis level. Right-click the field you are aggregating and select Properties. For more information, see Alias Field Values Using Data Blending. You can choose whether functional and. Solution using relationship:Aggregates functions we use only in SELECT block. 7. sh. Yup. 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 . Cannot blend the secondary data source because one or more fields use an unsupported aggregation. For example, you would not be able to use a measure with the expression <<root. 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 Customers Served])}We use three kinds of cookies on our websites: required, functional, and advertising. really need to see your twbx file to be of further help. 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. 4 and Superstore. NET dialect) to turn each line into 31 documents. Windowed aggregations partition the results from a SQL query into groups in order to perform calculations across adjacent rows of the query result. ) 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. ) Two approaches to consider: 1) Make your Stores data source your primary data source. Unlike the other multi-bucket aggregations, you can use the composite aggregation to paginate all buckets from a multi-level aggregation efficiently. Non-additive aggregates are aggregate functions that produce results that cannot be aggregated along a dimension. Step 3: Create assignment or drag & drop key figure in target. Usage In Sort© Databricks 2023. 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. Step 4: Aggregation Dimensions in Tableau. 4, MongoDB supports faceted classification by using the Aggregation Framework. Wrap the Total KMs formula in: IF FIRST ()=0 THEN [Total KMs] END. If a query asks for sales figures for Coke and Pepsi, the data should be returned from the aggregate table. category = c. Using non-aggregate measures . The current aggregation appears as part of the measure's name in the view. person = a. How to do mongo aggregation. e. Fácil para crear diseños personalizados de tipo de papel no compatible. 1. You can choose whether functional and advertising cookies apply. 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. The actual tables are constantly updated with 600+ locations and sales information that comes in daily: Table 1 (Primary): Location. This aggregation provides a way to stream all buckets of a specific aggregation, similar to what scroll does for documents. If you have not selected any modeling properties, you are not offered any aggregation types at all. InternalFilter as an unsupported. Share. Rather than return incorrect results, Tableau turns the pill red, greys out the view, and generates the unsupported aggregation message. really need to see your twbx file to be of further help. Click on the different cookie categories to find out more about each category and to change the default settings. Most of the KPI's are straight forward to aggregate and compare but AVG FLEET requires the use of LOD expressions. Refresh. Click on the different cookie categories to find out more about each category and to change the default settings. I am trying to create a waffle chart. The Regular Aggregate property. Try to. If if this is the case, you could try creating a calculation for DAY([Endtimestamp]) in both the primary and secondary data sources, and adding it to the blend. We use three kinds of cookies on our websites: required, functional, and advertising. Filter each of the data sources independently on the more granular dimensions. For example am having column called "Name" in my first data source, in second data sources am having column called "F Name". 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. Golang mongodb aggregation using mongo-driver. The version I am working with 10. The PIVOT aggregate expression has to be a call of a supported aggregate function. Hadoop provides two fs interfaces - FileSystem and AbstractFileSystem. Set the table calculation to COMPUTE USING using the KM Date field. Ask Question Asked 3. QNAP’s QuRouter OS simplifies managing high-speed and high-coverage LAN/WAN. This could be due to a typo in the aggregation name or the use of an unsupported aggregation. You can choose whether functional and advertising cookies apply. node. But a filter or range gives org. Many target systems don't support it at all (e. We use three kinds of cookies on our websites: required, functional, and advertising. From the Input Recordsets pane on the left, expand the relevant Results from. To learn more about the Document type, see Documents. ×Sorry to interrupt. Upvote Upvoted Remove Upvote Reply. Some databases has a pivot function but if you are using one without that function, then you will need to use an aggregate function with a CASE expression: select lineid, max (case when question ='Height' then answer else '' end) Height, max (case when question ='Outside Color' then answer else '' end) [Outside Color] from yourtable group. When you import metadata, Framework Manager assigns values to the Usage and Regular Aggregate properties for query items and measures depending on the type of object that the query item or measure is in. We don't get row-level data from secondary sources on a blend. ×Enable management functions such as link aggregation, VLAN, and RSTP, to take care of your network topology with ease. Norbert, I'm baffled. Data blending has some limitations regarding non-additive aggregates such as COUNTD, MEDIAN, and. You can use the variable REMOVE in aggregation expressions to conditionally suppress a field. Wrap the Total KMs formula in: IF FIRST ()=0 THEN [Total KMs] END. 3 and I have created aggregates AGG for fields from data extract and excel file. You can choose whether functional and advertising cookies apply. "-5", "123456") and fall within the minimum and maximum value for an integer. Bucket aggregations that group documents into buckets, also called bins, based on field values, ranges, or other criteria. Hi All! I would like to ask for your help, I do have two data sources: BI Cube (primary source) & Excel file (secondary) BI Cube Data 1 pc. addShard. (Ditto the FIXED countD. If there is another aggregation type such as AGG_AVG being used, change it to one of the supported aggregation listed. The primary data source is just to filter for the invoices I want to look at. using select. Create a calculated field, with some business logic, to choose which to show in the case of multiple. if a host has 2 interfaces ports ( A & B ) connected to switch A on port 1 & port 2. unsupported aggregation. So, it seems the two solutions right now are: Create two jobs that have datafeeds that search for the appropriate fields (probably the most correct option) Partition across my_filter_field and have both use the same detectors. Choose the field well containing the field that you want to apply an aggregate function to. I use {Fixed [Owning Location Code], [Location Code], [Vehicle Group], month([MB Date]) :Avg([Avg Fleet])} to get the Avg. Consider a books collection with the following document: {"_id": 1,In aggregation, following a stage that outputs a field with the text score value, you can specify a query condition or operate on the field in subsequent stages. C. When you run certain metric aggregations on an aggregate_metric_double field, the aggregation uses the related sub-field’s values. ERROR 2239: At most one path number can be entered. Instead of blending multiple data sources, create one data source that joins all of the data using either physical or logical joins. If it’s not supported, you may need to upgrade your. Another table is a a table that contains key fields such as date, region, location and hardware id (dimension). Option 2: Rewrite your SELECT without a Correlated Subquery. Blending provides a quick and simple way to bring information from multiple data sources into a view. The limitation on mixing data often occurs with non-additive aggregates such as MEDIAN or COUNTD. t Link Aggregation. We are blending two data sources. You could also use Tableau Prep to pre-aggregate each set of data so they have the same level of detail, then join them together. step 2 : network person on. The strange thing is running the query (the one that the Java API gives on a to string) through the REST endpoint works fine. 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:. really need to see your twbx file to be of further help. Please see if it helps , here it says that problem is with COUNT & they have provided one alternative way as well . Tommy Sims (Member) Set the table calculation to COMPUTE USING using the KM Date field. Good morning @Fred Yu (Customer) . but no collectToAggregationThe SQL Language. 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 issue was that the bucket sensor that I had previously defined in my telegraf. The driver does not provide methods for all aggregation pipeline operators in the Query API. In aggregation, following a stage that outputs a field with the text score value, you can specify a query condition or operate on the field in subsequent stages. You can use aggregations in the analysis level calculated field. You can't directly use concat function with window function. A value greater than 0 treats a grade item's grades as extra credit during aggregation. In . Jim. id) FROM table_b b WHERE b. 2. Find centralized, trusted content and collaborate around the technologies you use most. 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,. Hi all. However, when the linking dimension is not in the view, non-additive aWhen you add a measure to the view, Tableau automatically aggregates its values. 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. search. an unsupported aggregation. Thanks for contributing an answer to Stack Overflow! Please be sure to answer the question. You'll always want to return the same type, so that in itself could be an issue. ×Sorry to interrupt. Best, Paul. response “Cannot blend the secondary datasource because one or more field use . Click on the different cookie categories to find out more about each category and to change the default settings. If I cant go the above way then is there a possibility to do the duration calculation using table calculations or some other way. Asking for help, clarification, or responding to other answers. Example(cannot blend the secondary data source because one or more fields use an unsupported aggregation) If i select without distinct, it's ok (but not what I want. conf and creating a NEW bucket with a new API key in Influx. Right-click the field you are aggregating and select Properties. 0. Discussions; Teams. Function to use for aggregating the data. There are two ways of dealing in a data module with unsupported data types. CSS ErrorLoading. Cyb3rWard0g changed the title Elastalert Integration - Elastalert Integration - Unsupported feature 'near' aggregation operator not yet implemented Dec 9, 2018. data,c. The unsupported aggregation happens when your aggregate requires row-level visibility to the secondary data source. Had a chance to test it, and it seems to work in both py2 and py3. In order to create the waffle chart I am blending it with another datasource using the calculated field defined as [Week 5 (Week5Bond)]. When I am joining the two data sources I wanted to use "F Name" column with "Name" column. CSS ErrorLoading. non-currency measure. There are corresponding countToAggregation , countDistinctToAggregation etc. 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]. New in version 5. Aggregate using one or more operations over the specified axis. Each output table from an aggregate function will: Contain a single record. When projecting or adding/resetting a field within an embedded document, you can either use dot notation, as in. I receive this error: "Cannot blend the data source because one or more fields uses an unsupported aggregation". (See Section 3. See Array Indexes are Unsupported. Most of the time, we work with FileSystem and use configuration options like fs. This is a new complexity in Tableau v8: In v7 and earlier, to blend we had to have the linked dimensions in the view, i. Right-click OldPasswordAllowedPeriod, and then select Modify . 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. Tableau allows changing the aggregation of a field for specific use in the worksheet. pindahan='no' and tahun. Fleet for one year. bucket. I have a User model and I want to perform generic aggregation. Can anybody please help me with a solution. ELSE D1. Filter each of the data sources independently on the more granular dimensions. 2022, 15: 41: 37; This is generated by the following Code Snippet:Add GROUP BY or turn it into the window functions using OVER clauses. Innovate fast at scale with a unified developer experienceIn blending data source, I try to slove problem but I can't. When a user filters to find the high-level, the detail view will be filtered and you'll get it all, without having to monkey around trying to blend cubes and relational data. Real-time aggregates automatically add the most recent data when you query your continuous aggregate. B. Be sure to use aggregation functions (SUM, AVG, etc. 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 . You can specify collation for a collection or a view, an index, or specific operations that support collation. We use three kinds of cookies on our websites: required, functional, and advertising. ×Sorry to interrupt. ElasticsearchException: [es/search] failed: [x_content_parse_exception] [1:44] [composite] unknown field [name] Here is my. The Usage property identifies the intended use for the data represented by the query item Usage property. They both share a common field (State), and that is what I'm filtering on. Create an aggregation-based visualization panel edit. what I understood from my network colleague concept of LACP. I am trying to blend the same data against the other because I wanted to show Same Period last Year. unsupported aggregation. Name, Company. From the Data pane, drag a dimension field to Label on the Marks card. 3 and I have created aggregates AGG for fields from data extract and excel file. I believe this is not a problem because of the primary data source using Relationships but because data blending has some limitations regarding non-additive aggregates. We use three kinds of cookies on our websites: required, functional, and advertising. Fundamentalmente son espacios privados,. After blending, CountD works fine on primary datasource, but when I try to use CountD on secondary datasource tableau gives error: "Cannot blend secondary data source as one or more fields use an unsupported aggregation"Hi, Where Tableau v9 introduced level of detail expressions and Tableau v10 introduced cross-data source joins there are a number of use cases where we previously needed data blending that we now don’t, so the first thing I always look at is whether we really need a blend to get the desired results Also there are various cases where the non. Add GROUP BY or turn it into the window functions using OVER clauses. ” Causes and Workarounds for a Blending Limitation Errors. Data blending has some limitations regarding non-additive aggregates such as COUNTD, MEDIAN and. I am trying to . Thanks for the suggestion. Using { allowDiskUse: false } to prohibit writing temporary files out to disk when allowDiskUseByDefault is set to true. ) Two approaches to consider: 1) Make your Stores data source your primary data source. We use three kinds of cookies on our websites: required, functional, and advertising. [Secondary Source Field]))}) This seems to be the only calculation that is valid. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. . How should I got about with this? Thank you. 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. thomaspatzke commented Dec 9, 2018. 1, is the pass-through expression. NoDays >> * <<root. ×Sorry to interrupt. Aggregate the dimension to show only the MIN or MAX value. ) to aggregate the results. status='terima' and daftar. Fleet for the other year. Step 2: Build the map. Click on the different cookie categories to find out more about each category and to change the default settings. Cannot Blend Secondary Data Source - Unsupported Aggregation. Error "Cannot blend the secondary data source because one or more fields use an unsupported aggregation" when Data Blend… You may just be able to turn the Excel. Hi. To add aggregation to a field for a pivot table visual. Elasticsearch organizes aggregations into three categories: Metric aggregations that calculate metrics, such as a sum or average, from field values. 0. Over Aggregation # Batch Streaming OVER aggregates compute an aggregated value for every input row over a range of ordered rows. Unsupported aggregate subquery with non-equality correlated predicates. The first part is the source data. unsupported aggregation. I did that in your example too. 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. Figure out a more complicated aggregation that utilizes a multi_bucket aggregation. THEN add this total to the SUM of the projected_users from today's date through month X. 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 a number of weekly reports). First, let’s start with a simple example of a Structured Streaming query - a streaming word count. Loading. select t. aggregateWindow () uses the timeSrc and timeDst parameters to assign a time to the aggregate value. 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]. Sorting by a tuple with 2 values is much slower. When you try to do that, Tableau generates the "Cannot blend the secondary data source. I am trying to set up a composite aggregation using the ElasticsearchClient since the RestHighLevelClient is deprecated.