Influxdata
/
docs-v2
mirror of https://github.com/influxdata/docs-v2.git
1
0
Fork 0
Code Issues Projects Releases Wiki Activity
docs-v2/content/flux/v0.x/stdlib/contrib/bonitoo-io/tickscript/groupby.md

1.4 KiB
Raw Permalink Blame History

title description menu weight aliases related flux/v0.x/tags
tickscript.groupBy() function The `tickscript.groupBy()` function groups results by the `_measurement` column and other specified columns.
flux_0_x_ref
name parent
tickscript.groupBy tickscript
302
/influxdb/v2.0/reference/flux/stdlib/contrib/tickscript/groupby/
/influxdb/cloud/reference/flux/stdlib/contrib/tickscript/groupby/
/{{< latest "kapacitor" >}}/nodes/query_node/#groupby, Kapacitor QueryNode - groupBy
transformations

The tickscript.groupBy() function groups results by the _measurement column and other specified columns.

This function is comparable to [Kapacitor QueryNode .groupBy](/{{< latest "kapacitor" >}}/nodes/query_node/#groupby).

{{% note %}} To group by intervals of time, use window() or tickscript.selectWindow(). {{% /note %}}

import "contrib/bonitoo-io/tickscript"

tickscript.groupBy(columns: ["exampleColumn"])

Parameters

columns

({{< req >}}) List of columns to group by.

tables

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

Examples

Group by host and region
import "contrib/bonitoo-io/tickscript"

data
    |> tickscript.groupBy(columns: ["host", "region"])