Time Series node - aggregation and distribution options
Use the settings in this pane to specify settings for aggregating or distributing the input data with respect to the time intervals of the observations.
- Aggregation functions
- When the time interval that is used for the analysis is longer than the time interval of the observations, the input data are aggregated. For example, aggregation is done when the time interval of the observations is Days and the time interval for analysis is Months. The following aggregation functions are available: mean, sum, mode, min, or max.
- Distribution functions
- When the time interval that is used for the analysis is shorter than the time interval of the observations, the input data are distributed. For example, distribution is done when the time interval of the observations is Quarters and the time interval for analysis is Months. The following distribution functions are available: mean or sum.
- Grouping functions
- Grouping is applied when observations are defined by date/times and multiple observations occur
in the same time interval. For example, if the time interval of the observations is Months, then
multiple dates in the same month are grouped and associated with the month in which they occur. The
following grouping functions are available: mean, sum, mode, min, or max. Grouping is always done
when the observations are defined by date/times and the time interval of the observations is
specified as Irregular. Note: Although grouping is a form of aggregation, it is done before any handling of missing values whereas formal aggregation is done after any missing values are handled. When the time interval of the observations is specified as Irregular, aggregation is done only with the grouping function.
- Aggregate cross-day observations to previous day
- Specifies whether observations with times that cross a day boundary are aggregated to the values for the previous day. For example, for hourly observations with an eight-hour day that starts at 20:00, this setting specifies whether observations between 00:00 and 04:00 are included in the aggregated results for the previous day. This setting applies only if the time interval of the observations is Hours per day, Minutes per day or Seconds per day and the time interval for analysis is Days.
- Custom settings for specified fields
- You can specify aggregation, distribution, and grouping functions on a field by field basis. These settings override the default settings for the aggregation, distribution, and grouping functions.