The tool supports interface of Foresight Analytics Platform 9 or earlier.
Aggregation is calculation of data of the top level based on the data of the bottom level. For example, calculated monthly data is summed to get quarterly data. The following aggregation methods are available in the time series analysis tool:
Aggregation by Time (Maximum). Aggregates data by finding the maximum value of frequency elements.
Aggregation by Time (Minimum). Aggregates data by finding the minimum value of frequency elements.
Aggregation by Time (First Element). Aggregates data by finding the first element among frequency elements.
Aggregation by Time (Last Element). Aggregates data by finding the last element among frequency elements.
Aggregation by Time (Average). Aggregates data by finding the average value of frequency elements.
Aggregation by Time (Standard Deviation). Aggregates data by finding the frequency standard deviation. The standard deviation determines the spread range for element values relative to the average value.
Aggregation by Time (Sum). Aggregates data by summing frequency element values.
Methods are included to the Aggregation group.
After the method is applied, the Parameters dialog box opens that used to select output frequency.
Frequency can be output, if it is greater than the frequency of the time series, for which the method is used. For example, aggregation is calculated for a series that has quarterly frequency. Thus, only Annual and Semi-Annual options are available in the Output Frequency drop-down list.
Specify output frequency of the calculated series. A corresponding message appears if there are no frequencies that can be used as output frequency.
After selecting the output frequency in the workbook based on each selected series the calculated series with a name of the Collapse <Aggregation_Type>(<Series_Name>) type is created, containing the calculation results. For example:
To change the aggregation calculation method, use the Parameters side panel tab.
In the Method drop-down list select the required aggregation by time calculation method.
See also:
Working with Calculated Series | Modeling Container: Collapse (Series Calculation), Collapse (Pointwise Calculation) | IModelling.Collapse