Math Functions > Time Functions


To Irregular using Pattern

The To Irregular using Pattern function generates a new time series data set from an existing irregular or regular interval time series data set.  The times for the new time series are defined by the times of a second time series data set.  Values for the new time series are computed from the original time series data using one of seven available functions.  The functions are:

 

Interpolate at end of Period

Maximum for Period

Minimum for Period

Average over Period

Accumulation over Period

Volume for Period

Integration over Period

Number of Valid Data over Period

 

where “period” is the time between data points in the pattern data set.

 

The data type of the original time series data governs how values are interpolated.  Data type “INST-VAL” (or “INST-CUM”) considers the value to change linearly over the interval from the previous data value to the current data value.  Data type “PER-AVER” considers the value to be constant at the current data value over the interval.  Data type “PER-CUM” considers the value to increase from 0.0 (at the start of the interval) up to the current value over the interval.  Interpolation of the three data types is illustrated in the figure below.

 

 

Interpolation of “INST-VAL,” “PER-AVER” and “PER-CUM” Data

 

How interpolation is performed for a specific data type influences the computation of new values for the selected function.  For example, if the data type is “INST-VAL,” the function Maximum for Period is evaluated by:

 

Referring to the plots above, the Average over Period function is applied to a time series by integrating the area under the curve between interpolated points and dividing the result by the interval time.

 

Screen for Transforming To Irregular using Pattern Function

 

The appearance of the Math Functions screen for the Transform to Irregular interval function is shown above. 

 

To transform to an irregular interval time series data set:

  1. Choose the Time Functions tab of the Math Functions screen and select the To Irregular using Pattern operator.
  2. From the Selected Data Set list, select a time series data set. 
  3. From the Data Set for Time Pattern list, select a time series data set to provide the time pattern for the resultant time series.
  4. From the Function Type list, select the method for computing new time series values.
  5. Click Compute.