Skip to Content

Chart types

Set up a time series chart

Plot measures over real dates, grouped by day, week, month, quarter or year.

Plot measures on a real time axis. Gaps between dates keep their true size.

What the data needs

DimensionsMeasures
1 date or time column, for example created_at1 or more

Steps

  1. Add the date field to Dimensions.

  2. Add one or more fields to Measures.

  3. In the chart toolbar, select Chart type, then Time Series.

    Chart type picker in the metric builder with the Time Series tile highlighted
    Time Series in the Chart type picker.
  4. Select Appearance, then open Features.

  5. In Series type, choose Line, Bar, Area, Stack or Combo.

    Features section of a Time Series chart with the Series type list open showing Line, Bar, Area, Stack and Combo
    Series type is in the Time series block of Features.
  6. In Format type, choose Daily, Weekly, Monthly, Quarterly or Yearly.

The chart groups your data by the time period you chose.

Settings for this chart

  • Group format: Default, Dynamic or Filter.
  • Fill X-axis: fill in missing months or dates.
  • Current line and Dashed line.
  • Chart legend has Future legend.
  • With Combo as the series type, Combo chart settings shows. Combo charts

Drill down does not work on a Time Series chart. Forecast is not offered for it.

If something goes wrong

  • Time Series does nothing when you select it. The metric has no date column. Add a date or time field to Dimensions.

Next: change how the chart looks.