Docs

v2.0

filter() function

The filter() function filters data based on conditions defined in a predicate function (fn). The output tables have the same schema as the corresponding input tables.

Function type: Transformation
Output data type: Object

filter(fn: (r) => r._measurement == "cpu")

Parameters

fn

A single argument function that evaluates true or false. Records are passed to the function. Those that evaluate to true are included in the output tables.

Data type: Function

Objects evaluated in fn functions are represented by r, short for “record” or “row”.

Examples

from(bucket:"telegraf/autogen")
  |> range(start:-1h)
  |> filter(fn: (r) =>
    r._measurement == "cpu" and
    r._field == "usage_system" and
    r.cpu == "cpu-total"
  )

SELECT


Bug Reports and Feedback

Thank you for being willing to help test InfluxDB v2.0 alpha! Feedback and bug reports are welcome and encouraged both for InfluxDB and this documentation.

Submit feedback in the InfluxData Community