Thus I have this calc below . However I keep getting the following error: co. Make sure that you are blending on dimensions present in the view or on all of the. Upvote Upvoted Remove Upvote Reply. You can choose whether functional and advertising cookies apply. Fleet for the other year. With LAC-A functions, you can specify at what level to group the computation. Non-additive aggregates are aggregate functions that produce results that cannot be aggregated along a dimension. teacher) teacher_id,. Jim. Yeah not sure what's going on there either. ) The basic idea is that in addition to a normal “. 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]. Aggregated values are computed by aggregating the elements of the expression rather than the result. Expand Post. ELSE D1. on Rows, Columns, Pages, or the Marks Card. When I am joining the two data sources I wanted to use "F Name" column with "Name" column. If you perform an aggregation on a baseline column through a SQL request, the Analytics Server calculates the aggregation grain at the level based on the following rules: If there is no GROUP BY clause specified, the level of aggregation is grouped by all of the nonaggregate columns in the SELECT list. There are non-additive aggregates from a multi-connection data source with an active connection. I did that in your example too. 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. AbstractFileSystem. clients. I was now trying to use both calculations you did on a different sheet through data blending. Parameters expression : Non aggregating, non grouping expression in the SELECT list. Individual find and aggregate commands may override the allowDiskUseByDefault parameter by either: Using { allowDiskUse: true } to allow writing temporary files out to disk when allowDiskUseByDefault is set to false. Inn order to get the top 10 results you would need to use the terms aggregation with a filters sub-aggregation. See. Sometimes , it's automatically working but sometimes it says 'Unsupported Aggregation' . date, t. Right-click the field you are aggregating and select Properties. You can choose whether functional and. Share. Hello Jim, Thank You for your reply. To define a new aggregate function, one selects a data type for the state value, an. Collectives™ on Stack Overflow – Centralized & trusted content around the technologies you use the most. These stages can be broken down like the following:. 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. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. I would like to visualize number of distinct hardware. 2. Documentation on relationship: Relate Your Data - Tableau. There are two types of calculated fields: on a data set level and on on analysis level. (You need to get individual row access to evaluate DISTINCT functionality. ” Causes and Workarounds for a Blending Limitation Errors. learning module contains a number of ways to aggregate model udpates with recommended default configuration: In this tutorial, we explain the underlying motivation, how they are implemented, and provide suggestions for how to customize their configuration. 8 for information about use of aggregate functions as window functions. Loading. Got same expected results in both py2 and. 4, MongoDB supports faceted classification by using the Aggregation Framework. Loading. (This is more of a workaround) Use a viz in tooltip to show the members of the dimension instead, coming from a different worksheet. Hello. When you try to do that, Tableau generates the "Cannot blend the secondary data source. Hi all. I'll play around with it, see if I can make it work that way. . Cannot blend the secondary data source because one or more fields use an unsupported aggregation. Tested it manually by setting the load of odd GPU id’s to “Not supported” and sorting according to load. Had a chance to test it, and it seems to work in both py2 and py3. Someone in the Community told me the following: "MAX isn't supported in. step 1 : I do teaming for interface A & B, enable LACP on virtual teaming interface. Amount) as Total from Company left outer Orders on Orders. IF ISNULL(D1) THEN D2. addShard () addShardToZone. I did that in your example too. When an expression outputs a boolean value, it may be used directly in filters. If there is a GROUP BY clause specified. . Unsupported Aggregation while implementing filters from secondary datasource. Use a Join instead of Blending: If blending is not necessary for your analysis, you can try joining the data sources instead. remove the [Date Occurred] filter). You cannot convert a string value of a float or decimal or non-base 10 number (e. By using the formula DAY([Endtimestamp]), you're changing the dimensionality a little bit. It said one or more fields use an unsupported aggregation. Unsupported aggregate subquery with non-equality correlated predicates. ERROR 2230: Arguments of row IN must all be row expressions. It can be misunderstood, but, when using a data blend correctly, it is an efficient way to merge data sources in Tableau. Ce message a été modifié par : nicolas sinquin. I've tried that in the past, and I was always blocked by the unsupported aggregation message. 7. 60 shows aggregate functions typically used in statistical analysis. Outputs documents in order of nearest to farthest from a specified point. We extracted the following from Elasticsearch source code for those seeking an in-depth context :Now when I drag and drop the transaction data, everything works just fine, but if I try to use the "Add all Subtotals" option to get the AVG Transactions value for each Market then I am getting the dreaded "Cannot blend the secondary data source because one or more fields use an unsupported aggregation" on my worksheet when I change the "Total. I put a twb file. The Junos OS removes the configuration statements related to aex and sets this interface to down state. 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. I’ve created this post in order to share my workaround for bringing over a Count Distinct (COUNTD) from a secondary data source. Try loading pyspark functions with an alias instead:. 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. Click on the different cookie categories to find out more about each category and to change the default settings. First, let’s start with a simple example of a Structured Streaming query - a streaming word count. In other words, they include data more recent than your last materialized bucket. but no collectToAggregationThe SQL Language. We don't get row-level data from secondary sources on a blend. The workaround for this is that if you have to use one of the non-additive aggregates, use DB1 blending, i. really need to see your twbx file to be of further help. Loading. Hello Everyone, I am unable to sum an aggregate function. 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. 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. I receive this error: "Cannot blend the data source because one or more fields uses an unsupported aggregation". 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. Elasticsearch organizes aggregations into three categories: Metric aggregations that calculate metrics, such as a sum or average, from field values. Norbert, I'm baffled. Innovate fast at scale with a unified developer experienceIn blending data source, I try to slove problem but I can't. id) FROM table_b b WHERE b. I have changed the code with your suggested method and now getting this output: "ERROR : Unsupported document type for unmarshalling: []bson. When double-clicked, it is automatically added to Detail on the Marks card and a map view is created. When using the function, the data types and order of the expressions must match that of the input arguments. Click oUNSUPPORTED_IN_EXISTS_SUBQUERY. You can choose whether functional and advertising cookies apply. Chicken + Choice of DrinkBurger + Choice of DrinkSpaghetti + Choice of Drink . really need to see your twbx file to be of further help. From the Input Recordsets pane on the left, expand the relevant Results from. ×Sorry to interrupt. Aggregate Functions #. api. 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. Use expressions to define the values that are sent from Tableau to the analytics model. ) Two approaches to consider: 1) Make your Stores data source your primary data source. 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. 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. The driver does not provide methods for all aggregation pipeline operators in the Query API. NoDays >> * <<root. And I use Join data source, after divide measures / row duplicate. [Secondary Source Field]))}) This seems to be the only calculation that is valid. functions as psf. I had a query w. Detailed procedure: Open the vSphere Web client. This aggregation provides a way to stream all buckets of a specific aggregation, similar to what scroll does for documents. (Ditto the FIXED countD. ×Sorry to interrupt. Data blending has some limitations regarding non-additive aggregates such as COUNTD, MEDIAN, and RAWSQLAGG. ×Sorry to interrupt. In find, you cannot specify a query condition on the text score. Try one of the following options, as appropriate for your workbook: It may be possible to cross database join instead of blending. 0", "0x6400") or a value that falls outside the minimum and maximum value for an integer. In my workbook I will be using two statistical geographies, LSOA and MSOAs. 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. Choose the type of visualization you want to create, then use the editor to configure the options. 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. CallTime Avg (internal)>> because CallTime Avg (internal) is interpreted as being a reference to the AVG() aggregation type. Cyb3rWard0g changed the title Elastalert Integration - Elastalert Integration - Unsupported feature 'near' aggregation operator not yet implemented Dec 9, 2018. search. I get the the following error: unsupported aggregate action Digging through the source code I found there is no handler for collect. Click on the different cookie categories to find out more about each category and. I am trying to blend the same data against the other because I wanted to show Same Period last Year. You can choose whether functional and advertising cookies apply. MULTI_SOURCES_UNSUPPORTED_FOR_EXPRESSION. It shows the next message: "Cannot blend the secondary data source because one or more fields use an unsupported aggregation". The composite buckets are built from the combinations of the values. IN/EXISTS predicate subqueries can only be used in filters, joins, aggregations, window functions, projections, and UPDATE/MERGE/DELETE commands <treeNode>. To learn more about the Document type, see Documents. Loading. 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. Right-click OldPasswordAllowedPeriod, and then select Modify . Use range () to assign _start and _stop values. Region, sum (Orders. 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. You can choose whether functional and advertising cookies apply. e. Wrong aggregation type for query. The steps are. To resolve this, use FIRST (). See the Description column for details. Expand Post. The solution is not nice, but i. ) to aggregate the results. See Join Your Data for more information. Blending provides a quick and simple way to bring information from multiple data sources into a view. 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. We use three kinds of cookies on our websites: required, functional, and advertising. Complex expressions on top of the aggregate are not supported. No, the intention of the composite agg is to provide a way to systematically page through all results. s3. I get error: “Cannot blend the secondary data source because one or more fields use an unsupported aggregation. Hello Tableau world!! Am running into the strangest problem when data blending with V8. Refresh. node. Add the ’ [‘ open-square-brackets to the beginning and ‘]’ close-square-brackets to the end. (Ditto the FIXED countD. Hi All, I have blended primary and secondary data sources. htm#cannot-blend-the-secondary-data-source-because-one-or-more-fields-use-an-unsupported-aggregation. I've attached a super quick example using 10. I have a another data set with SQL Server data source with 2 fields: Relationship and ID. Most of the KPI's are straight forward to aggregate and compare but AVG FLEET requires the use of LOD expressions. if a host has 2 interfaces ports ( A & B ) connected to switch A on port 1 & port 2. 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. 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. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. Group by with no aggregation expression is not supported. (These are separated out merely to avoid cluttering the listing of more-commonly-used aggregates. I'd like to always use D1 except when it is NULL and then I'd like to use D2. You can choose whether functional and advertising cookies apply. Ditto: { FIXED [Patient ID] : COUNTD([Patient ID]) } Yet there it is in your workbook, very happy and functional. Expand Post. Thank you for the replace data source tip. CSS ErrorI'd like to always use D1 except when it is NULL and then I'd like to use D2. Blend ID (transaction datasource) =. Click the Networking view. An introduction to windowed aggregations. We are blending two data sources. {FIXED [Machine Nr] : COUNT ( [Machine Nr] )} / {FIXED [Machine Nr] : COUNT ( [Machine Nr] )} This works fine when there is no secondary data source but when I blend with a secondary data source it grays out my sheet i. An old, now unsupported, aggregation strategy is provided here only for backward compatibility with old activities. We have a calculated filed where an aggregation (COUNTD) is done on a filed of secondary data source. We use three kinds of cookies on our websites: required, functional, and advertising. 0. I need my calc to run on the row level irrespective of the view. UNSUPPORTED_IN_EXISTS_SUBQUERY. ) to such a degree that you need table calcs to re-aggregate to get to the desired granularity of the display. I have 2 filters (BU ISNull and CORPID) applied from secondary data source. Cannot blend the secondary data source because one or more fields use an unsupported aggregationFollow this link for more information: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. Resolution. Expand Post. step 1 : I do teaming for interface A & B, enable LACP on virtual teaming interface. Create free Team. query: true), while for other CDS views, I got the "Element contains. unsupported aggregation from blended data problem. We use three kinds of cookies on our websites: required, functional, and advertising. Wherever possible, the value of calculated is used, then sum where necessary, followed by unsupported. Returns the numerical value of the string as an integer. This page has an error. Rather than return incorrect results, Tableau turns the pill red, greys out the view, and generates the unsupported aggregation message. Using { allowDiskUse: false } to prohibit writing temporary files out to disk when allowDiskUseByDefault is set to true. Data blending has some limitations regarding non-additive aggregates such as COUNTD, MEDIAN and. conf and creating a NEW bucket with a new API key in Influx. General Information. 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'. Instead OVER aggregates produce an aggregated value for every input row. Embedded Document Fields. Cannot blend the secondary data source because one or more fields use an unsupported aggregation . Primary Data source - Actuals ( day grain) Secondary data source - Goals (quarter grain) Calculated Measures: Primary Data source :- CustCount = CountD( Cust_ID ). 6 removes the use of aggregate command without the cursor option unless the command includes the explain option. 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. Option 2: Rewrite your SELECT without a Correlated Subquery. ERROR 2238: At least two arguments are required. JimI have linked 2 sources using 3 dimensions. Ditto: { FIXED [Patient ID] : COUNTD([Patient ID]) } Yet there it is in your workbook, very happy and functional. Cannot blend the secondary data source because one or more fields use an unsupported aggregation issue. They both share a common field (State), and that is what I'm filtering on. There are some data blending limitations around non-additive aggregates, such as COUNTD, MEDIAN, and RAWSQLAGG. Step 7: Once composite provider activated, you can see all key figures. Ask Question Asked 3. At this time the only use case that I run into (for me and the folks that I help out) for data. aggregate(func=None, *args, engine=None, engine_kwargs=None, **kwargs) [source] #. 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:. ERROR 2374: Cannot compare row expressions of zero length. it's not possible to. The version I am working with 10. additionally, data coming from the secondary source are always aggregated at the level of the link when brought to the primary source - the individual records are no longer available and you are not able to filter across the various data sources at that point - that is the long way of saying you will have to join or use a relationship - not. 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])} Verify if one of the measures coming from the cube data source has a default aggregation different than SUM, MIN, MAX, COUNT. But the source calc is a countD. Is there a way to do it in a single query like in. You can choose whether functional and advertising cookies apply. elasticsearch. There is now a considerable number of published reviews that claim to follow the JBI approach to meta-aggregation. In this example, Geog_School is used. I am trying to use the below formula instead of countd function because my data comes from Impala. There are corresponding countToAggregation , countDistinctToAggregation etc. Cannot blend the secondary data source because one or more fields use an unsupported aggregation can some one has faced this type of issue before or any idea please share. You bucket your data by time and calculate the delta between time buckets using the lag window function:Introduction: Approaches to the synthesis of qualitative research have existed for more than 20 years and have evolved significantly during that time. calculated. Last week I’d promised to explain why the solution for identifying whether All items in a Tableau Quick Filter were selected wouldn’t work under certain circumstances in Tableau version 8, here it is, and along the way I’ll explain why COUNTD(Customer Name) could be red and the “Cannot blend the secondary data source because one or more fields use. AVG is a quasi-additive aggregation and may not be supported when blending. 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. If it’s correct, check if the aggregation is supported in your current version of OpenSearch. Click on the different cookie categories to find out more about each category and. The actual tables are constantly updated with 600+ locations and sales information that comes in daily: Table 1 (Primary): Location. If you add new historical data to an already-materialized bucket, it won't be reflected in a real-time aggregate. apply. ERROR: [HLS 214-256] in function 'vadd()': Unsupported aggregate pragma / directive on variable 'inner' as the bit-width after aggregation (24576) is larger than 4096 (justtesting / code / top. This aggregation provides a way to stream all buckets of a specific aggregation, similar to what scroll does for documents. Log Context. 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. Loading. I have two data sources to be used but need the count distinct of users from both the data sources. Click on the different cookie categories to find out more about each category and to change the default settings. To resolve this, use FIRST (). The level added can be any dimension independent of the. The limitation on mixing data often occurs with non-additive aggregates such as MEDIAN or COUNTD. 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,. Unlike the other multi-bucket aggregations, you can use the composite aggregation to paginate all buckets from a multi-level aggregation efficiently. Solution. 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. Use a derived table to nest aggregations or double aggregate. When trying to use COUNTD () it gives this error: cannot blend secondary data source because one or more fields use an unsupported aggregation when. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. You can choose whether functional. ” Its important to view the data using all the . This method has existed since the introduction of SQL tables in CA 11. To add aggregation to a field for a pivot table visual. For example, you would not be able to use a measure with the expression <<root. 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. ×Sorry to interrupt. 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". It's possible you're trying to use an unsupported aggregation with the blend. SimpleAggregateFunction(name, typesofarguments…) data type stores current value of the aggregate function, and does not store its full state as AggregateFunction does. ×Sorry to interrupt. 1 MongoDB Aggregate shows no result. 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. t Link Aggregation. Parameters: funcfunction, str, list, dict or None. SQLSTATE: none assigned. We use three kinds of cookies on our websites: required, functional, and advertising. s3. name from t1 t inner join category c on t. 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. 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. You can choose whether functional and advertising cookies apply. Depending on the type of data item, applies. Step 5: Change “Association With” from “InfoObject” to “Nothing”. Hadoop provides two fs interfaces - FileSystem and AbstractFileSystem. sh. Try to. if a host has 2 interfaces ports ( A & B ) connected to switch A on port 1 & port 2. But, this won't work if the view is aggregating the results. 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. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. if [created at] = { fixed [branch id]: max ( [created at])} Then [branch id] end. The one drawback is that DB2 blending does not support "non-additive aggregates" like COUNTD() and MEDIAN(). Table 9. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. Good morning @Fred Yu (Customer) . 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. Non-additive aggregates are aggregate functions that produce results that cannot be aggregated along a dimension. step 2 : network person on. Aggregate transformations output a table for every input table they receive. That's why you can't do COUNTD on a secondary blended data source. There are a number of built-in expressions (documented below) that can be used to help you write queries. id) FROM table_b b WHERE b. END . If there is another aggregation type such as AGG_AVG being used, change it to one of the supported aggregation listed. You can use the variable REMOVE in aggregation expressions to conditionally suppress a field. sh. I made a waffle chart grid using an excel data source that contains 3 fields: Rows, Columns and Percentage. 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 need to revisit my understanding of the limitations here! Cannot blend the secondary data source because one or more fields use an unsupported aggregation. 1 Connected to Tableau Server as Main DS and Live Connection to an excel file as secundary DS . Ditto: { FIXED [Patient ID] : COUNTD([Patient ID]) } Yet there it is in your workbook, very happy and functional. ) Functions shown as accepting numeric_type are available for all the types smallint, integer, bigint, numeric, real, and double precision. Click on the different cookie categories to find out more about each category and to change the default settings. Loading. The expression of the column which has an unsupported. When I am joining the two data sources I wanted to use "F Name" column with "Name" column. One common approach is meta-aggregation, as advocated by JBI. These dimensions were also used as filters in the particular sheet. 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 valueHi . These dimensions were also used as filters in the particular sheet. Restrictions. 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. Dimension plus instance of that dimension. You can choose whether functional and advertising cookies apply. Supported and Unsupported Aggregation Pipeline Stages. Click on the different cookie categories to find out more about each category and. Is the restriction on LOD expressions true even if. r. The current aggregation appear as a part of the measures name in the view. 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. ×Sorry to interrupt. The PIVOT aggregate expression has to be a call of a supported aggregate function. General Information. The parameter is working fine, but when I try to create additional measures via calculated field for example ((IF [Amount] > 150000 THEN [Amount] END. This means you can now just count, instead of count distinct, which is far easier to compute. filters on the worksheet, so we cannot drop filters out from the worksheet. Select the number of ports per host desired. I made a calc that mimicked your group, and if I use that on colors, the sheet works as you want. I use {Fixed [Owning Location Code], [Location Code], [Vehicle Group], month([MB Date]) :Avg([Avg Fleet])} to get the Avg. InternalFilter as an unsupported. Self-joins (joins using the same table more than once). The goal of this type of configuration is to maximize the use of the aggregate table. Data blending has some limitations regarding non-additive aggregates such as COUNTD, MEDIAN, and RAWSQLAGG. For more information, see Alias Field Values Using Data Blending. Explore Collectives; Labs. 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. The Usage property identifies the intended use for the data represented by the query item Usage property. CSS ErrorOpen the Format as HTML Pro step and go to the Data tab. You can use aggregations in the analysis level calculated field. 0. If a query asks for sales figures for Coke and Pepsi, the data should be returned from the aggregate table. I receive this error: "Cannot blend the data source because one or more fields uses an unsupported aggregation". e. 1 Unable to use aggregate function in. THEN add this total to the SUM of the projected_users from today's date through month X.