Registered users of this product or Trifacta Wrangler Enterprise should login to Product Docs through the application.
Aggregate functions perform a computation against a set of values to generate a single result. For example, you could use an aggregate function to compute the average (mean) order over a period of time. Aggregations can be applied as standard functions or used as part of an
aggregate transform to reshape the data.
Aggregate across an entire column:Output: Generates a new column containing the average of all values in the
Output: Generates a single-column table with a single value, which contains the average of all values in the
NOTE: When aggregate functions are applied as part of an
aggregate transform, they typically involve multiple parameters as part of an operation to reshape the dataset. See below.
Aggregate across groups of values within a column:
Aggregate functions can be used with the
aggregate transform to change the structure of your data. Example:
In the above instance, the resulting dataset contains two columns:
studentId- one row for each distinct student ID value
average_Scores- average score by each student (
An aggregate transform can include multiple aggregate functions and group columns from the pre-aggregate dataset.
For more information on the transform, see Aggregate Transform.
These aggregate functions are available:
- ANY Function
- ANYIF Function
- AVERAGE Function
- AVERAGEIF Function
- COUNTA Function
- COUNTAIF Function
- COUNTDISTINCT Function
- COUNTDISTINCTIF Function
- COUNT Function
- COUNTIF Function
- KTHLARGEST Function
- KTHLARGESTIF Function
- LIST Function
- LISTIF Function
- MAX Function
- MAXIF Function
- MIN Function
- MINIF Function
- STDEV Function
- STDEVIF Function
- SUM Function
- SUMIF Function
- VAR Function
- VARIF Function
This page has no comments.