schema.fieldaggregateoperation.md
November 8, 2023 ยท View on GitHub
Home > @datashaper/schema > FieldAggregateOperation
FieldAggregateOperation enum
This is the subset of aggregate functions that can operate on a single field so we don't accommodate additional args. See https://uwdata.github.io/arquero/api/op\#aggregate-functions
Signature:
export declare enum FieldAggregateOperation
Enumeration Members
| Member | Value | Description |
|---|---|---|
| Any | "any" | Select any value. Implementation-dependent - this could be random, the first found, etc. |
| Count | "count" | Count the number of values |
| CountDistinct | "distinct" | Count the number of unique values |
| CreateArray | "array_agg" | Collect all of the values into an array |
| CreateArrayDistinct | "array_agg_distinct" | Collect all of the unique values into an array |
| Invalid | "invalid" | Count only the valid values |
| Max | "max" | Find the max value |
| Mean | "mean" | Compute the mean of the values |
| Median | "median" | Compute the median of the values |
| Min | "min" | Find the min value |
| Mode | "mode" | Compute the mode of the values |
| Product | "product" | Compute the product of the values |
| StandardDeviation | "stdev" | Compute the standard deviation of the values |
| StandardDeviationPopulation | "stdevp" | Compute the population standard deviation of the values |
| Sum | "sum" | Sum the values |
| Valid | "valid" | Count only the valid (non-null, non-error) values |
| Variance | "variance" | Compute the variance of the values |