tickscript.select() function

The tickscript.select() function changes a column’s name and optionally applies an aggregate or selector function to values in the column.

import "contrib/bonitoo-io/tickscript"

tickscript.select(
  column: "_value",
  fn: sum,
  as: "example-name"
)

TICKscript helper function

tickscript.select() is a helper function meant to replicate TICKscript operations like the following:

// Rename
query("SELECT x AS y")

// Aggregate and rename
query("SELECT f(x) AS y")

Parameters

column

Column to operate on. Default is _value.

Data type: String

fn

Aggregate or selector function to apply.

Data type: Function

as

(Required) New column name.

Data type: String

Examples

• Change the name of the value column
• Change the name of the value column and apply an aggregate function
• Change the name of the value column and apply a selector function

Change the name of the value column

import "contrib/bonitoo-io/tickscript"

data
  |> tickscript.select(as: "example-name")

Change the name of the value column and apply an aggregate function

import "contrib/bonitoo-io/tickscript"

data
  |> tickscript.select(
    as: "sum",
    fn: sum
  )

Change the name of the value column and apply a selector function

import "contrib/bonitoo-io/tickscript"

data
  |> tickscript.select(
    as: "max",
    fn: max
  )