experimental.count() function

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.

Function type: Aggregate
Output data type: Integer

import "experimental"


Empty tables

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

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


import "experimental"

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

Cloud or OSS?

InfluxDB OSS 2.0 now generally available!

InfluxDB OSS 2.0 is now generally available and ready for production use. See the InfluxDB OSS 2.0 release notes.

For information about upgrading to InfluxDB OSS 2.0, see: