Time Series Pivot Table


Version: 2025

Type: Features

Category: Data Handling

Subcategory: Worksheet

Jira: ORG-27189


Summarize data by date and time intervals and period

  • Row-wise, column-wise, or row + column wise aggregation

  • Two level grouping by setting aggregation interval and time period

  • Fiscal year support with customizable start and end

  • Several aggregation intervals including decade, year, quarter, month, week, day to hour, min, and customizable e.g. 12hour

  • Aggregate by statistics quantities, e.g. sum, mean, ... to customizable "mean sd", etc.

https://blog.originlab.com/time-series-pivot-table-to-summarize-data

image-20241122-185707.png