Real-time aggregates automatically add the most recent data when you query your continuous aggregate. conf and creating a NEW bucket with a new API key in Influx. Good morning @Fred Yu (Customer) . Right-click the field you are aggregating and select Properties. Argument to SUM (an aggregate function) is already an aggregation, and cannot be further aggregated. Log Context. s3. Use aggregation instead. Hadoop provides two fs interfaces - FileSystem and AbstractFileSystem. 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. I figured out why the exception aggregation is not pushed down to HANA. To resolve this issue, you should first verify the spelling and case of the aggregation name. It can be misunderstood, but, when using a data blend correctly, it is an efficient way to merge data sources in Tableau. Unsupported Aggregation, Quick Table Calc Sets, and Filters from Secondary Data blends?. coming from secondary data source There might be non-additive aggregates from a multi-connection data source with a live connection. When I am joining the two data sources I wanted to use "F Name" column with "Name" column. I've created the first chart with no problem, but I. twbx. data from the second source comes over as an aggregate - look into what the aggregation is on and how does that relate to what you have in the primary data base . Cannot blend the secondary data source because one or more fields use an unsupported aggregationFollow this link for more information:We use three kinds of cookies on our websites: required, functional, and advertising. I am trying to blend the same data against the other because I wanted to show Same Period last Year. And now if I bring that Fixed calculation ( called as "Duration" in my worksheet. 12. In the Name field, enter OldPasswordAllowedPeriod, and then press the Enter key. your calculation is already aggregated in order to maintain the aggregated level you need to use ATTR what exactly your doing is no idea so could you please. what I understood from my network colleague concept of LACP. System. IF ISNULL(D1) THEN D2. Go to a new worksheet. aggregations. Create an aggregation-based visualization panel edit. However, it gives me following error: "Cannot blend the secondary data source because one or more fields use an unsupported aggregation" Is there any workaround for this? Will I have to change the calculated fields? Best regards2. unsupported aggregation. On the field well menu, choose Aggregate, then choose the aggregate function that you want to apply. Like most other relational database products, PostgreSQL supports aggregate functions. Shell Method. Loading. Can't see what you are actually doing but Blending data has its limits. The problem is when I try to calculate the median of that same measure. I've tried that in the past, and I was always blocked by the unsupported aggregation message. Try one of the following options, as appropriate for your workbook: It may be possible to cross database join instead of blending. You can choose whether functional and advertising cookies apply. I have a another data set with SQL Server data source with 2 fields: Relationship and ID. I have changed the code with your suggested method and now getting this output: "ERROR : Unsupported document type for unmarshalling: []bson. I'm using a cube data source as my primary and am attempting to blend with an Excel sheet. Set the table calculation to COMPUTE USING using the KM Date field. Correlated references to a. Jim. You can choose whether functional and advertising cookies apply. Thus I have this calc below . 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. federated_computation(lambda: 'Hello, World!') ()IF user chooses month X and parameters/filters like gender/age/etc, THEN count all distinct users from data set #2 where the date of data set #2 is from 2017-08-01 through today's date. Change Default to be False — This tells the Format as HTML Pro step to not use the default data type as dictated by the recordset,. Hi everyone, I'm trying to blend two data sources on a single field, say 'Program Description'. Use aggregation instead. The version I am working with 10. Collation allows users to specify language-specific rules for string comparison, such as rules for lettercase and accent marks. 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. I've attached a super quick example using 10. Isilon - Link Aggregation LACP. Python is confused between its built-in sum function and the pyspark aggregation sum function you want to use. Thanks for the suggestion. step 1 : I do teaming for interface A & B, enable LACP on virtual teaming interface. The primary data source is just to filter for the invoices I want to look at. I am trying to use the below formula instead of countd function because my data comes from Impala. When I calculate the average of a measure and use the filter, it works perfectly fine. 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". ” Causes and Workarounds for a Blending Limitation Errors. e. It is now possible in Amazon QuickSight. Add a comment. 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. Hopefully. If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the. You should wait for the next scheduled. If a query asks for sales figures for all soft drinks, the aggregate table should be used for Coke and Pepsi and the detail data for the other brands. The tff. 06. You might just need to refresh it. See the Description column for details. 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). Expand Post. 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. query: true), while for other CDS views, I got the "Element contains. Name, Company. Let me look into the “Scaffold” option. The level added can be any dimension independent of the. Step 2: Build the map. The version I am working with 10. The actual tables are constantly updated with 600+ locations and sales information that comes in daily: Table 1 (Primary): Location. ×Expression Operators. InternalFilter as an unsupported. Step 1: Adding Tableau Aggregation Measures. We use three kinds of cookies on our websites: required, functional, and advertising. Loading. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. Jim. I have 2 duplicate data sources that I am blending together (they are duplicate because I want to filter the same data source 2 different ways but show it in. You can choose whether functional and advertising cookies apply. Data blending limitations. Share. I read that this is not possible. 9 KB. It is not allowed to use an aggregate function in the argument of another aggregate function. Fixed it by leaving type = float under [[inputs. Yes, the near operator isn't very well supported by sigmac. import pyspark. 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. functions as psf. using select. There are corresponding countToAggregation , countDistinctToAggregation etc. The current aggregation appear as a part of the measures name in the view. You can choose whether functional and advertising cookies apply. AVG is a quasi-additive aggregation and may not be supported when blending. 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. These dimensions were also used as filters in the particular sheet. Tip. apply. Refresh. 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. I’ve created this post in order to share my workaround for bringing over a Count Distinct (COUNTD) from a secondary data source. Let's say for example that you wanted. General Information. See Join Your Data for more information. And I use Join data source, after divide measures / row duplicate. id=(select max(id) from tahun) ShareTo use concat with spark window function you need to use user defined aggregate function (UDAF). Using Tableau. ORDER BY clause) but you should expect the order not to match. Click on the different cookie categories to find out more about each category and to change the default settings. We use three kinds of cookies on our websites: required, functional, and advertising. A Level of Detail (LOD) expression is being taken from the secondary data source. 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]. We use three kinds of cookies on our websites: required, functional, and advertising. 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. elasticsearch. Greetings, FranThe 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. The Junos OS removes the configuration statements related to aex and sets this interface to down state. Ask Question Asked 3. 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. B. ) Functions shown as accepting numeric_type are available for all the types smallint, integer, bigint, numeric, real, and double precision. countD requires row-level access to the data, not just aggregate access. A value greater than 0 treats a grade item's grades as extra credit during aggregation. 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. Just aggregates (like SUM, MIN, MAX. ” Its important to view the data using all the . Cannot blend the secondary data source because one or more fields use an unsupported aggregation. When there is unsupported aggregated measure using WINDOWS Functions, COUNTD,LODs etc. 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,Both Primary and Secondary data sources have duplicate rows due to multiple joins in data prep. Sum, average, and median are common aggregations; for a complete list, see List of Predefined Aggregations in Tableau. I had a query w. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. Upvote Upvoted Remove Upvote Reply. really need to see your twbx file to be of further help. I need my calc to run on the row level irrespective of the view. 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. Please use the. //Extend UserDefinedAggregateFunction to write custom aggregate function //You can also specify any constructor arguments. I have linked 2 sources using 3 dimensions. 60 shows aggregate functions typically used in statistical analysis. From the Data pane, drag a dimension field to Label on the Marks card. Use SIZE (): This is similar to #1, but provides a better visual and is more flexible with other analyses. I get error: “Cannot blend the secondary data source because one or more fields use an unsupported aggregation. UNSUPPORTED_IN_EXISTS_SUBQUERY. 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>`. The parameter is working fine, but when I try to create additional measures via calculated field for example ((IF [Amount] > 150000 THEN [Amount] END. 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. When using the function, the data types and order of the expressions must match that of the input arguments. Ask Question Asked 3. Data blending has some limitations regarding non-additive aggregates such as COUNTD, MEDIAN, and RAWSQLAGG. Rather than return incorrect results, Tableau turns the pill red, greys out the view, and generates the unsupported aggregation message. Wrap the Total KMs formula in: IF FIRST ()=0 THEN [Total KMs] END. in telegraf. 3 and I have created aggregates AGG for fields from data extract and excel file. 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. This happens only when the data sources are impala. Aggregate requirements. The issue is the data for the week numbers and RORs is not breaking down to the individual days/weeks/lines. Option 2: Rewrite your SELECT without a Correlated Subquery. Modified 2 years, 4 months ago. "Cannot blend the secondary data source because one or more fields use an unsupported aggregation. From the Input Recordsets pane on the left, expand the relevant Results from. Got same expected results in both py2 and. When you try to do that, Tableau generates the "Cannot blend the secondary data source. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. 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'. The driver does not provide methods for all aggregation pipeline operators in the Query API. The Regular Aggregate property. 3 and I have created aggregates AGG for fields from data extract and excel file. The limitation on mixing data often occurs with non-additive aggregates such as MEDIAN or COUNTD. mean any array of object I pass to this function it executes. and an identical LOD expression to get the Avg. Thank you for the replace data source tip. "-5", "123456") and fall within the minimum and maximum value for an integer. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. Loading. These expression operators are available to construct expressions for use in the aggregation pipeline stages. 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 . Click on the different cookie categories to find out more about each category and to change the default settings. Norbert, I'm baffled. CallTime Avg (internal)>> because CallTime Avg (internal) is interpreted as being a reference to the AVG() aggregation type. Non-additive aggregates are aggregate functions that produce results that cannot be aggregated along a dimension. 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. If you're getting * for the dimensions, then you'd need to increase the granularity of the view with additional dimension(s) on the Level of Detail Shelf and then use table calculations to re-aggregate at the appropriate level of granularity. But, this won't work if the view is aggregating the results. Embedded Document Fields. IF ISNULL(D1) THEN D2. You use the aggregation type to control how a key figure or. From the Input Recordsets pane on the left, expand the relevant Results from. Tested it manually by setting the load of odd GPU id’s to “Not supported” and sorting according to load. For more information, see Alias Field Values Using Data Blending. To define a new aggregate function, one selects a data type for the state value, an. At this time the only use case that I run into (for me and the folks that I help out) for data. I am trying to . Data blending has some limitations regarding non-additive aggregates such as COUNTD, MEDIAN and. This ordering is unspecified by default, but can be controlled by writing an ORDER BY clause within the aggregate call, as shown in Section 4. Cut out the three explanatory lines at the top (can be done with regex) Run a regex replace on the file (I’ve used . Problem in using indexes in aggregation pipeline. Self-joins (joins using the same table more than once). tff. Output tables contain a single row with the aggregated value. CSS ErrorUnsupported Commands in Serverless Instances. Hi, Thanks for your reply. If I cant go the above way then is there a possibility to do the duration calculation using table calculations or some other way. These dimensions were also used as filters in the particular sheet. Parameters: funcfunction, str, list, dict or None. AbstractFileSystem. Outputs documents in order of nearest to farthest from a specified point. I have two datasets; one is a shape file that contains regions and locations. ×Sorry to interrupt. We have a calculated filed where an aggregation (COUNTD) is done on a filed of secondary data source. The one drawback is that DB2 blending does not support "non-additive aggregates" like COUNTD() and MEDIAN(). ×Sorry to interrupt. But the source calc is a countD. ×Sorry to interrupt. Hi Folks, I am trying to solve a typical requirement (at least for me ). Expand Post. We use three kinds of cookies on our websites: required, functional, and advertising. You can choose whether functional. Add a comment. Operator expressions are similar to functions that take arguments. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. 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. Documents flowing through the aggregation pipeline are classified. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. We would like to show you a description here but the site won’t allow us. Where the description. 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. Currency measure vs. 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. Depending on the type of data item, applies. Data blending has some limitations regarding non-additive aggregates such as COUNTD, MEDIAN, and. filters on the worksheet, so we cannot drop filters out from the worksheet. In the opened dialog, you select ODBC DSN and click Next to continue. CSS Error In both instances, once I take customer country from my secondary source, I get this error: Cannot blend secondary data source as one or more fields use an unsupported aggregation . loads the aggregation part of the request (overwrites size from the query). Each output table from an aggregate function will: Contain a single record. e. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. Temporary tables are not supported by multi-connection data sources that use active connections. Data blending has some limitations regarding non-additive aggregates such as COUNTD, MEDIAN, and RAWSQLAGG. We use three kinds of cookies on our websites: required, functional, and advertising. 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. Tableau Tip 5. Ritesh Bisht (Member) 6 years ago. 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. For example, see Text Search in the Aggregation Pipeline. If you need to use an unsupported operation in an aggregation, you must define the entire expression using the BSON Document type. Click oUNSUPPORTED_IN_EXISTS_SUBQUERY. We are blending two data sources. If Monday is 1, Tues 2, Weds 3, Thurs = 4, Fri = 5 then the data will show as 15 for each day & point on the line. Norbert, I'm baffled. Atlas serverless instances don't support the following database commands and mongosh shell methods: Database Command. CSS ErrorI'd like to always use D1 except when it is NULL and then I'd like to use D2. 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. I get the the following error: unsupported aggregate action Digging through the source code I found there is no handler for collect. It is not allowed to use an aggregate function in the argument of another aggregate function. _types. One is to create a pass-through SQL table. Click on the different cookie categories to find out more about each category and. The composite buckets are built from the combinations of the values. 5 and have 2 data sources RPT and AD in the workbook which are currently extracts. Default aggregation for Exclude LOD is ATTR. You cannot convert a string value of a float or decimal or non-base 10 number (e. Another table is a a table that contains key fields such as date, region, location and hardware id (dimension). Because in Tableau, you don't use COUNTD function when Blending data source. You can choose whether functional and advertising cookies apply. If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the. Please use the. Use expressions to define the values that are sent from Tableau to the analytics model. In find, you cannot specify a query condition on the text score. Yup. We are blending two data sources. There are two types of calculated fields: on a data set level and on on analysis level. QuRouter. We have a calculated filed where an aggregation (COUNTD) is done on a filed of secondary data source. 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. Unsupported SQL features. Fleet for the other year. You can use inner select for this case: where daftar. For example, a min aggregation on an aggregate_metric_double field returns. Select the number of ports per host desired. 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. api. Click anywhere on the Field wells to expand them. I did that in your example too. 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. Provide details and share your research! But avoid. Tested it manually by setting the load of odd GPU id’s to “Not supported” and sorting according to load. Q&A for work. 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 . Returns the numerical value of the string as an integer. See Array Indexes are Unsupported. We use three kinds of cookies on our websites: required, functional, and advertising. Connect and share knowledge within a single location that is structured and easy to search. The result now should be correct BUT it'll return the result multiple times, once for each date. You can choose whether functional and. We use three kinds of cookies on our websites: required, functional, and advertising. I'd like to always use D1 except when it is NULL and then I'd like to use D2. cpp: 16: 63) justtesting: solution1 30. Yeah not sure what's going on there either. aggregateWindow () requires _start and _stop columns in input data. status='terima' and daftar. With LAC-A functions, you can specify at what level to group the computation. us/multipleconnections_troubleshooting. The number is a factor by which the grade value will be multiplied before it is added to the sum of all grades, but the item itself will not be. Good morning - see the attached. Expand Post. t Link Aggregation. I've tried that in the past, and I was always blocked by the unsupported aggregation message. Loading. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. If there is a GROUP BY clause specified. 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. sh. These dimensions were also used as filters in the particular sheet. addShardToZone () applyOps. Note. The composite buckets are built from the combinations of the values. Blending takes place in the 6th step of the order of operation after the data table for the individual worksheet is set and the filters applied - data from the secondary source are aggregated at the level of the link and brought to the primary as an. In the secondary data I have a LOD field called Total_Category_Response defined as { FIXED [Category]: SUM([Respose_ValWe use three kinds of cookies on our websites: required, functional, and advertising. Got same expected results in both py2 and. There are three conditions under which we can't use a non-additive aggregate (COUNTD, MEDIAN, RAWSQL) when. Sometimes , it's automatically working but sometimes it says 'Unsupported Aggregation' . I would like to visualize number of distinct hardware. Resolution. You can specify collation for a collection or a view, an index, or specific operations that support collation. Click on the different cookie categories to find out more about each category and. Query expressions describe a value or a computation that can be used as part of an update, create, filter, order by, annotation, or aggregate. Connect and share knowledge within a single location that is structured and easy to search. The ARRAY_CONTAINS method requires a second parameter to use in GROUP BY clause which I think will take 1 reason at a time. All arguments in calculated fields have to be single values or they all. Choose the type of visualization you want to create, then use the editor to configure the options. ×Enable management functions such as link aggregation, VLAN, and RSTP, to take care of your network topology with ease. I need my calc to run on the row level irrespective of the view. We use three kinds of cookies on our websites: required, functional, and advertising. Non-additive aggregates are aggregate functions that produce results that cannot be aggregated along a dimension. Currently windowed aggregations cannot be combined in the same SELECT statement with GROUP BY, HAVING, or any. Then the pivot rearranges it, creating columns for the in values from the name column, and using the aggregate ( max (data)) for the value in that column, which should give the desired results. If you then need to flatten the response for use in your visualisation this flattening will need to be done client side. if a host has 2 interfaces ports ( A & B ) connected to switch A on port 1 & port 2. Click on the different cookie categories to find out more about each category and. 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. First, let’s start with a simple example of a Structured Streaming query - a streaming word count. For example, if the aggregate rule for QI_a is set to sum, and the. t Link Aggregation. ) I need to revisit my understanding of the limitations here! I get error: “Cannot blend the secondary data source because one or more fields use an unsupported aggregation. 2. Click on the different cookie categories to find out more about each category and to change the default settings. I was now trying to use both calculations you did on a different sheet through data blending. You can choose whether functional and advertising cookies. There are a number of built-in expressions (documented below) that can be used to help you write queries. ) to such a degree that you need table calcs to re-aggregate to get to the desired granularity of the display. 1. To resolve this, use FIRST (). That's why you can't do COUNTD on a secondary blended data source. For example, Sales becomes SUM (Sales). " Environment Tableau Desktop Cube Blend Resolution Verify if one of the measures coming from the cube data source has a default aggregation different than SUM, MIN, MAX, COUNT. I made a waffle chart grid using an excel data source that contains 3 fields: Rows, Columns and Percentage. For example am having column called "Name" in my first data source, in second data sources am having column called "F Name". 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. data,c. Parameters expression : Non aggregating, non grouping expression in the SELECT list. I use {Fixed [Owning Location Code], [Location Code], [Vehicle Group], month([MB Date]) :Avg([Avg Fleet])} to get the Avg. I get error: “Cannot blend the secondary data source because one or more fields use an unsupported aggregation. 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. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. Unsupported aggregation type. Step 7: Once composite provider activated, you can see all key figures. I know that count distinct can not be used in the data blending. node. Please see if it helps , here it says that problem is with COUNT & they have provided one alternative way as well . ×Sorry to interrupt. Wrap the Total KMs formula in: IF FIRST ()=0 THEN [Total KMs] END. On the dashboard, click All types > Aggregation based. Most of the time, we work with FileSystem and use configuration options like fs. Unless you include the explain option, you must specify the cursor option. 0. Collectives™ on Stack Overflow – Centralized & trusted content around the technologies you use the most.