experimental.alignTime() function

experimental.alignTime() is subject to change at any time. By using this function, you accept the risks of experimental functions.

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.



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


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


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"

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

View example input and ouput

Was this page helpful?

Thank you for your feedback!

Upgrade to InfluxDB Cloud or InfluxDB 2.0!

InfluxDB Cloud and InfluxDB OSS 2.0 ready for production.