4.4.21 Time Series Pivot

From Origin 2024, it supports Time Series Pivot tool to create a pivot table to visualize data summarization (of statistics) based on a date-time column

To open this tool, with a workbook window activated,

  • Select Restructure : Time Series Pivot... menu;

Or

  • Run wtspivot -d; in Script Window or Command Window.

This tool utilizes the Wtspivot X-Function.

Time Series Pivot 01.png


Dialog Options

Recalculate Specify the Recalculate Mode.
  • None
  • Auto
  • Manual
Source Time Specify the range that will be used as the time source of the Pivot Table.
Source Data Specify the range of data values to be summarized.
Time Bucket for Rows Determine the time bucket shown in first column of the Pivot Table.

Options:

  • Year
  • Quarter of Year
  • Month
  • Week of Year
  • Day of Year
  • Day of Month
  • Weekday
  • Hour of Day
  • Halfhour of Day
  • Quarter Hour of Day
  • Minute'
Time Period for Columns Determine the time period shown in column label row of the Pivot Table.

Options:

  • None
  • Year
  • Quarter of Year
  • Month
  • Week of Year
  • Day of Year
  • Day of Month
  • Weekday
  • Hour of Day
  • Halfhour of Day
  • Quarter Hour of Day
  • Minute
Secondary Time Period for Columns Determine the secondary time period shown in column label row of the Pivot Table.

Options:

  • None
  • Year
  • Quarter of Year
  • Month
  • Week of Year
  • Day of Year
  • Day of Month
  • Weekday
  • Hour of Day
  • Halfhour of Day
  • Quarter Hour of Day
  • Minute
Limit Columns to Range Check this checkbox to limit the output Date-and-Time columns to the input Date-and-Time range. Otherwise, output Date-and-Time columns will round to the ends of time period you specified.
Show Zeros when Empty Specify whether to show missing values in the pivot table as zeros.
Aggregate by Specify the way to summarize the Source Data.

Option:

Count Output the count of each Row/Column pair.
Sum Output the sum of each Row/Column pair.
Mean Output the mean of each Row/Column pair.
Min Output the minimum value of each Row/Column pair.
Max Output the maximum value of each Row/Column pair.
Median Output the median value of each Row/Column pair.
SD Output the Standard Deviation of each Row/Column pair.
SE Output the Standard Error of each Row/Column pair.
RMS Output the Root Mean Square of each Row/Column pair.
Confidence Interval Output the confidence interval for a population mean of each Row/Column pair (using a normal distribution).
Range (Max - Min) Output the range between maximum and minimum of each Row/Column pair.
First in Subgroup Output the first value in each Row/Column pair.
Last in Subgroup Output the last value in each Row/Column pair.
Custom Select this option to define your own summarized method in Custom edit box below.
Custom Available only when Aggregate by is set to Custom. Specify the summarized method in the combo edit box. The triangle button next to the edit box provides some frequently-used statistics quantities. You can mix them and construct your own summarized method.
Output Result Table to Specify where to output result table.
English | Deutsch | 日本語