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
- Open the chart configuration panel, and
- Select #-Change or %-Change as Timeseries Plot option.
- Then, select the desired time key for comparison among dropdown options.
- 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.
- Time-indexed charts are not available for time-series data with negative values.