content/flux/v0/stdlib/universe/highestmax.md
highestMax() selects the record with the highest value in the specified column
from each input table and returns the highest n records.
Note: highestMax() drops empty tables.
(<-tables: stream[A], n: int, ?column: string, ?groupColumns: [string]) => stream[A] where A: Record
{{% caption %}} For more information, see Function type signatures. {{% /caption %}}
({{< req >}}) Number of records to return.
Column to evaluate. Default is _value.
List of columns to group by. Default is [].
Input data. Default is piped-forward data (<-).
import "sampledata"
sampledata.int()
|> highestMax(n: 2, groupColumns: ["tag"])
{{< expand-wrapper >}} {{% expand "View example input and output" %}}
| _time | _value | *tag |
|---|---|---|
| 2021-01-01T00:00:00Z | -2 | t1 |
| 2021-01-01T00:00:10Z | 10 | t1 |
| 2021-01-01T00:00:20Z | 7 | t1 |
| 2021-01-01T00:00:30Z | 17 | t1 |
| 2021-01-01T00:00:40Z | 15 | t1 |
| 2021-01-01T00:00:50Z | 4 | t1 |
| _time | _value | *tag |
|---|---|---|
| 2021-01-01T00:00:00Z | 19 | t2 |
| 2021-01-01T00:00:10Z | 4 | t2 |
| 2021-01-01T00:00:20Z | -3 | t2 |
| 2021-01-01T00:00:30Z | 19 | t2 |
| 2021-01-01T00:00:40Z | 13 | t2 |
| 2021-01-01T00:00:50Z | 1 | t2 |
| _time | _value | tag |
|---|---|---|
| 2021-01-01T00:00:00Z | 19 | t2 |
| 2021-01-01T00:00:30Z | 17 | t1 |
{{% /expand %}} {{< /expand-wrapper >}}