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. We use three kinds of cookies on our websites: required, functional, and advertising. Cannot blend the secondary data source because one or more fields use an unsupported aggregation issue Hi All! I would like to ask for your help, I do have two data sources: BI Cube (primary source) & Excel file (secondary) We use three kinds of cookies on our websites: required, functional, and advertising. Loading. Expand Post. The goal of this type of configuration is to maximize the use of the aggregate table. These expression operators are available to construct expressions for use in the aggregation pipeline stages. JimI have linked 2 sources using 3 dimensions. If you need to use an unsupported operation in an aggregation, you must define the entire expression using the BSON Document type. Resolution. Atlas serverless instances don't support the following database commands and mongosh shell methods: Database Command. 1. Yes, the near operator isn't very well supported by sigmac. Click on the different cookie categories to find out more about each category and to change the default settings. Hello Jim, Thank You for your reply. Norbert, I'm baffled. And, if you have issues with dates missing in one vs the other, you could use a date scaffold: Creating a Date Scaffold in Tableau - The Flerlage Twins: Analytics, Data Visualization, and Tableau “Cannot blend the secondary data source because one or more fields use an unsupported aggregation. ORDER BY clause) but you should expect the order not to match. 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. 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. e. Try to. Build the future of fintech in Latin America by connecting your. Non-additive aggregates are aggregate functions that produce results that cannot be aggregated along a dimension. The aggregation rule is determined automatically at run time. We don't get row-level data from secondary sources on a blend. 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 aggregation. CSS ErrorDeveloper Data Platform. Detailed procedure: Open the vSphere Web client. Connect and share knowledge within a single location that is structured and easy to search. What the message is basically saying is that you can’t reference a value in one row and also have aggregations. Click on the different cookie categories to find out more about each category and to change the default settings. Pipeline aggregations that take input from other aggregations instead of. ) to aggregate the results. sql. Documentation on relationship: Relate Your Data - Tableau. I have two datasets; one is a shape file that contains regions and locations. A value greater than 0 treats a grade item's grades as extra credit during aggregation. You can choose whether functional and advertising cookies apply. Most of the KPI's are straight forward to aggregate and compare but AVG FLEET requires the use of LOD expressions. ×Sorry to interrupt. For more information, see Troubleshoot. In this guide, we are going to walk you through the programming model and the APIs. We have to use two data sources for the visualization. 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]. “Cannot blend the secondary data source because one or more fields use an unsupported aggregation. Parameters: funcfunction, str, list, dict or None. 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]. category = c. teacher) teacher_id,. Hi, Thanks for your reply. This. The one drawback is that DB2 blending does not support "non-additive aggregates" like COUNTD() and MEDIAN(). The composite buckets are built from the combinations of the values. If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the. 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. Aggregated values are computed by aggregating the elements of the expression rather than the result. Hello Everyone, I am unable to sum an aggregate function. An introduction to windowed aggregations. An aggregate function computes a single result from multiple input rows. 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. e. The tff. At this time the only use case that I run into (for me and the folks that I help out) for data. Go to a new worksheet. Hi All, I have blended primary and secondary data sources. There are three conditions under which we can't use a non-additive aggregate (COUNTD, MEDIAN, RAWSQL) when. Hi All! I would like to ask for your help, I do have two data sources: BI Cube (primary source) & Excel file (secondary) BI Cube Data 1 pc. I've tried that in the past, and I was always blocked by the unsupported aggregation message. Ditto: { FIXED [Patient ID] : COUNTD([Patient ID]) } Yet there it is in your workbook, very happy and functional. The version I am working with 10. See Join Your Data for more information. Hi everyone, I'm trying to blend two data sources on a single. For example, you would not be able to use a measure with the expression <<root. calculated. You'll always want to return the same type, so that in itself could be an issue. An attempt was made to use an unsupported aggregate operator in the having or the compute clause in the rule condition. ERROR 2230: Arguments of row IN must all be row expressions. Click on the different cookie categories to find out more about each category and to change the default settings. This happens only when the data sources are impala. To indicate a cursor with the default batch size, specify cursor: {}. 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. in telegraf. We use three kinds of cookies on our websites: required, functional, and advertising. B. The following SQL features are not supported in materialized views: Left/right/full outer joins. That's why you can't do COUNTD on a secondary blended data source. Flux aggregate functions are transformations aggregate values from input tables in some way. 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. When I am joining the two data sources I wanted to use "F Name" column with "Name" column. On the dashboard, click All types > Aggregation based. However I keep getting the following error: co. additional request properties set programmatically. id=(select max(id) from tahun) ShareTo use concat with spark window function you need to use user defined aggregate function (UDAF). In general, these expressions take an. ) 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. unsupported aggregation. Click on the different cookie categories to find out more about each category and. The aggregate functions array_agg, string_agg, and xmlagg, as well as similar user-defined aggregate functions, produce meaningfully different result values depending on the order of the input values. ×Enable management functions such as link aggregation, VLAN, and RSTP, to take care of your network topology with ease. In the actual data I get the error: Cannot blend the secondary data source because one or more fields use an unsupported aggregation. Make sure that you are blending on dimensions present in the view or on all of the. I did that in your example too. In find, you cannot specify a query condition on the text score. Go to a new worksheet. It can be misunderstood, but, when using a data blend correctly, it is an efficient way to merge data sources in Tableau. On the field well menu, choose Aggregate, then choose the aggregate function that you want to apply. cpp: 16: 63) justtesting: solution1 30. Over Aggregation # Batch Streaming OVER aggregates compute an aggregated value for every input row over a range of ordered rows. Most of the time, we work with FileSystem and use configuration options like fs. Rather than return incorrect results, Tableau turns the pill red, greys out the view, and generates the unsupported aggregation message. You can use the variable REMOVE in aggregation expressions to conditionally suppress a field. AVG is a quasi-additive aggregation and may not be supported when blending. We use three kinds of cookies on our websites: required, functional, and advertising. I think it may be because we are using the CountD function to calculate the customer count from the secondary data source. IF ISNULL(D1) THEN D2. When double-clicked, it is automatically added to Detail on the Marks card and a map view is created. The steps are. The expression <expr> does not support more than one source. Golang mongodb aggregation using mongo-driver. With LAC-A functions, you can specify at what level to group the computation. An old, now unsupported, aggregation strategy is provided here only for backward compatibility with old activities. You can choose whether functional and advertising cookies apply. It is now possible in Amazon QuickSight. tff. ×Sorry to interrupt. apply. Non-additive aggregates are aggregate functions that produce results that cannot be aggregated along a dimension. Good morning @Fred Yu (Customer) . You can use inner select for this case: where daftar. 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. [Secondary Source Field]))}) This seems to be the only calculation that is valid. 75K subscribers 3K views 4 years ago Cannot blend the secondary data source because one or more fields use an unsupported aggregation It’s cable. twbx. (Ditto the FIXED countD. QSS Overview; QuRouter. There are two types of calculated fields: on a data set level and on on analysis level. also if you are only looking for a single value to be filtered you could use a parameter and filter the. CSS ErrorHi Ben, This comes from my own explorations and got confirmed by the Tableau dev who built the latest version of data blending (called DB2). Ce message a été modifié par : nicolas sinquin. person = a. (It is a field that contains account names (company) in the sample data. Instead of blending multiple data sources, create one data source that joins all of the data using either physical or logical joins. Hi all. really need to see your twbx file to be of further help. but no collectToAggregationThe SQL Language. We have a calculated filed where an aggregation (COUNTD) is done on a filed of secondary data source. The result now should be correct BUT it'll return the result multiple times, once for each date. These dimensions were also used as filters in the particular sheet. 4, MongoDB supports faceted classification by using the Aggregation Framework. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. There is now a considerable number of published reviews that claim to follow the JBI approach to meta-aggregation. Often the best solution is to rewrite your SELECT without using a correlated sub-query at all. Error "Cannot blend the secondary data source because one or more fields use an unsupported aggregation" when Data Blend… You may just be able to turn the Excel file into an extract to overcome this, but I'd have to test/see the data & workbook to be certain. Add the columns or the expression to the GROUP BY, aggregate the expression, or use <expressionAnyValue> if you do not care which of the values within a group is returned. General Information. So you're basically passing a string 'converted' to the python built-in sum function which expects an iterable of int. 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:. There are a number of built-in expressions (documented below) that can be used to help you write queries. In the Data pane, double-click a spatial field. Sorting by a tuple with 2 values is much slower. Temporary tables are not supported by multi-connection data sources that use active connections. We use three kinds of cookies on our websites: required, functional, and advertising. 2. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. The expression <expr> does not support more than one source. functions as psf. Notice that order matters when the JSON snippets have some common properties: just as when setting property values programmatically, the last value that is set for a property overwrites the previous one. 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 . If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the. We use three kinds of cookies on our websites: required, functional, and advertising. It shows the next message: "Cannot blend the secondary data source because one or more fields use an unsupported aggregation". An aggregate function computes a single result from multiple input rows. Data blending limitations. Many Tableau developers find data blending frustrating. So, it seems the two solutions right now are: Create two jobs that have datafeeds that search for the appropriate fields (probably the most correct option) Partition across my_filter_field and have both use the same detectors. Unlike the other multi-bucket aggregations, you can use the composite aggregation to paginate all buckets from a multi-level aggregation efficiently. You can choose whether functional and advertising cookies apply. I had a query w. Note you'll need the KM Date field on the Detail shelf. Just aggregates (like SUM, MIN, MAX. ×Sorry to interrupt. ElasticsearchException: [es/search] failed: [x_content_parse_exception] [1:44] [composite] unknown field [name] Here is my. ) 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. cannot blend the secondary data source because one or more fields use an unsupported aggregation. Step 6: Activate Composite Provider and you won’t see any warnings. Find centralized, trusted content and collaborate around the technologies you use most. The issue was that the bucket sensor that I had previously defined in my telegraf. 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. There are two ways of dealing in a data module with unsupported data types. In order to create the waffle chart I am blending it with another datasource using the calculated field defined as [Week 5 (Week5Bond)]. Outputs documents in order of nearest to farthest from a specified point. cannot blend secondary data source because one or more fields use an unsupported aggregation beacuse of LOD. I've created the first chart with no problem, but I. t Link Aggregation. Using non-aggregate measures . QNAP’s QuRouter OS simplifies managing high-speed and high-coverage LAN/WAN. Change the aggregation of a measure in View. Parameters expression : Non aggregating, non grouping expression in the SELECT list. Yeah not sure what's going on there either. I have a User model and I want to perform generic aggregation. This method has existed since the introduction of SQL tables in CA 11. Fácil para crear diseños personalizados de tipo de papel no compatible. Windowed aggregations partition the results from a SQL query into groups in order to perform calculations across adjacent rows of the query result. Query Expressions. Right-click the field you are aggregating and select Properties. Upvote Upvoted Remove Upvote Reply. The Junos OS removes the configuration statements related to aex and sets this interface to down state. Unsupported aggregation in secondary data source using an LOD expression. Wrong aggregation type for query. 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. You can choose whether functional and advertising cookies apply. I'm trying to get the total of the secondary data source field irreHi. Another table is a a table that contains key fields such as date, region, location and hardware id (dimension). Computing or filtering based on an aggregated value is not supported. {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. END . Add the ’ [‘ open-square-brackets to the beginning and ‘]’ close-square-brackets to the end. END . The Regular Aggregate property. 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 . Try loading pyspark functions with an alias instead:. Unsupported SQL features. Expand Post. If you add new historical data to an already-materialized bucket, it won't be reflected in a real-time aggregate. addShard () addShardToZone. "Cannot blend the secondary data source because one or more fields use an unsupported aggregation. The primary one is called Dim_Service_Status. This is because any calculation will happen before aggregation in case of a formula or a calculated key figure and it will therefore not be pushed down. Click From Other Sources, and then click From Data Connection Wizard. Loading. We have to use two data sources for the visualization. 3 and I have created aggregates AGG for fields from data extract and excel file. Hello I am having a problem with the relationship between two data sources. I've attached my workbook that contains 2 data sources that are blended by invoice number. For example am having column called "Name" in my first data source, in second data sources am having column called "F Name". I had a query w. elastic. CSS ErrorIf I create my calculated field without using an aggregation with {Profit}, QuickSight doesn’t know from which row to get the value. Expand Post. There are two types of calculated fields: on a data set level and on on analysis level. And I use Join data source, after divide measures / row duplicate. Time-interval with identical time points. Someone in the Community told me the following: "MAX isn't supported in. Open the Format as HTML Pro step and go to the Data tab. Strings that are stored in documents can be manipulated to extract pieces that you want for many use cases, including further processing and comparisons, or for cleaning up the data. Note. Click on the different cookie categories to find out more about each category and to change the default settings. I have a another data set with SQL Server data source with 2 fields: Relationship and ID. Loading. You can choose whether functional and advertising cookies apply. Expand Post. I am trying to create a waffle chart. Jim. Parameters expression : Non aggregating, non grouping expression in the SELECT list. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. Hopefully. 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. Click on the different cookie categories to find out more about each category and to change the default settings. aggregateWindow () requires _start and _stop columns in input data. If. See. MULTI_SOURCES_UNSUPPORTED_FOR_EXPRESSION. 0. Data blending has some limitations regarding non-additive aggregates such as COUNTD, MEDIAN and RAWSQLAGG. remove the [Date Occurred] filter). Expand Post. Copy link Member. 1. Multiple instances of same dimension. if [created at] = { fixed [branch id]: max ( [created at])} Then [branch id] end. Learn more about Collectives Teams. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. I get error: “Cannot blend the secondary data source because one or more fields use an unsupported aggregation. keep the dimensions in the view. There are non-additive aggregates from a multi-connection data source with an active connection. Cannot blend the secondary data source because one or more fields use an unsupported aggregation" when Data Blending Hello Everyone, I am using one data source which is a LIVE connection and I have duplicated same data source , the reason behind duplication is i want to have total of category which will be constant and it will not change even. 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". Which almost works, but if I then try to use the resulting calculated field as the “angle” variable for a pie chart, I get the following error: Cannot blend the secondary data source because one or more fields use an unsupported aggregationnumber of records (datasource1)/total headcounts (datasource2) and i get the red pill telling me "cannot blend the secondary datasource because one or more fields use an unsupported aggregation". 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. QuRouter. When you use such an expression in the view, Tableau will aggregate results up to the view level. In this example, Geog_School is used. //Extend UserDefinedAggregateFunction to write custom aggregate function //You can also specify any constructor arguments. I’ve found a couple examples in the forums. 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,. htm#cannot-blend-the-secondary-data-source-because-one-or-more-fields-use-an-unsupported-aggregation. ) to such a degree that you need table calcs to re-aggregate to get to the desired granularity of the display. The PIVOT aggregate expression has to be a call of a supported aggregate function. An expression has a finer level of detail than the view when it references a superset of the dimensions in the view. [Secondary Source Field]))}) This seems to be the only calculation that is valid. The current aggregation appear as a part of the measures name in the view. This is a new complexity in Tableau v8: In v7 and earlier, to blend we had to have the linked dimensions in the view, i. We use three kinds of cookies on our websites: required, functional, and advertising. 3 and I have created aggregates AGG for fields from data extract and excel file. I receive this error: "Cannot blend the data source because one or more fields uses an unsupported aggregation". . So in my case where CKF1 = RKF1 - RKF2, I will need to store this result in the database as a key figure. Thus I have this calc below . Use a derived table to nest aggregations or double aggregate. 2. Step 7: Once composite provider activated, you can see all key figures. When I am joining the two data sources I wanted to use "F Name" column with "Name" column. I was now trying to use both calculations you did on a different sheet through data blending. The primary. That's probably your problem. I created a parameter with a simple calculated field so that I may toggle between two measures. Basically, I am using filters with only one filter (thus only one bucket) so that we can have a max bucket pipeline aggregation (which only supports multi-bucket) and then the pipeline aggregation name can simply be the detector field name (metric1_value and matric2_value in this specific case):This time we're going to do what would have been a MongoDB aggregation pipeline, but this time using LINQ. In the Value field, enter the amount of time (in minutes) you want the old password to still be active after a password reset. This section describes the summary, or aggregation, functions that are available in IBM® Cognos® Analytics - Reporting. As of Version 3. it's not possible to. Thus I have this calc below . 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. SQLSTATE: none assigned. I've tried that in the past, and I was always blocked by the unsupported aggregation message. Because in Tableau, you don't use COUNTD function when Blending data source. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. Real-time aggregates automatically add the most recent data when you query your continuous aggregate. Extract and aggregate: Take an extract of your data and aggregate it based on the occurrences of Dimension X. UNSUPPORTED_TABLE_ARGUMENTWindowed Aggregations. For more information on blends, check this out: Blend Your Data - Tableau . ×Sorry to interrupt. CompanyID =. really need to see your twbx file to be of further help. 1. To specify collation when you query documents in the MongoDB Atlas UI, see Specify Collation. date, t. Send us feedback | Privacy. How to do mongo aggregation. 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. Aggregate requirements. I get error: “Cannot blend the secondary data source because one or more fields use an unsupported aggregation. The result now should be correct BUT it'll return the result multiple times, once for each date. Kindly see the screenshot as below:-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 . When LSOAs are aggregated up to MSOAs i need the percentage to be calculated from the LSOA dataCount Distinct in Secondary Data Source - "cannot blend secondary data source because one or more fields use an unsupported aggregation" Hi! I'm trying to blend 2 data sources. if a host has 2 interfaces ports ( A & B ) connected to switch A on port 1 & port 2. Add GROUP BY or turn it into the window functions using OVER clauses. 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-additive aggregates will work with data blending. IF ISNULL(D1) THEN D2. Have the same group key as the input. If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the. 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. Unless you include the explain option, you must specify the cursor option. Complex expressions on top of the aggregate are not supported. Support Functions for Aggregates. 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. s3. Use expressions to define the values that are sent from Tableau to the analytics model. aggregate(func=None, *args, engine=None, engine_kwargs=None, **kwargs) [source] #. Provide details and share your research! But avoid. Sandhya. if a host has 2 interfaces ports ( A & B ) connected to switch A on port 1 & port 2. step 1 : I do teaming for interface A & B, enable LACP on virtual teaming interface. Output tables contain a single row with the aggregated value. On this page you'll find information regarding errors that you might encounter when using our aggregation, enrichment, and payment initiation API, and how to solve them. Click on the different cookie categories to find out more about each category and to change the default settings. CSS ErrorHi, In case of blending some of functions like countd , Min, Max will not work if the dimensions are in any of shelfs or in filters . When I calculate the average of a measure and use the filter, it works perfectly fine. The limitation on mixing data often occurs with non-additive aggregates such as MEDIAN or COUNTD. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. Aggregation consistency; In order to create a calculated field with aggregated fields in the calculation, ALL fields must be aggregated or not aggregated, you cannot have a mixture of aggs vs nonaggs in the CF. Cut out the three explanatory lines at the top (can be done with regex) Run a regex replace on the file (I’ve used . Yup. CSS Error Loading. Hello Tableau world!! Am running into the strangest problem when data blending with V8. These dimensions were also used as filters in the particular sheet. 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. I read that this is not possible. Learn more about Collectives Teams. A. The Usage property identifies the intended use for the data represented by the query item Usage property. If there is another aggregation type such as AGG_AVG being used, change it to one of the supported aggregation listed. If it’s not supported, you may need to upgrade your. You can choose whether functional and advertising cookies apply. but no collectToAggregationThe SQL Language. 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. To achieve this you need to add Calculated Field to an Analysis ( as described here ). Add a comment. This means you can now just count, instead of count distinct, which is far easier to compute. Ask Question Asked 3. clients. 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. Had a chance to test it, and it seems to work in both py2 and py3. 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 . This happens only when the data sources are impala. Solution. Had a chance to test it, and it seems to work in both py2 and py3. The one drawback is that DB2 blending does not support "non-additive aggregates" like COUNTD() and MEDIAN(). You can choose whether functional and advertising cookies apply. ×Sorry to interrupt. Solution using relationship:Aggregates functions we use only in SELECT block.