Documentation

experimental.alignTime() function

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

experimental.alignTime() shifts time values in input tables to all start at a common start time.

Function type signature
(<-tables: stream[B], ?alignTo: A) => stream[C] where B: Record, C: Record

For more information, see Function type signatures.

Parameters

alignTo

Time to align tables to. Default is 1970-01-01T00:00:00Z.

tables

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

Examples

Compare month-over-month values

  1. Window data by calendar month creating two separate tables (one for January and one for February).
  2. Align tables to 2021-01-01T00:00:00Z.

Each output table represents data from a calendar month. When visualized, data is still grouped by month, but timestamps are aligned to a common start time and values can be compared by time.

import "experimental"

data
    |> window(every: 1mo)
    |> experimental.alignTime(alignTo: 2021-01-01T00:00:00Z)

View example input and output


Was this page helpful?

Thank you for your feedback!


The future of Flux

Flux is going into maintenance mode. You can continue using it as you currently are without any changes to your code.

Read more

New in InfluxDB 3.4

Key enhancements in InfluxDB 3.4 and the InfluxDB 3 Explorer 1.2.

See the Blog Post

InfluxDB 3.4 is now available for both Core and Enterprise, which introduces offline token generation for use in automated deployments and configurable license type selection that lets you bypass the interactive license prompt. InfluxDB 3 Explorer 1.2 is also available, which includes InfluxDB cache management and other new features.

For more information, check out: