Creating a time-indexed chart: Plotting by changes compared a time point

With time-indexed charts (plotting by changes compared to a time point), you can explore how the data changes relatively over a specific time. The values of all records at this time is set to 0 (baseline), and the records extend before and after compared to this baseline. 

This plot type is commonly used in analyze stock market changes (how much a set of stocks increased/decreased over time), since the profit/loss depends on value change compared to a specific point. Unlike with Excel, QlikView, PowerBI, Tableau, or Vega's manual approaches, you don't need to enter any complex formulations in Keshif to create time-indexed charts.


To create a time-indexed from time-series data, create/switch to record time-series chart, and

  1. Open the chart configuration panel, and
  2. Select #-Change or %-Change as Timeseries Plot option.
  3. Then, select the desired time key for comparison among dropdown options.

Special Features

  • With time-indexed chart enable, time-series chart tooltips show the relative change of the selected record(s) compared to this fixed time, giving you the context you need to better understand your data.

Constraints

  • Time-indexed charts are not available for time-series data with negative values.