We use three kinds of cookies on our websites: required, functional, and advertising. A faceted classification uses semantic categories (either general or subject-specific) that are combined to create the full classification entry. coming from secondary data source There might be non-additive aggregates from a multi-connection data source with a live connection. Sorting by a tuple with 2 values is much slower. You can use the variable REMOVE in aggregation expressions to conditionally suppress a field. Cannot blend the secondary data source because one or more fields use an unsupported aggregation . Self-joins (joins using the same table more than once). ×Sorry to interrupt. Currency measure vs. Please excuse my lack of language skills - but the field that is causing the problem is the Max() calculation that is a record by record comparison across a data file - Are you using a live data source on that data set? If you can't get around using the function you could extract that data first . 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. The MAX aggregate function is not logically necessary in this case because the international_GDP table has only one row per country; however, because the server doesn’t know that, and because the server requires that the subquery return no more than one row, the query uses the aggregate function to force the server to recognize that the subquery. Instead OVER aggregates produce an aggregated value for every input row. 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. The aggregation rule is determined automatically at run time. also if you are only looking for a single value to be filtered you could use a parameter and filter the. See the Description column for details. We are going to explain the concepts mostly using the default micro-batch processing model, and then discuss Continuous Processing model. The version I am working with 10. If you’ve tried to show a COUNTD from a secondary before, you’ve undoubtedly seen the message stating “Cannot blend the secondary data source because one or more fields use an unsupported aggregation”. We use three kinds of cookies on our websites: required, functional, and advertising. I receive this error: "Cannot blend the data source because one or more fields uses an unsupported aggregation". Have the same group key as the input. tff. Hello. In order to create the waffle chart I am blending it with another datasource using the calculated field defined as [Week 5 (Week5Bond)]. ERROR 2238: At least two arguments are required. It's possible you're trying to use an unsupported aggregation with the blend. I tried using Excel as the primary and I kept getting errors when I tried to add the cube. QNAP’s QuRouter OS simplifies managing high-speed and high-coverage LAN/WAN. This page has an error. When I use a terms aggregation, it works fine and returns buckets as expected. Blend ID (transaction datasource) =. Filter each of the data sources independently on the more granular dimensions. Note you'll need the KM Date field on the Detail shelf. I have linked 2 sources using 3 dimensions. filters on the worksheet, so we cannot drop filters out from the worksheet. 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. Step 3: Create assignment or drag & drop key figure in target. Unsupported aggregation stages. If there is another aggregation type such as AGG_AVG being used, change it to one of the supported aggregation listed. I have two Cassandra data sources one is ctt and other is ptt both contains a Fixed Calculations that I wanted to bring into visualization from both the datasources . The version I am working with 10. 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. Norbert, I'm baffled. Non-additive aggregates are aggregate functions that produce results that cannot be aggregated along a dimension. Atlas Data Federation supports all the aggregation pipeline stages except the following: For the following stages in Atlas Data Federation queries, Atlas Data Federation introduces an alternate syntax, includes a caveat, or deviates from server. That's probably your problem. Loading. Data blending limitations. Find centralized, trusted content and collaborate around the technologies you use most. I read that this is not possible. Click on the different cookie categories to find out more about each category and. Python is confused between its built-in sum function and the pyspark aggregation sum function you want to use. You can choose whether functional and advertising cookies apply. ×Sorry to interrupt. 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. I have some problems when I try to blend my secondary with my main data. Region, sum (Orders. 0. At this time the only use case that I run into (for me and the folks that I help out) for data. We use three kinds of cookies on our websites: required, functional, and advertising. See the Description column for details. twbx. 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. Tested it manually by setting the load of odd GPU id’s to “Not supported” and sorting according to load. 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 it’s correct, check if the aggregation is supported in your current version of OpenSearch. Embedded Document Fields. We use three kinds of cookies on our websites: required, functional, and advertising. Aggregate requirements. 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. e. 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. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. 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. We use three kinds of cookies on our websites: required, functional, and advertising. If you need to use an unsupported operation in an aggregation, you must define the entire expression using the BSON Document type. if a host has 2 interfaces ports ( A & B ) connected to switch A on port 1 & port 2. As of Version 3. Hi. step 2 : network person on. Flux aggregate functions are transformations aggregate values from input tables in some way. select t. Elasticsearch organizes aggregations into three categories: Metric aggregations that calculate metrics, such as a sum or average, from field values. 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. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. UNSUPPORTED_IN_EXISTS_SUBQUERY. I get error: “Cannot blend the secondary data source because one or more fields use an unsupported aggregation. Using Tableau. The string value must be a base 10 integer (e. For example, blend in the count of countries from. If you then need to flatten the response for use in your visualisation this flattening will need to be done client side. When you try to do that, Tableau generates the "Cannot blend the secondary data source. This is indicated by the following icon: The view you are trying to build will function if you use the date from the primary data source (Shipped): Let us know if this is clear, or if more explanation is required! Cheers, TimothyLevel-aware calculation - aggregate (LAC-A) functions. ) A LOD calc is also trying to do stuff at the row level. 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. We have a calculated filed where an aggregation (COUNTD) is done on a filed of secondary data source. Table 2 (Secondary): Location | Item Sold | Price | Date. The problem is when I try to calculate the median of that same measure. You can choose whether functional. 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. To resolve this, use FIRST (). This happens only when the data sources are impala. ×Sorry to interrupt. Click on the different cookie categories to find out more about each category and. I have two data sources to be used but need the count distinct of users from both the data sources. Hi everyone, I'm trying to blend two data sources on a single. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. The solution is not nice, but i. _types. 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]. Use a derived table to nest aggregations or double aggregate. ERROR 2230: Arguments of row IN must all be row expressions. Temporary tables are not supported by multi-connection data sources that use active connections. (It is a field that contains account names (company) in the sample data. cs file to look like the following: Code Snippet In the above LINQ query, we're doing a series of steps, just like stages in an aggregation pipeline. I'll play around with it, see if I can make it work that way. In the opened dialog, you select ODBC DSN and click Next to continue. Loading. Explore Collectives; Labs. Now select a data source you want to connect to, and click Next. unsupported aggregation from blended data problem. 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. This section describes the summary, or aggregation, functions that are available in IBM® Cognos® Analytics - Reporting. 38. [Secondary Source Field]))}) This seems to be the only calculation that is valid. 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. In the Data pane, double-click a spatial field. 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. 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. 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. . For example, Sales becomes SUM (Sales). If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the. 8 for information about use of aggregate functions as window functions. I have a another data set with SQL Server data source with 2 fields: Relationship and ID. CSS ErrorIf I create my calculated field without using an aggregation with {Profit}, QuickSight doesn’t know from which row to get the value. Shell Method. mean any array of object I pass to this function it executes. Ritesh Bisht (Member) 6 years ago. clients. When I am joining the two data sources I wanted to use "F Name" column with "Name" column. I’ve found a couple examples in the forums. See. ) 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. 2. In this guide, we are going to walk you through the programming model and the APIs. 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". 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. CSS ErrorLoading. 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. Hopefully. Create free Team. From the Data pane, drag a dimension field to Label on the Marks card. Tip. step 2 : network person on. Connect and share knowledge within a single location that is structured and easy to search. Bucket aggregations that group documents into buckets, also called bins, based on field values, ranges, or other criteria. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. In our example, we could write the original as: select Company. The PIVOT aggregate expression has to be a call of a supported aggregate function. CallTime Avg (internal)>> because CallTime Avg (internal) is interpreted as being a reference to the AVG() aggregation type. 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. Option 2: Rewrite your SELECT without a Correlated Subquery. IF ISNULL(D1) THEN D2. aggregateWindow () uses the timeSrc and timeDst parameters to assign a time to the aggregate value. This should explain why when you are using the SUM aggregation it works. 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 did that in your example too. If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the. I need my calc to run on the row level irrespective of the view. A value greater than 0 treats a grade item's grades as extra credit during aggregation. Instead of blending multiple data sources, create one data source that joins all of the data using either physical or logical joins. You can choose whether functional and advertising cookies apply. unsupported aggregation. Q&A for work. g. Right-click the field you are aggregating and select Properties. cannot blend secondary data source because one or more fields use an unsupported aggregation beacuse of LOD. I'm trying to create a frequency distribution as a percent of total for individual products in a single category on one chart, then dual axis a second chart with the frequency distribution of the category for comparison purposes. Aggregated values are computed by aggregating the elements of the expression rather than the result. Tableau Tip 5. 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. Claims Paid for Treatment and Testing. Sandhya. To achieve this you need to add Calculated Field to an Analysis ( as described here ). Upvote Upvoted Remove Upvote Reply. Data blending has some limitations regarding non-additive aggregates such as COUNTD, MEDIAN, and RAWSQLAGG. There are two types of calculated fields: on a data set level and on on analysis level. I am using Tableau 2018. Non-additive aggregates are aggregate functions that produce results that cannot be aggregated along a dimension. There is now a considerable number of published reviews that claim to follow the JBI approach to meta-aggregation. It is now possible in Amazon QuickSight. I've tried that in the past, and I was always blocked by the unsupported aggregation message. Complex expressions on top of the aggregate are not supported. api. 4, MongoDB supports faceted classification by using the Aggregation Framework. The expression <expr> does not support more than one source. 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. Windowed aggregations partition the results from a SQL query into groups in order to perform calculations across adjacent rows of the query result. non-currency measure. 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. You can choose whether functional and advertising cookies apply. With LAC-A functions, you can specify at what level to group the computation. Set the table calculation to COMPUTE USING using the KM Date field. 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. Aggregate Functions #. Unsupported aggregate subquery with non-equality correlated predicates. Loading. Most of the KPI's are straight forward to aggregate and compare but AVG FLEET requires the use of LOD expressions. We use three kinds of cookies on our websites: required, functional, and advertising. 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. . An old, now unsupported aggregation strategy provided here only for backward compatibility with old activities. 2. You can choose whether functional and advertising cookies apply. Log “Unsupported aggregation type [{}]” class name is Pivot. 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. person = a. Aggregate using one or more operations over the specified axis. addShard. First, let’s start with a simple example of a Structured Streaming query - a streaming word count. 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. And now if I bring that Fixed calculation ( called as "Duration" in my worksheet. using select. Hadoop provides two fs interfaces - FileSystem and AbstractFileSystem. When there is unsupported aggregated measure using WINDOWS Functions, COUNTD,LODs etc. This optimization can be applied to functions for which the following property holds f(S1 UNION ALL S2) = f(f(S1) UNION ALL f(S2)). functions as psf. Click on the different cookie categories to find out more about each category and. 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'. Hello Jim, Thank You for your reply. 2. ElasticsearchException: [es/search] failed: [x_content_parse_exception] [1:44] [composite] unknown field [name] Here is my. 1. 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. Click on the different cookie categories to find out more about each category and to change the default settings. us/multipleconnections_troubleshooting. Hi Folks, I am trying to solve a typical requirement (at least for me ). java. Can anybody please help me with a solution. (You need to get individual row access to evaluate DISTINCT functionality. Expand Post. Filter each of the data sources independently on the more granular dimensions. This could be due to a typo in the aggregation name or the use of an unsupported aggregation. Expand the Datacenter and select the Distributed Switch. Thanks. Change the C# code in the Program. The second method, which is new to 11. Atlas Data Lake supports all the aggregation pipeline stages except the following: For the following stages in Atlas Data Lake queries, Atlas Data Lake introduces an alternate syntax, includes a caveat, or deviates from server. Some functions, such as , are available only when you click the summarize button on the report object toolbar. The expression <expr> does not support more than one source. It shows the next message: "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. Sub-path [interactions-c] points to non single-bucket aggregation" } } ] }, "status" : 500 } this is my index mapping:DataFrameGroupBy. We use three kinds of cookies on our websites: required, functional, and advertising. 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]. 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 . Amount) as Total from Company left outer Orders on Orders. search. Aggregate the dimension to show only the MIN or MAX value. In the Name field, enter OldPasswordAllowedPeriod, and then press the Enter key. 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 . The unsupported aggregation happens when your aggregate requires row-level visibility to the secondary data source. what I understood from my network colleague concept of LACP. Tableau Desktop 2018. You can choose whether functional and advertising cookies apply. 9 KB. Here is a slimmed down version what I'm trying to do. You can choose whether functional and. Click on the different cookie categories to find out more about each category and to change the default settings. additional request properties set programmatically. it's not possible to. Upvote Upvoted Remove Upvote Reply. Jim. On the dashboard, click All types > Aggregation based. date, t. To define a new aggregate function, one selects a data type for the state value, an. ERROR 2374: Cannot compare row expressions of zero length. Note. For example am having column called "Name" in my first data source, in second data sources am having column called "F Name". We are blending two data sources. Is there a way to do it in a single query like in. Just aggregates (like SUM, MIN, MAX. Currently windowed aggregations cannot be combined in the same SELECT statement with GROUP BY, HAVING, or any. Expand Post. ×Sorry to interrupt. 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. ×Sorry to interrupt. step 1 : I do teaming for interface A & B, enable LACP on virtual teaming interface. ×Expression Operators. Click anywhere on the Field wells to expand them. 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 . 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. ELSE D1. 1. Outputs documents in order of nearest to farthest from a specified point. [Secondary Source Field]))}) This seems to be the only calculation that is valid. aggregateWindow () requires _start and _stop columns in input data. Argument to SUM (an aggregate function) is already an aggregation, and cannot be further aggregated. Credits to Jonathan Drummey for the below workaround Cannot blend the secondary data source because one or more fields use an unsupported aggregation . Hi all. CSS ErrorThe problem is that calculation on CDS views by default are done at records level and aggregated, hence my idea was to use the @DefaultAggregation: #FORMULA annotation to get the desire result. This 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. Jim. In the Value field, enter the amount of time (in minutes) you want the old password to still be active after a password reset. Use aggregation instead. You can't directly use concat function with window function. I've tried that in the past, and I was always blocked by the unsupported aggregation message. Many target systems don't support it at all (e. The following query. Use range () to assign _start and _stop values. Steps to Implement Tableau Aggregation. Then use that field as the linking field for your blend. ERROR 2239: At most one path number can be entered. The limitation on mixing data often occurs with non-additive aggregates such as MEDIAN or COUNTD. I am trying to use the below formula instead of countd function because my data comes from Impala. Step 3: Changing the Default Measures for Aggregation in Tableau. Solution. 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. PaulYou can still use the field with COUNTD() from the secondary data source if you remove all dimensions from the secondary data source (i. We use three kinds of cookies on our websites: required, functional, and advertising. Data blending has some limitations regarding non-additive aggregates such as COUNTD, MEDIAN and RAWSQLAGG. e. 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. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. 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. Documentation on relationship: Relate Your Data - Tableau. Data blending has some limitations regarding non-additive aggregates such as COUNTD, MEDIAN, and RAWSQLAGG. MenuHow to use an aggregate function on an array column in cosmos-db. In the LACP section, click the +NEW symbol to create a new LAG. 3 and I have created aggregates AGG for fields from data extract and excel file. Jim. sql. Click on the different cookie categories to find out more about each category and to change the default settings. id) FROM table_b b WHERE b. Make sure that you are blending on dimensions present in the view or on all of the. but no collectToAggregationThe SQL Language. And put both views on a dashboard. Output tables contain a single row with the aggregated value. Query expressions describe a value or a computation that can be used as part of an update, create, filter, order by, annotation, or aggregate. You can use aggregations in the analysis level calculated field. All arguments in calculated fields have to be single values or they all. Non-aggregate measures do not perform any aggregation and thus will not perform a double. Unsupported Aggregation while implementing filters from secondary datasource. By using the formula DAY([Endtimestamp]), you're changing the dimensionality a little bit. 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. Add a comment. But a filter or range gives org. Select Edit > New > DWORD Value . If a query asks for sales figures for Coke and Pepsi, the data should be returned from the aggregate table. 3 and I have created aggregates AGG for fields from data extract and excel file. bucket. The strange thing is running the query (the one that the Java API gives on a to string) through the REST endpoint works fine. CSS Error Loading. The rough equivalent would be using collect_set and array_join but note you have lost the order: %sql SELECT col1, array_join(collect_set(col2), ',') j FROM tmp GROUP BY col1 I do not think STRING_AGG guarantees order (unless you specify the WITHIN GROUP. I did that in your example too. With NAT, VPN, security, and QuWAN SD-WAN, network management is. 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 . ×Sorry to interrupt. 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. Multiple instances of same dimension. If I cant go the above way then is there a possibility to do the duration calculation using table calculations or some other way. NoDays >> * <<root. If possible try to join your data source another way is then use some table calculations like "IF FIRST()==0 THEN SIZE() END"I have linked 2 sources using 3 dimensions. The current aggregation appears as part of the measure's name in the view.