Documentation

experimental.mode() function

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

experimental.mode() computes the mode or value that occurs most often in the _value column in each input table.

experimental.mode only considers non-null values. If there are multiple modes, it returns all modes in a sorted table. If there is no mode, it returns null.

Supported types

  • string
  • float
  • int
  • uint
  • bool
  • time
Function type signature
(<-tables: stream[{A with _value: B}]) => stream[{A with _value: B}]
For more information, see Function type signatures.

Parameters

tables

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

Examples

Compute the mode of input tables

import "experimental"
import "sampledata"

sampledata.int()
    |> experimental.mode()

View example input and output


Was this page helpful?

Thank you for your feedback!


Linux Package Signing Key Rotation

All signed InfluxData Linux packages have been resigned with an updated key. If using Linux, you may need to update your package configuration to continue to download and verify InfluxData software packages.

For more information, see the Linux Package Signing Key Rotation blog post.