Time Series Syntax

The time series formula syntax is editable, meaning you can change many of the parameters in-line and dynamically change the corresponding results without interacting with the UI/toolbar.  Click the Time Series cell for any table and modify the formula and see what changes.  

Below the Aggregation is set to weekly:

 

Same query with Week changed to daily nearest:

When start and end dates are applied, the dates can be updated by manually updating the dates in the query.

 

Related pages