really need to see your twbx file to be of further help. With LAC-A functions, you can specify at what level to group the computation. "Cannot blend the secondary data source because one or more fields use an unsupported aggregation. Credits to Jonathan Drummey for the below workaround Cannot blend the secondary data source because one or more fields use an unsupported aggregation . I tried using Excel as the primary and I kept getting errors when I tried to add the cube. 0", "0x6400") or a value that falls outside the minimum and maximum value for an integer. Unsupported Aggregation means that the action requested at one of the sources or the act of bringing them together can not be done - in your case you have used a table calculation to determine a performance score - Table calculations are performed on the underlying table for a specific worksheet and can not be carried or transferred from one. I thought about using a parameter but you cant search with a parameter in a prompt, on the other charts that are like this there are hundreds on items. In the LACP section, click the +NEW symbol to create a new LAG. For example, you would not be able to use a measure with the expression <<root. SQLSTATE: none assigned. 1. See Join Your Data for more information. 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. 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. These dimensions were also used as filters in the particular sheet. For more information, see Troubleshoot. Learn more about Collectives Teams. The ARRAY_CONTAINS method requires a second parameter to use in GROUP BY clause which I think will take 1 reason at a time. 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. To indicate a cursor with the default batch size, specify cursor: {}. Restrictions. image 959×146 4. Hello Jim, Thank You for your reply. You can choose whether functional and advertising cookies apply. Hi. person = a. Ask Question Asked 3. The aggregate arguments cannot contain references to tables other than the PIVOT input table. Learn more about Collectives. I created a parameter with a simple calculated field so that I may toggle between two measures. Can't see what you are actually doing but Blending data has its limits. A value greater than 0 treats a grade item's grades as extra credit during aggregation. There are two types of calculated fields: on a data set level and on on analysis level. Data blending has some limitations regarding non-additive aggregates such as COUNTD, MEDIAN, and RAWSQLAGG. Is there a way to do it in a single query like in. I've tried that in the past, and I was always blocked by the unsupported aggregation message. Copy link Member. Click on the different cookie categories to find out more about each category and to change the default settings. Cannot blend the secondary data source because one or more fields use. Use a derived table to nest aggregations or double aggregate. JimI have linked 2 sources using 3 dimensions. The workaround for this is that if you have to use one of the non-additive aggregates, use DB1 blending, i. 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. 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 each partition. Instead of processing the strings in application code, you can use the aggregation string operators to push the data processing down to the database. Non-additive aggregates are aggregate functions that produce results that cannot be aggregated along a dimension. Jim. But is there any other way around? Please help me in this regard, thanks, KalyanLocal Cumulative Computation makes the Process more Efficient. Often the best solution is to rewrite your SELECT without using a correlated sub-query at all. 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". NoDays >> * <<root. You can choose whether functional and advertising cookies apply. I'm trying to get the total of the secondary data source field irreHi. In the actual data I get the error: Cannot blend the secondary data source because one or more fields use an unsupported aggregation. 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. countD requires row-level access to the data, not just aggregate access. The version I am working with 10. pindahan='no' and tahun. 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. When using the function, the data types and order of the expressions must match that of the input arguments. . s3. I was now trying to use both calculations you did on a different sheet through data blending. unsupported aggregation. These expression operators are available to construct expressions for use in the aggregation pipeline stages. This page has an error. See Join Your Data for more information. You can choose whether functional and advertising cookies apply. To resolve this, use FIRST (). 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. In . In general, these expressions take an. Open the Format as HTML Pro step and go to the Data tab. 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. ×Sorry to interrupt. You can use aggregations in the analysis level calculated field. 3 and I have created aggregates AGG for fields from data extract and excel file. 4, MongoDB supports faceted classification by using the Aggregation Framework. We are blending two data sources. Innovate fast at scale with a unified developer experienceIn blending data source, I try to slove problem but I can't. All rights reserved. id=(select max(id) from tahun) ShareTo use concat with spark window function you need to use user defined aggregate function (UDAF). Cannot blend the secondary data source because one or more fields use an unsupported aggregation. Currency measure vs. PaulYou can still use the field with COUNTD() from the secondary data source if you remove all dimensions from the secondary data source (i. The problem is when I try to calculate the median of that same measure. Had a chance to test it, and it seems to work in both py2 and py3. To achieve this you need to add Calculated Field to an Analysis ( as described here ). I would like to visualize number of distinct hardware. 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. Creating the flags in your query is best done with CTEs using a separate section for each of your module flags so you don’t. For example am having column called "Name" in my first data source, in second data sources am having column called "F Name". if [created at] = { fixed [branch id]: max ( [created at])} Then [branch id] end. 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. We use three kinds of cookies on our websites: required, functional, and advertising. Documentation on relationship: Relate Your Data - Tableau. 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. Loading. The current aggregation appear as a part of the measures name in the view. 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,. 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. on Rows, Columns, Pages, or the Marks Card. SQLSTATE: none assigned. Here is a slimmed down version what I'm trying to do. To define a new aggregate function, one selects a data type for the state value, an. g. Click on the different cookie categories to find out more about each category and to change the default settings. There are some data blending limitations around non-additive aggregates, such as COUNTD, MEDIAN, and RAWSQLAGG. I did that in your example too. Go to a new worksheet. The issue was that the bucket sensor that I had previously defined in my telegraf. additional request properties set programmatically. If if this is the case, you could try creating a calculation for. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. ) Two approaches to consider: 1) Make your Stores data source your primary data source. r. Expand Post. I'm noticing you are using the Date field from the secondary data source you are working with. A. addShard () addShardToZone. In my workbook I will be using two statistical geographies, LSOA and MSOAs. ElasticsearchException: [es/search] failed: [x_content_parse_exception] [1:44] [composite] unknown field [name] Here is my. The following query. In the opened dialog, you select ODBC DSN and click Next to continue. You use the aggregation type to control how a key figure or. Golang mongodb Aggregation too many values in. A value greater than 0 treats a grade item's grades as extra credit during aggregation. Add a comment. Yes, the near operator isn't very well supported by sigmac. Ask Question Asked 3. 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 . CSS ErrorLoading. For example, see Text Search in the Aggregation Pipeline. 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. We use three kinds of cookies on our websites: required, functional, and advertising. 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. Fundamentalmente son espacios privados,. You can use the variable REMOVE in aggregation expressions to conditionally suppress a field. category = c. Cannot blend the secondary data source because one or more fields use. 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. 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. yarn logs, however, uses the AbstractFileSystem interface. The primary. Norbert, I'm baffled. 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. 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. NoDays >> * <<root. This property guarantees that partial aggregation. The second method, which is new to 11. Use a Join instead of Blending: If blending is not necessary for your analysis, you can try joining the data sources instead. Some databases has a pivot function but if you are using one without that function, then you will need to use an aggregate function with a CASE expression: select lineid, max (case when question ='Height' then answer else '' end) Height, max (case when question ='Outside Color' then answer else '' end) [Outside Color] from yourtable group. 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. To learn more about the Document type, see Documents. We use three kinds of cookies on our websites: required, functional, and advertising. Best, Paul. Loading. And I want to add one of the field from secondary dataset to be in the filter. name from t1 t inner join category c on t. Select the visualization type you want to create. You can choose whether functional and advertising cookies apply. Elasticsearch organizes aggregations into three categories: Metric aggregations that calculate metrics, such as a sum or average, from field values. This function is intended to be used when timeColumn ( _time by default) is not in the group key. I’ve created this post in order to share my workaround for bringing over a Count Distinct (COUNTD) from a secondary data source. CSS ErrorIf I create my calculated field without using an aggregation with {Profit}, QuickSight doesn’t know from which row to get the value. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. //Extend UserDefinedAggregateFunction to write custom aggregate function //You can also specify any constructor arguments. 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. Hi Folks, I am trying to solve a typical requirement (at least for me ). unsupported aggregation. Unsupported aggregation in secondary data source using an LOD expression. The steps are. Most of the KPI's are straight forward to aggregate and compare but AVG FLEET requires the use of LOD expressions. I know that count distinct can not be used in the data blending. You should wait for the next scheduled. Supported and Unsupported Aggregation Pipeline Stages. (See Section 3. Cannot blend the secondary data source because one or more fields use. This section describes the summary, or aggregation, functions that are available in IBM® Cognos® Analytics - Reporting. Tommy Sims (Member) 7 years ago. Click the Networking 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. THEN add this total to the SUM of the projected_users from today's date through month X. Send us feedback | Privacy. If there is another aggregation type such as AGG_AVG being used, change it to one of the supported aggregation listed. Function to use for aggregating the data. The one drawback is that DB2 blending does not support "non-additive aggregates" like COUNTD() and MEDIAN(). (Ditto the FIXED countD. ERROR 2346: Cannot alter a sequence with START. I made a calc that mimicked your group, and if I use that on colors, the sheet works as you want. Shell Method. also if you are only looking for a single value to be filtered you could use a parameter and filter the. Example(cannot blend the secondary data source because one or more fields use an unsupported aggregation) If i select without distinct, it's ok (but not what I want. You can choose whether functional and advertising cookies apply. Solution. "-5. PIVOT supports the COUNT, SUM, MIN, MAX, and AVG aggregate functions. Loading. The version I am working with 10. Option 2: Rewrite your SELECT without a Correlated Subquery. But the source calc is a countD. CSS ErrorI'd like to always use D1 except when it is NULL and then I'd like to use D2. 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. Thus I have this calc below . calculated. If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the. Claims Paid for Treatment and Testing. 1 Unable to use aggregate function in. Just aggregates (like SUM, MIN, MAX. Sum, average, and median are common aggregations; for a complete list, see List of Predefined Aggregations in Tableau. Hi All, I have blended primary and secondary data sources. 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 . Each output table from an aggregate function will: Contain a single record. 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. CallTime Avg (internal)>> because CallTime Avg (internal) is interpreted as being. Click on the different cookie categories to find out more about each category and to change the default settings. I am trying to use the below formula instead of countd function because my data comes from Impala. Click anywhere on the Field wells to expand them. In the Data pane, double-click a spatial field. 9 KB. 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. To resolve this, use FIRST (). Use aggregation instead. The PIVOT aggregate expression has to be a call of a supported aggregate function. Data blending has some limitations regarding non-additive aggregates such as COUNTD, MEDIAN, and RAWSQLAGG. 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. what I understood from my network colleague concept of LACP. 1. ” Its important to view the data using all the . in telegraf. I put a twb file. Click on the different cookie categories to find out more about each category and to change the default settings. I've read through the various posts on here, plus the general troubleshooting posts on the Tableau page on blending data, but can't find a solution. I receive this error: "Cannot blend the data source because one or more fields uses an unsupported aggregation". Use expressions to define the values that are sent from Tableau to the analytics model. It is now possible in Amazon QuickSight. I've tried that in the past, and I was always blocked by the unsupported aggregation message. Step 3: Create assignment or drag & drop key figure in target. Connect and share knowledge within a single location that is structured and easy to search. 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. This should explain why when you are using the SUM aggregation it works. Parameters: funcfunction, str, list, dict or None. 1. Unsupported aggregate subquery with non-equality correlated predicates. 0. Hi all. keep the dimensions in the view. using select. For example, if the aggregate rule for QI_a is set to sum, and the. 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. 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. First, let’s start with a simple example of a Structured Streaming query - a streaming word count. Connecting Excel to MySQL with Data Connection Wizard (Legacy Wizard) Start a new worksheet. It is now possible in Amazon QuickSight. When an expression outputs a boolean value, it may be used directly in filters. Resolution. Like most other relational database products, PostgreSQL supports aggregate functions. 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 . Aggregate transformations output a table for every input table they receive. Step 3: Changing the Default Measures for Aggregation in Tableau. LOD expressions are used when running complex queries with multiple dimensions at the data source level. ” Causes and Workarounds for a Blending Limitation Errors 1. ×Sorry to interrupt. C. but no collectToAggregationThe SQL Language. CompanyID =. {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. Wrap the Total KMs formula in: IF FIRST ()=0 THEN [Total KMs] END. Windowed aggregations partition the results from a SQL query into groups in order to perform calculations across adjacent rows of the query result. You might just need to refresh it. Data blending has some limitations regarding non-additive aggregates such as COUNTD, MEDIAN and. e. AbstractFileSystem. ERROR 2230: Arguments of row IN must all be row expressions. When double-clicked, it is automatically added to Detail on the Marks card and a map view is created. ELSE D1. If I cant go the above way then is there a possibility to do the duration calculation using table calculations or some other way. 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. Hello. CSS Error Loading. Change the aggregation of a measure in View. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. Cut out the three explanatory lines at the top (can be done with regex) Run a regex replace on the file (I’ve used . conf already had the field temperature created in my influx database from previous tries with its type set as last. Set the table calculation to COMPUTE USING using the KM Date field. You can choose whether functional and advertising cookies. Log “Unsupported aggregation type [{}]” class name is Pivot. The result now should be correct BUT it'll return the result multiple times, once for each date. MULTI_SOURCES_UNSUPPORTED_FOR_EXPRESSION. Use range () to assign _start and _stop values. By using the formula DAY([Endtimestamp]), you're changing the dimensionality a little bit. Cannot Blend Secondary Data Source - Unsupported Aggregation. The primary one is called Dim_Service_Status. Step 6: Activate Composite Provider and you won’t see any warnings. ) 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. Click on the different cookie categories to find out more about each category and to change the default settings. CSS ErrorOpen the Format as HTML Pro step and go to the Data tab. Hi everyone, I'm trying to blend two data sources on a single field, say 'Program Description'. We use three kinds of cookies on our websites: required, functional, and advertising. In this example, Geog_School is used. Because in Tableau, you don't use COUNTD function when Blending data source. g. Use a Join instead of Blending: If blending is not necessary for your analysis, you can try joining the data sources instead. Is the restriction on LOD expressions true even if. How to do mongo aggregation. 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. If you then need to flatten the response for use in your visualisation this flattening will need to be done client side. _types. You can specify collation for a collection or a view, an index, or specific operations that support collation. This happens only when the data sources are impala. And put both views on a dashboard. They both share a common field (State), and that is what I'm filtering on. B. Hello I am having a problem with the relationship between two data sources. 1 MongoDB Aggregate shows no result. Hello Everyone, I am unable to sum an aggregate function. elastic. I've created the first chart with no problem, but I. In find, you cannot specify a query condition on the text score. Norbert, I'm baffled. 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)). Filter each of the data sources independently on the more granular dimensions. 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. If you need to use an unsupported operation in an aggregation, you must define the entire expression using the BSON Document type. 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. The expression <expr> does not support more than one source. Extract and aggregate: Take an extract of your data and aggregate it based on the occurrences of Dimension X. Select the data source you want to visualize. To achieve this you need to add Calculated Field to an Analysis ( as described here ). All arguments in calculated fields have to be single values or they all. Can anyone offer a solution? The total headcounts is a calculated field on datasource2, in case that helps. Add the ’ [‘ open-square-brackets to the beginning and ‘]’ close-square-brackets to the end. filter. 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. ) to such a degree that you need table calcs to re-aggregate to get to the desired granularity of the display. Thanks. Tableau allows changing the aggregation of a field for specific use in the worksheet. Step 2: Build the map. Create a calculated field, with some business logic, to choose which to show in the case of multiple. status='terima' and daftar. Got same expected results in both py2 and. I did that in your example too. 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. 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. aggregateWindow () requires _start and _stop columns in input data. elasticsearch. Step 2: Setting the Default Aggregation for a Measure in Tableau. In find, you cannot specify a query condition on the text score. Two time points but no time interval. There are three conditions under which we can't use a non-additive aggregate (COUNTD, MEDIAN, RAWSQL) when. Another table is a a table that contains key fields such as date, region, location and hardware id (dimension). Aggregate the dimension to show only the MIN or MAX value. Hadoop provides two fs interfaces - FileSystem and AbstractFileSystem. I have two datasets; one is a shape file that contains regions and locations. For example am having column called "Name" in my first data source, in second data sources am having column called "F Name". Use SIZE (): This is similar to #1, but provides a better visual and is more flexible with other analyses. On the field well menu, choose Aggregate, then choose the aggregate function that you want to apply. We use three kinds of cookies on our websites: required, functional, and advertising. Click on the different cookie categories to find out more about each category and. cannot blend the secondary data source because one or more fields use an unsupported aggregation. M". Unsupported Aggregation while implementing filters from secondary datasource. Hello. I’ve found a couple examples in the forums. unsupported aggregation. We use three kinds of cookies on our websites: required, functional, and advertising. If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the. t Link Aggregation. 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. e. ×Sorry to interrupt. We use three kinds of cookies on our websites: required, functional, and advertising. Tableau Tip 5. There is now a considerable number of published reviews that claim to follow the JBI approach to meta-aggregation. Step 5: Change “Association With” from “InfoObject” to “Nothing”. 5 and Section 4. Using Tableau. For more information on blends, check this out: Blend Your Data - Tableau . 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. Instead of blending multiple data sources, create one data source that joins all of the data using either physical or logical joins. 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. We use three kinds of cookies on our websites: required, functional, and advertising. ×Sorry to interrupt. An introduction to windowed aggregations. 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. (You need to get individual row access to evaluate DISTINCT functionality. At this time the only use case that I run into (for me and the folks that I help out) for data. By using the formula DAY([Endtimestamp]), you're changing the dimensionality a little bit. There are corresponding countToAggregation , countDistinctToAggregation etc. Aggregate using one or more operations over the specified axis.