lowestAverage() function

The lowestAverage() function calculates the average of each table in the input stream returns the lowest n records. The function outputs a single aggregated table containing n records. lowestAverage() is a selector function.

lowestAverage(
  n:10,
  column: "_value",
  groupColumns: []
)

Parameters

n

Number of records to return.

column

Column by which to sort. Default is "_value".

groupColumns

The columns on which to group before performing the aggregation. Default is [].

tables

Input data. Default is piped-forward data (<-).

Examples

The following example uses data provided by the sampledata package to show how lowestAverage() transforms data.

import "sampledata"

sampledata.int()
  |> lowestAverage(n: 2, groupColumns: ["tag"])