Three-dimensional Ranges

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

Three-dimensional Range

Traditional spreadsheets offer the ability to select a range of cells on the spreadsheet. Timeline builds upon this idea by allowing the user to select a range of previous values. What if we combine these two ranges into a three-dimensional object in time and space?

To select a cell range, we use the following syntax:

= B2:C5

To select a time range, we use the following syntax:

= B2:C5[-5]

To select a three-dimensional range, we use the following syntax:

= B2:C5[-5:-10]

This construct retrieves a cell range of B2:C5 in five different time steps, resulting in a three-dimensional range.

It is important to note that a cell range, a time-aware range and a three-dimensional range all return the same type of construct, which is an array of cells and their values in the specified range. Therefore, their usage is interchangeable in all functions that accept cell ranges as arguments.