MashZone NextGen 10.2 | Appendix | Operators | Data transformation operators | Aggregate | Aggregation type
 
Aggregation type
The following aggregation operations can be applied to the columns to be aggregated.
Data type
Comparison operators
Minimum
Finds all rows that have a particular combination of values in the dimension columns and returns the lowest value that occurs in these rows in the column to be aggregated.
Maximum
Finds all rows that have a particular combination of values in the dimension columns and returns the highest value that occurs in these rows in the column to be aggregated.
Average value
Finds all rows that have a particular combination of values in the dimension columns and returns the average of the values in the column to be aggregated. For weighting purposes, an additional column can be specified for each source column, containing a weighting factor for each row. The weighting information is combined as a pair with the source column.
Sum
Finds all rows that have a particular combination of values in the dimension columns and returns the sum of the values in the column to be aggregated. For weighting, an additional column can be specified for each source column, containing a weighting factor for each row. The weighting information is combined as a pair with the source column.
Count
Finds all rows that have a particular combination of values in the dimension columns and returns the count of values in the column to be aggregated.
First row
Finds all rows that have a particular combination of values in the dimension columns and returns the value of the row with the lowest row index (according to the index column).
Last row
Finds all rows that have a particular combination of values in the dimension columns and returns the value of the row with the highest row index (according to the index column).
At least one dimension or aggregation column, or both, must be set.
If no aggregation columns or dimension columns are specified, the incoming table remains unchanged.

Copyright © 2013-2018 | Software AG, Darmstadt, Germany and/or Software AG USA, Inc., Reston, VA, USA, and/or its subsidiaries and/or its affiliates and/or their licensors.
Innovation Release