...
Aggregation functions, also called facet functions, analytic functions, or metrics, calculate something interesting over a domain (each facet bucket).
| Code Block | ||||||
|---|---|---|---|---|---|---|
| ||||||
aggregation_function(field_name) |
List of aggregation functions:
| Aggregation function | Description | Example |
|---|---|---|
avg | Average of numeric values | avg(gerp) |
min | Minimum value | min(sift) |
max | Maximum value | max(caddScaled) |
unique | Number of unique values | unique(biotypes) |
hll | Distributed cardinality estimate via hyper-log-log algorithm | hll(type) |
percentile | Percentile estimates via t-digest algorithm. Calculate the percentiles: 1, 10, 25, 50, 75, 90 and 99th. | percentile(gerp) |
sumsq | Sum of squares of field or function | sumsq(caddRaw) |