"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 regards. I will write more details if I can locate specifics but I remember being very relieved that it worked. ” Causes and Workarounds for a Blending Limitation Errors 1. It can be misunderstood, but, when using a data blend correctly, it is an efficient way to merge data sources in Tableau. In the below screenshot the error was observed at. A value greater than 0 treats a grade item's grades as extra credit during aggregation. unknown. See Join Your Data for more information. You can't use a measure when it's configured to use an unsupported aggregation type. This. Can someone explain why you can't use a CountD from a blended datasource. 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. This aggregation is unsupported: Quarter . If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the. @Filip: No, the question was "generalize this" and not "generalize operations like this". Norbert, I'm baffled. Aggregation is computed as an average of the values in the result set for this object. This is a bug and support for IntervalValueCount should be added. 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". What I'd really like to do though is define. Hi. unsupported aggregation" | Tableau Software. The string value must be a base 10 integer (e. The current aggregation appears as part of the measure's name in the view. Aggregation is computed as an average of the values in the result set for this object. unsupported alert type – all alert type names are in camelCase – check spelling and capitalization for all alert parameters; unsupported aggregation parameters – see the You can have other aggregation on a parallel level of top_hit but you cannot have any sub_aggregation below top_hit. CSS ErrorNon-aggregate measures do not perform any aggregation and thus will not perform a double or nested aggregation. Query formulas. I want Active Resistance (the first Textual Answer) to appear to the left of the Passive Resistance column, even. Aggregation is not supported for this object. Maven coordinatesOne solution is to count unique users on client side using the composite aggregation. Teams. " For more information on this aggregation method, please see the following link for further support. For example, here are the. Local variables declared inside curly braces are allowed. 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. category = c. 2 Vivado Implementation - Logic Opt not auto-inserting BUFGs on unbuffered cmt CLKOUTx outputs. In the Data page, go to the Data Diagram and locate the datasets to blend. 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. But when i run the query i get unsupported aggregation type [multi_terms] How can i get SQL DISTINCT Pair of Values in Elasticsearch. Multiple instances of same dimension. Please refer to the above link for usage and configuration details. Some examples include: session cookies needed to transmit the website, authentication cookies, and security cookies. I’ve found a couple examples in the forums. 3 and I have created aggregates AGG for fields from data extract and excel file. Parameters: funcfunction, str, list, dict or None. cast. It shows the next message: "Cannot blend the secondary data source because one or more fields use an unsupported aggregation". When creating a calculation, one of the following errors might occur: "Cannot mix aggregate and non-aggregate arguments with this function. 0 using the C# MongoDB. Step 3: Changing the Default Measures for Aggregation in Tableau. 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. The reason will be displayed to describe this comment to others. Official drivers compatible with MongoDB version 6. getType() + "]"); Copy link Member Author. i. The code is not aware of such values and throws an unsupported exception. NET/C# Driver automatically translates LINQ queries into aggregation operations. Every measure has a default aggregation which is. Blending with CountD and LODs. However, transform requires at least 1 aggregation, the simplest one in this case is e. The data source with the KMs is the primary source. In contrast to GROUP BY aggregates, OVER aggregates do not reduce the number of result rows to a single row for every group. I've tried that in the past, and I was always blocked by the unsupported aggregation message. During the operation, map-reduce takes the following locks:Exception indicating an unsupported type was used for an aggregation. PDF - Complete Book (10. formula one layer above to div the amount. 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. Upvote Upvoted Remove Upvote Reply 1 upvote. AnalysisException: Correlated scalar subquery 'scalarsubquery (adr. According to the documentation, Amazon S3 Select supports AVG, COUNT, MAX, MIN, and SUM. If your are trying to find the minimum of your [Date] field by your [Author] field, you might want to construct a LOD calculation to find first date, by author like so: //Creates calculated field for [First Date by author] {FIXED [Author] : MIN ( [Date])} You also have asked about 'double aggregating'. 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. CSS ErrorAn old, now unsupported, aggregation strategy provided here only for backward compatibility with old activities. Glad that worked out for you Puneeth. Hi Renad, I've poked around a bit, and this is not something you can do with data blending. 3 and I have created aggregates AGG for fields from data extract and excel file. Unsupported Aggregation, Quick Table Calc Sets, and Filters from Secondary Data blends?. I created a machine learning job which uses two metrics as detectors defined as aggregations of fields in my index and everything was working great (Job_0, Datafeed_0 code below). 5. Sum, average, and median are common aggregations; for a complete list, see List of Predefined Aggregations in Tableau. [OIL DATE]) THEN MIN ( [KMs]) END. Expand Post. How to convert number to string using painless script and visualize it. 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. $convert with target type string (aka $toString) should accept all supported bson types. For more information on exception aggregations, refer to Disaggregation of Values During Data Entry. You may choose to manage your own preferences. There are non-additive aggregates from a multi-connection data source with an active connection Temporary tables are not supported by multi-connection data sources that use active connections. I've created the first chart with no problem, but I. ×Sorry to interrupt. 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. LINQ allows you to construct queries against strongly typed collections of objects by using language keywords and operators. I thought the problems with Median and CountD being unsupported by DB2 blending were over as of version 9 (i am using. For example, non-additive aggregations like COUNTD (count distinct) don’t work unless the blending fields are in the view. Try one of the following options, as appropriate for your workbook: It may be possible to cross database join instead of blending. Simplify ETL using Hevo’s No-code Data Pipeline. 55135 - Vivado Synthesis - Unsupported SystemVerilog Constructs. Official drivers compatible with MongoDB version 6. There are a few DataFrame/Dataset operations that are not. The date aggregation operators enable you to extract different parts of a given date or a timestamp. (n = 8), and unsupported (n = 14). Tableau can't mix these two types. hello. Applications using explicit Queryable Encryption may use this page. Aggregated values are computed by aggregating the elements of the expression rather than the result. You may choose to manage your own preferences. 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. Some examples include: cookies used to. Please also note that. My goal is to create a MONTHLY count of applications by ACADEMIC YEAR, SCHOOL CODE, and GRADE. The current aggregation appears as part of the measure's name in the view. We have a calculated filed where an aggregation (COUNTD) is done on a filed of secondary data source. The following commands do not require automatic encryption. movies` a INNER JOIN `<snip>. Elasticsearch Version 8. Jun 1, 2021 at 9:05. Someone in the Community told me the following: "MAX isn't supported in. Currently windowed aggregations cannot be combined in the same SELECT statement with GROUP BY, HAVING, or any. If you need to use an unsupported operation in an aggregation, you must define the entire expression using the BSON Document type. 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) by. Amazon DocumentDB is compatible with the MongoDB 3. For example, you would not be able to use a measure with the expression <<root. – Ripul. Q&A for work. Add a comment | Your Answer Thanks for contributing an answer to Stack Overflow! Please be sure to answer the question. Atlas Build on a developer data platform Database Deploy a multi-cloud database Search Deliver engaging search experiences Vector Search (Preview) Design intelligent apps with GenAI Stream Processing (Preview) Unify data in motion and data at restPossible 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. ProductionDate)' is neither present in the group by, nor in an aggregate function. This aggregation is unsupported: Year . AnalysisException: select list expression not produced by aggregation output (missing from GROUP BY clause?) 4. hello. It is not possible to combine the secondary data source because one or more fields use an unsupported aggregate. . This section describes the summary, or aggregation, functions that are available in IBM® Cognos® Analytics - Reporting. Unfortunately, I must use AWS DocumentDB as the production database, which claims to be compatible with MongoDB,. 2. The current aggregation appear as a part of the measures name in the view. This is a quite simple workaround: //Main field which is to be averaged is been default aggregated as sum @DefaultAggregation: #SUM NetDaysGranted, //Count field sum as aggregation @DefaultAggregation: #SUM 1 as Count, by counting the "positions" and use @AnalyticsDetails. Loading. Ken Flerlage (Member) 5 years ago. 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. We don't get row-level data from secondary. With the release of the MongoDB Analyzer for . I did that in your example too. 2. Hey Yuri, As an FYI there are situations where COUNTD(), MEDIAN(), and PERCENTILE() (the non-additive aggregations) and LODs can work in Tableau data blends. The following query. I'm creating a calculation view in HANA, where I'm joining the PO tables, EKKO (Header), EKPO (Item) and EKET (Scheduled Lines). Upvote Upvoted Remove Upvote Reply. The aggregation is all on primary source data. FIXED requires that you have row-level access to the rows in the secondary source. 5. 1 Unable to use aggregate function in MongoDB. The manual process is: Read the data into a text editor. The . We use three kinds of cookies on our websites: required, functional, and advertising. 1. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. 1. I've tried that in the past, and I was always blocked by the unsupported aggregation message. I'm using a cube data source as my primary and am attempting to blend with an Excel sheet. We should add test cases for the scripted fields we currently support to make sure we maintain support. 6. Having said this and following the discussion comments being posted by @Timo Rietveld and @Martin Weitzmann I assume that planning to visualize data in Google Data Studio and performing some aggregation functions it would probably required to flatten the data into the simple format using UNNEST operator achieving the best result. Unsupported aggregation: The following aggregations cannot be inverted: Some aggregation types do not support data entry. 6, 4. Log In to Answer. Hi Judy, Could you try 'swapping' the datasources, so the one with the [Customer_Code] would become your Primary? You could do it just for one view,cannot blend secondary data source because one or more fields use an unsupported aggregation beacuse of LOD. contains a reference to at least one data item that has the Summary aggregation property set to a value other than None If the underlying data source is relational and if the data item expression contains no summary functions and a reference to at least one fact that has the Regular Aggregate property set to a value other than Unsupported. automatic. here is the link to Github issue. Since the mongod cannot generate encrypted fields, the resulting timestamp would be. From my primary data source I have a dimension in columns say 'Customer Segment'. Connect and share knowledge within a single location that is structured and easy to search. ver <> 0 ) The key is that the correlation clause is using a. Move the aggregation so the calculation is aggregated. This aggregation is unsupported: Hour . data,c. " message. Etcd v3 component, URI syntax: etcd3:path. 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 have an LOD expression that works fine when the data source is the primary, but when I switch it to a secondary data source and then add the LOD expression to a view I get the annoying, "Unsupported aggregation" issue. All the three main measures were exposed in the bottom of the query but there is an extra metric based on an average aggregation behavior, the query formula will use the weight of luggage as measure and apply the aggregation to calculate the average during the run-time. I tried using Excel as the primary and I kept getting errors when I tried to add the cube. For example: My row text value is " [Custom Product] [Product 1] [Product 3]". LOD expressions are taken from a secondary source “Cannot blend the secondary data source because one or more fields use an unsupported aggregation. But when I try pulling it on to "Marks", it shows "Can't blend secondary data source because one or more use an unsupported aggregation". Pipeline aggregations that take input from other aggregations instead of. The only tables allowed to use in a FROM. Blending provides a quick and simple way to bring information from multiple data sources into a view. Returns the numerical value of the string as an integer. The Queryable Encryption Public Preview, released in version 6. At first, I made a lookup operator to link between the two collections, then I wanted to group the. Expand Post. Does the EXCLUDE function work in this case? Without the SUM/ATTR out of the EXCLUDE the calculation is not working and it asks for an aggregation. @V1NAY8 For some scripts we probably can't aggregate (like you've found with text). (Ditto the FIXED countD. As an alternative I've tried to use Exception. pos_trn) (default) . An aggregate_metric_double field is an object containing one or more of the following metric sub-fields: min, max, sum, and value_count. Tableau will throw an error: “Cannot blend the secondary data source because one or more fields use an unsupported aggregation. 0, and 5. This aggregation is unsupported: Quarter . M". currently this doing everything over the global total and count distinct of IDs. Functional cookies enhance functions, performance, and services on the website. Let's say for example that you wanted. In the vSphere Web Client, navigate to the Distributed Switch. Provide details and share your research!The unsupported aggregation happens when your aggregate requires row-level visibility to the secondary data source. ) I need to revisit my understanding of the limitations here! unsupported csv filters – spendChange alerts accept filter as comma-separated values; other alert types do not. I keep getting an Unsupported Aggregation error for anything but "terms". 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. Data blending is a way to combine data in Tableau. non-currency measure. It’s common to store strings in documents such as first name, last name, or location. NoDays >> * <<root. But a filter or range gives org. 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. The examples in this guide use the restaurants collection in the sample_restaurants database provided in the Atlas sample datasets . 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. This page documents the specific commands, query operators, update operators, aggregation stages, and aggregation expressions supported by MongoDB version 6. When there is unsupported aggregated measure using WINDOWS Functions, COUNTD,LODs etc. Supported Aggregation Stages. You can use the variable REMOVE in aggregation expressions to conditionally suppress a field. Hi Justin, Thanks for your quick reply. Add it to group by using ordinal position or wrap it in first () (or first_value) if you don't care which value you get. 💥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. The Dept Target field is producing an integer (A). THEN add this total to the SUM of the projected_users from today's date through month X. Teams. Reload to refresh your session. This happens only when the data sources are impala. really need to see your twbx file to be of further help. Cut out the three explanatory lines at the top (can be done with regex) Run a regex replace on the file (I’ve used . 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. 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. The aggregation framework collects data based on the documents that match a search request which helps in building summaries of the data. Teams. Aggregate using one or more operations over the specified axis. Non-additive aggregates from the secondary data source(All Number functions, except for MAX and MIN, are non-additive. Expand Post. I believe I first learned. The workaround for this is that if you have to use one of the non-additive aggregates, use DB1 blending, i. the SELECT statement has aggregates WHERE gpa in (SELECT max(gpa). Make sure that you are blending on dimensions present in the view or on all of the. Connect and share knowledge within a single location that is structured and easy to search. 4. Summary:. Drill down to the leaf level to enter data. Most used methods <init> Popular in Java. 3. Loading. Learn more about TeamsThe aggregation rule is determined automatically at run time. This aggregation provides a way to stream all buckets of a specific aggregation, similar to what scroll does for documents. 9 version and publish them as new (remove previous one). 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). Right click the vDS, then Settings > Export configuration to back up the existing configuration of the vDS. ) A LOD calc is also trying to do stuff at the row level. Level of Detail Expression is Finer Than View Level of Detail. 0 and later. Jonathan. Choose a reason for hiding this comment. Dealing with them was not a walk in the park. Issue. movieId GROUP BY a. Hevo is a No-code Data Pipeline. 1 MongoDB Aggregate shows no result. 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. dataCategory: #CUBE. @Point Partner BI Team (Member) hi there,. Consider a books collection with the following document: {"_id": 1, title. 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. 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. Error "Cannot blend the. To achieve this you need to add Calculated Field to an Analysis ( as described here ). average. 5 and have 2 data sources RPT and AD in the workbook which are currently extracts. Q&A for work. Mean of gradesWe have an enterprise data source that is an SSAS Tabular model. 0. 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. Data encrypted using the Public Preview is incompatible with the feature release. ElasticsearchException: [es/search] failed: [x_content_parse_exception] [1:44] [composite] unknown field [name] Here is my setup. Wherever possible, the value of calculated is used, then sum where necessary, followed by unsupported. The PipelineDefinitionBuilder class provides a type-safe interface for defining an aggregation pipeline. 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,. 0. How to calculate Delta value. What’s inside. Aggregate functions in S3 Select. average. We are allowed to reference the derived table totals1 in the WHERE clause, as you already do but here we are actually referencing a column, not the table as a whole:. It looks like these solutions are coming from 2013. Use aggregation instead. EKPO-EBELN = EKET-EBELN. 3 and I have created aggregates AGG for fields from data extract and excel file. A value greater than 0 treats a grade item's grades as extra credit during aggregation. Try loading pyspark functions with an alias instead:. However if I try to filter those fields, I seem to lose the ability. 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. Cut out the three explanatory lines at the top (can be done with regex) Run a regex replace on the file (I’ve used . value_count on one of the group by fields. An aggregate_metric_double field is an object containing one or more of the following metric sub-fields: min, max, sum, and value_count. I am getting Cannot blend secondary data source because one or more fields used an unsupported aggregation. Local variables declared inside curly braces are allowed. The . If you have selected the modeling properties Activate Data and Write Change Log, you can choose from the following. Drill down to the leaf level to enter data. E make table 2 the primary. When you blend, you can only have aggregate access to the rows in the secondary source. For example, see Text Search in the Aggregation Pipeline. Mean of grades (with extra credits): Unsupported aggregation provided here only for backward compatibility with old activities. The aggregation rule is determined automatically at run time. With DB2 blending and secondary LODs there are three levels of detail involved: the LOD expression, the linking dimensions, and the vizLOD and I don't think Tableau is at this time able to walk through all those levels to figure out exactly what needs what aggregation to get accurate results; so instead it throws up a red pill and the. In other words: Column-references must either be part of the grouping keys, or they must be part of the aggregation. This aggregation is unsupported: Month . It is not supported by ElasticSearch. Try to use registered UserDefinedFunction to call your aggregation over window. For more information on aggregation types, refer to Disaggregation of Values During Data Entry. Trying a different aggregation on DAY([Endtimestamp])? Trying to COUNTD a different field? This won't fix the problem but will help pinpoint which part of the expression Tableau objects to. Drill down to the leaf level to enter data. When projecting or adding/resetting a field within an embedded document, you can either use dot notation, as in. image 959×146 4. Since there were no actual relation between the tables, this is the way I tried assigning the relationship:In a grouped aggregation, aggregate values (e. It can be misunderstood, but, when using a data blend correctly, it is an efficient way to merge data sources in Tableau. This aggregation method is not to be used. 2. Currently, using the transactional side, the retention rate calc is (SUM (Headcount) from Employee side - SUM. Characteristics such as optical and catalytic activity may be lost if the dispersion of unsupported Ni NPs is not adequately modulated. Required cookies are necessary for basic website functionality. Aggregation is not supported for this object. Filter each of the data sources independently on the more granular dimensions. You can use aggregations in the analysis level calculated field. An introduction to windowed aggregations. And that column is an aggregation column. Time-interval with identical time points. A COUNTD of Order ID should be all I need to show this data but it always results in a "Cannot blend the secondary data source because one or more of the fields use an unsupported aggregation" What can I do to get around this?Aggregate metric field type. If the user select May 2018. 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. Don Wise (Member) 3 years ago. As tableau automatically aggregates its value using predefined aggregate functions. In other words: Column-references must either be part of the grouping keys, or they must be part of the aggregation. 0 or later using Automatic Encryption with Queryable Encryption parse read and write operations for operators or expressions that do not support BinData values or that have abnormal behavior when issued against BinData values. Define spend budgets and alert on budget overruns. Unsupported aggregation: The following aggregations cannot be inverted: <aggregations> Unsupported exception aggregation: The following exception aggregations cannot be inverted: <exception aggregations> Some exception aggregation types do not support data entry. When I run the above code, I receive the following error: Validation Failed: 1: Unsupported aggregation type [nested]. Aggregation expressions: The values of multiple rows are grouped together to form a single value based on a mathematical function. Use of meta-aggregation to synthesize the findings from qualitative studies offers an especially useful approach as its goal is to aggregate information on a topic to provide practical recommendations for practice, future research, and. How should I got about with this? Thank you. This aggregation is unsupported: Median . Wherever possible, the value of calculated is used, then sum. g. Ditto: { FIXED [Patient ID] : COUNTD([Patient ID]) } Yet there it is in your workbook, very happy and functional. Description. Supported functions. g. I get "unsupported aggregation type [multi_terms]" @Val – Orkun. e. 1 is the employee side of things that tracks their current leader, country, career level etc, and the other side which is transactional which tracks whether they have terminated or not. When I calculate the average of a measure and use the filter, it works perfectly fine. To understand the issues related to this log, read the explanation below about the following Elasticsearch concepts: plugin. Unsupported exception aggregation: The following exception aggregations cannot be inverted: <exception aggregations> Some exception aggregation types do not support data entry. LOD will not work if it is from the secondary datasource. Unsupported Commands. Returns expression of the current instance cast to the type specified. Another table is a a table that contains key fields such as date, region, location and hardware id (dimension). Until SRM v3. column1. This aggregation is unsupported: Second . elasticsearch. 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. This field works but when I want to add in my Fianl Dashboard I have this message "Cannot blend the secondary data source because one or more fields use an unsupported aggregation" Moreover my first and secondart data sources are linked by the "Sales ID", but this field is not displayed in the final Dashboard. . NET dialect) to turn each line into 31 documents. CallTime Avg (internal)>> because CallTime Avg (internal) is interpreted as being. 9 version and publish them as new (remove previous. I did that in your example too. An old, now unsupported aggregation strategy provided here only for backward compatibility with old activities. Add the ’ [‘ open-square-brackets to the beginning and ‘]’ close-square-brackets to the end. Sub-path [interactions-c] points to non single-bucket aggregation" } } ] }, "status" : 500 } this is my index mapping:I created a calculated field that checks to see if Subsidized Price is not null, and added that to the filters shelf, but doing so turns my median calculation into an unsupported aggregation. I couldn’t get anything to work. Hi. 61042 - 2014. If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the. James--I believe your BLEND is the problem: you're not telling Tableau how to slice & dice the tables together, and including those fields within the view, so Tableau can't tell which Upper and Lower Limits to apply to the data to calculate them and you're getting unsupported aggregation errors. Currently, we have 2 different data sources.