Math Functions > Time Functions


Change Time Interval

The Change Time Interval function interpolates or extracts values from existing regular interval time series data sets to new regular interval time series data sets with a different time interval.

Whether the time series data type is “INST-VAL,” “INST-CUM,” “PER-AVER,” or “PER-CUM” controls how interpolation is performed.  Interpolated values are derived from “INST-VAL” or “INST-CUM” data using linear interpolation.  Values are derived from “PER-AVER” data by computing the period average value over the new time interval.  Values are derived from “PER-CUM” data by computing the period cumulative value over the new time interval.

For example, if an original data set is hourly data and the new regular interval data set is to have a six-hour time interval:

  1. The value for “INST-VAL” or “INST-CUM” type data is computed from the linear interpolation of hourly points bracketing the new six-hour time point.
  2. The value for “PER-AVER” type data is computed from the period average value over the six-hour interval.
  3. The value for “PER-CUM” type data is computed from the accumulated value over the six-hour interval.

 

The treatment of missing value data is also dependent upon data type.  Interpolated “INST-VAL” or “INST-CUM” points must be bracketed or coincident with valid (not missing) values in the original time series; otherwise the interpolated values are set as missing.  Interpolated “PER-AVER” or “PER-CUM” data must contain all valid values over the interpolation interval; otherwise the interpolated value is set as missing.

 

To change the time interval in time series data sets:

  1. Choose the Time Functions tab of the Math Functions screen and select the Change Time Interval operator, as shown in the figure below.
  2. Select a data set to apply the function from the Selected Data Set pull-down list at the top of the screen or multiple data sets from the list in the lower portion of the screen.  If you include the data set selected in the top Selected Data Set, the operation on that set will only be done once.
  3. From the Time Interval list, select the new time interval for the data sets.
  4. Optionally, you may specify a Time Offset to offset the new points in time from the standard interval time.  For example, if you select a daily interval for the Time Interval, you may use the option to offset time points to be at 6 a.m. instead of at midnight.  If the Set Time Offset box is checked, enter an integer number in the box to the right and select the minute/hour/day/week/month/year time increment from the list further to the right.  If the Set Time Offset box is unchecked, times in the resultant data sets will fall on the regular interval time (typical setting).
  5. Click the Compute button to perform the interpolation.


    Change Time Interval Function