truncateTimeColumn() function

Warning! This page documents an earlier version of Flux, which is no longer actively developed. Flux v0.65 is the most recent stable version of Flux.

The truncateTimeColumn() function truncates all input table _time values to a specified unit.

Function type: Transformation

truncateTimeColumn(unit: 1s)

Parameters

unit

The unit of time to truncate to.

Data type: Duration

Only use 1 and the unit of time to specify the unit. For example: 1s, 1m, 1h.

Examples

Truncate all time values to seconds
from(bucket:"telegraf/autogen")
  |> range(start:-1h)
  |> truncateTimeColumn(unit: 1s)

Function definition

import "date"

truncateTimeColumn = (unit, tables=<-) =>
  tables
    |> map(fn: (r) => ({
        r with _time: date.truncate(t: r._time, unit:unit)
      })
    )