---
title: tickscript.groupBy() function
description: tickscript.groupBy() groups results by the _measurement column and other specified columns.
url: https://docs.influxdata.com/flux/v0/stdlib/contrib/bonitoo-io/tickscript/groupby/
estimated_tokens: 1456
product: Flux
version: v0
---

# tickscript.groupBy() function

-   Flux 0.111.0+
-   View InfluxDB support

`tickscript.groupBy()` is a user-contributed function maintained by the [package author](#package-author-and-maintainer).

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

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

**Note**: To group by time intervals, use `window()` or `tickscript.selectWindow()`.

##### Function type signature

```js
(<-tables: stream[A], columns: [string]) => stream[A] where A: Record
```

For more information, see [Function type signatures](/flux/v0/function-type-signatures/).

## Parameters

### columns

(Required) List of columns to group by.

### tables

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

## Examples

### Group by host and region

```js
import "contrib/bonitoo-io/tickscript"

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

[](#view-example-input-and-output)

View example input and output

#### Input data

| _time | _measurement | host | region | _field | _value |
| --- | --- | --- | --- | --- | --- |
| 2021-01-01T00:00:00Z | m | h1 | east | foo | 1.2 |
| 2021-01-01T00:01:00Z | m | h1 | east | foo | 3.4 |
| 2021-01-01T00:00:00Z | m | h2 | east | foo | 2.3 |
| 2021-01-01T00:01:00Z | m | h2 | east | foo | 5.6 |
| 2021-01-01T00:00:00Z | m | h3 | west | foo | 1.2 |
| 2021-01-01T00:01:00Z | m | h3 | west | foo | 3.4 |
| 2021-01-01T00:00:00Z | m | h4 | west | foo | 2.3 |
| 2021-01-01T00:01:00Z | m | h4 | west | foo | 5.6 |

#### Output data

| _time | *_measurement | *host | *region | _field | _value |
| --- | --- | --- | --- | --- | --- |
| 2021-01-01T00:00:00Z | m | h1 | east | foo | 1.2 |
| 2021-01-01T00:01:00Z | m | h1 | east | foo | 3.4 |

| _time | *_measurement | *host | *region | _field | _value |
| --- | --- | --- | --- | --- | --- |
| 2021-01-01T00:00:00Z | m | h2 | east | foo | 2.3 |
| 2021-01-01T00:01:00Z | m | h2 | east | foo | 5.6 |

| _time | *_measurement | *host | *region | _field | _value |
| --- | --- | --- | --- | --- | --- |
| 2021-01-01T00:00:00Z | m | h3 | west | foo | 1.2 |
| 2021-01-01T00:01:00Z | m | h3 | west | foo | 3.4 |

| _time | *_measurement | *host | *region | _field | _value |
| --- | --- | --- | --- | --- | --- |
| 2021-01-01T00:00:00Z | m | h4 | west | foo | 2.3 |
| 2021-01-01T00:01:00Z | m | h4 | west | foo | 5.6 |

#### Related

-   [Kapacitor QueryNode - groupBy](/kapacitor/v1/nodes/query_node/#groupby)

[transformations](/flux/v0/tags/transformations/)