Time-aware Ranges

Welcome to the Timeline docs. Here you can find all the information you need to get started with Timeline.

Time-aware Range

A time-aware range is a range of previous values of a cell. We can retrieve a time-aware range of a cell by using a similar syntax as for time-aware cells, however, we specify two indexes of the time-aware range.

= B2[-5:-10]

In this example, we retrieve five previous values of B2, starting from the fifth step backwards to the tenth step backwards.

We can also retrieve previous values starting from the current step backwards. To do this, we omit the starting index.

= B2[:-5]

In this second example, we retrieve the values of cell B2 from the current step to the fifth step backwards.

Usage of Time-aware Ranges

Time-aware ranges are a generalisation of cell ranges in traditional spreadsheets. Therefore, they can be used interchangeably in all functions that accept cell ranges as arguments.

= AVERAGE(B2[:-10])

In this example, we calculate the average of the previous ten values of B2.

This usage is the same as if we used a traditional cell range in the function.

= AVERAGE(B2:B10)