Skip to main content

Time Series

Time series is a core capability across Columns connectors.

Quick demo: Time Series

Enable Time Series​

When your dataset includes a time column, enable time-series mode during connection setup.

Supported format families include:

  1. US date (M/d/yy, MM/dd/yy)
  2. US full date (M/d/yyyy, MM/dd/yyyy)
  3. US date+minute
  4. US datetime
  5. US full datetime
  6. ISO date (yyyy-MM-dd)
  7. ISO datetime (yyyy-MM-dd HH:mm:ss)
  8. ISO timestamps (yyyy-MM-dd'T'HH:mm:ss...)

Common examples:

  1. 1/2/22
  2. 1/2/2022
  3. 1/2/22 9:08
  4. 1/2/22 14:22:30
  5. 1/2/2022 14:22:30
  6. 2021-03-12
  7. 2021-03-12 15:32:45
  8. 2021-01-01T20:07:08.595Z
  9. 2021-11-11T04:08:23-09:00

Continuous vs Bounded Time​

Timeline aggregation modes:

  • Continuous: fixed-width rolling windows
  • Bounded: calendar-aligned buckets (day, week, month, quarter, year)

Time series settings

Use bounded mode for most reporting scenarios, and continuous mode for moving-window analysis.

Forecast​

Columns also supports built-in forecasting on timeline charts. See Timeline for details.