Documentation

experimental.count() function

Flux 0.107.0+

The experimental.count() function is subject to change at any time. By using this function, you accept the risks of experimental functions.

The experimental.count() function outputs the number of records in each input table and returns the count in the _value column. This function counts both null and non-null records. experimental.count() is an aggregate function.

import "experimental"

experimental.count()

Empty tables

experimental.count() returns 0 for empty tables. To keep empty tables in your data, set the following parameters for the following functions:

Function Parameter
filter() onEmpty: "keep"
window() createEmpty: true
aggregateWindow() createEmpty: true

Parameters

tables

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

Examples

import "experimental"

from(bucket: "example-bucket")
  |> range(start: -5m)
  |> experimental.count()

Upgrade to InfluxDB Cloud or InfluxDB 2.0!

InfluxDB Cloud and InfluxDB OSS 2.0 ready for production.