distinct() function
The distinct()
function returns the unique values for a given column.
The _value
of each output record is set to the distinct value in the specified column.
null
is considered its own distinct value if it is present.
Function type: Selector
Output data type: Record
distinct(column: "host")
Empty tables
distinct()
drops empty tables.
Parameters
column
Column on which to track unique values.
Data type: string
Examples
from(bucket: "example-bucket")
|> range(start: -5m)
|> filter(fn: (r) => r._measurement == "cpu")
|> distinct(column: "host")
Support and feedback
Thank you for being part of our community! We welcome and encourage your feedback and bug reports for InfluxDB and this documentation. To find support, the following resources are available:
InfluxDB Cloud and InfluxDB Enterprise customers can contact InfluxData Support.