Dis-aggregation
Basic and Dis-aggregated Series
The original series, i.e. the series to be dis-aggregated, is called basic series. The series with the dis-aggregates is called the dis-aggregated series.
...
- dis-aggregated series data are fractions of the basic series data; if there are n dis-aggregated series elements in a basic series interval, then the fraction is 1/n: dis-aggregated series data = 1/n * basic series data,
- as above, but additionally with linear interpolation between the midpoints of the basic series intervals.
Series Codes
The series to dis-aggregate can be selected or de-selected by clicking the checkbox of the series. By clicking your right mouse button on top of the Series list box you can select or de-select all series.
Interpolation
When the 'Interpolation' checkbox is checked, the dis-aggregated series data are interpolated linearly.
...
- Select one or more basic series from the Series Codes list.
- Select time intervals of aggregated series where Dt~basic~ > Dt~dis-aggregated~
- in addition you have to indicate whether the dis-aggregates should be interpolated linearly between the mid-points of the basic series or should be taken as constant over a basic series interval.
- Press <Execute> to execute the dis-aggregation.
The newly aggregated series can be shown in a Graph, Viewed within the spreadsheet viewer, Saved to the database or Exported.
Limitations
The step between the time interval units for aggregation and dis-aggregation should generally not be more than one; e.g. aggregation from hour to day is allowed but aggregation from hour to month is not allowed. An exception applies for the cases where the basic time unit of the resulting series equals the time interval unit of the basic series, e.g. from day to week. Aggregations and dis-aggregations which are not allowed are blocked by the menu.
Influence of the
...
Processing Period while
...
Aggregating
While aggregating time series the start period is very important. Some examples will be given:
...