Transform time series

Quiver provides a wide range of transformations that take a time series as input and return a new time series as a time series plot.

For example, with time series transformations you can:

• Use a rolling aggregate to smooth a series.
• Apply a custom mathematical formula.
• Compute a derivative of a time series.
• Union or coalesce multiple time series.

If you would like to use your transformed series outside of Quiver, you can save it as a derived series.

Apply a time series transform

Transformations can be applied to a single time series by adding a transform card to the analysis, or in batch on a set of time series using a transform table.

Apply a single time series transform

The simplest way to add a time series transformation is through the next actions menu of a time series plot. All time series transformations can be found under the Transform category. Documentation for available transformations can be found in the time series cards index.

Alternatively, open the search bar, search for the desired transform and add it to the canvas.

Transform time series in batch

To apply transformations to times series in batch, use transform tables. Documentation for available transformations can be found in the time series operations page.

Transform tables can take time series as input in different forms, and provides various methods to transform the time series data:

1. Time series as a column: Apply a transform to a time series column. This column can either come from a time series property of an object set or when using a time series chart as input in a transform table.
2. Individual time series data points: Apply a transform to time series data points by using a time series plot as input to a transform table.