Selects the event with the minimum value in the specified field. Only the included fields will be present in the resulting event. If multiple events have the same minimum value, then it is non-deterministic which event will be selected.
| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
field | string | true | The name of the field that is used to find the minimum value. | |
include | [string] | true | The names of the fields to include in the generated event. |
Examples
Find the first value of a field x (and when that
value was from).
Try
humio
selectFromMin(@timestamp, include=[x, @timestamp])
This selects the event with minimum value of
@timestamp that also contains the specified field
x, and returns an event with fields
@timestamp and x only.