...
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 a
...
transform step to reshape the data.
Aggregate across an entire column:
d- |
---|
...
Code Block |
---|
derive type:single value: |
...
AVERAGE(Scores) |
...
Output: Generates a new column containing the average of all values in the Scores
column.
d- |
---|
...
Code Block |
---|
pivot value: |
...
AVERAGE(Score) limit: 1 |
p01NameValuesp01Valueaverage(Score)p02NameMax number of columns to createp02Value1SearchTermPivot columnsOutput: Generates a single-column table with a single value, which contains the average of all values in the Scores
column. The limit defines the maximum number of columns that can be generated.
Info |
---|
NOTE: When aggregate functions are applied as part of a |
...
Aggregate functions can be used with the the pivot
transformation transform to change the structure of your data. Example:
d- |
---|
...
Code Block |
---|
pivot group: StudentId value: |
...
AVERAGE(Score) limit: 1 |
p01NameRow labelsp01ValueStudentIdp02NameValuesp02Valueaverage(Score)p03NameMax number of columns to createSearchTermPivot columnsIn the above instance, the resulting dataset contains two columns:
...
Info |
---|
NOTE: You cannot use aggregate functions inside of conditionals that evaluate to |
A pivot Pivot Table transformation can can include multiple aggregate functions and group columns from the pre-aggregate dataset.
For more information on the transformationtransform, see Pivot Data.
Info |
---|
NOTE: Null values are ignored as inputs to these functions. |
These These aggregate functions are available:
...