Creating a time-indexed chart: Plotting by changes compared a time point
With time-indexed charts, you can explore how the data changes relative to a specified time. Records at this baseline time are set to 0, and changes in all records before and after are calculated in comparison to the baseline.
This plot type is commonly used to analyze stock market changes, since the profit & loss depends on changes in value compared to a specific point. Unlike with Excel, QlikView, PowerBI, Tableau, or Vega's manual approaches, you don't need to enter any complex formulas in Keshif to create time-indexed charts.
To create a time-indexed chart from time-series data,
- Create record chart panel (if not in dashboard),
- Select Time chart type (if time-chart is not visible),
- Open the record chart configuration panel (⚙icon), and
- Select # Change or % Change as the Timeseries Plot option, and
- Select the desired time key for comparison among the drop-down options (the Change Vs. option).
Special Features
- With a time-indexed chart enabled, time-series chart pop-ups show the relative change of the selected record(s) compared to the baseline time.
Constraints
- Time-indexed charts are not available for time-series data with negative values.