bucket-with-outliers
numeric →
bucket-with-outliers(
minimum: numeric,
maximum: numeric,
count: integer
) → integer
Classifies a numeric value into an equal-width bucket, using additional buckets for values below and above the configured interval. Returns null when the bucket configuration is invalid.
Parameters
| Name | Type | Required | Description |
|---|---|---|---|
minimum | numeric | Yes | Inclusive lower bound of the classified interval. |
maximum | numeric | Yes | Exclusive upper bound of the classified interval. |
count | integer | Yes | Strictly positive number of equal-width in-range buckets. |
Argument evaluation
minimum: Evaluated once in the enclosing context.maximum: Evaluated once in the enclosing context.count: Evaluated once in the enclosing context.
Examples
2500 | bucket-with-outliers(5000, 20000, 3) → 0
22500 | bucket-with-outliers(5000, 20000, 3) → 4
Kind: Function
Scope: numeric/classification
Aliases: None