experimental.count() function

experimental.count() is subject to change at any time.

experimental.count() returns the number of records in each input table.

The count is returned in the _value column and counts both null and non-null records.

Counts on empty tables

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

filter(onEmpty: "keep")
window(createEmpty: true)
aggregateWindow(createEmpty: true)
Function type signature
(<-tables: stream[{A with _value: B}]) => stream[{A with _value: int}]
For more information, see Function type signatures.



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


Count the number of rows in a table

import "experimental"
import "sampledata"
    |> experimental.count()

View example input and output

Was this page helpful?

Thank you for your feedback!

Upgrade to InfluxDB Cloud or InfluxDB 2.0!

InfluxDB Cloud and InfluxDB OSS 2.0 ready for production.