Working with Calculated Series

A calculated series is a series calculated using one of the methods based on time series data.

If the selected calculation method requires similar series frequencies, the following correspondence is checked:

Series frequencies.
Series start dates.
Series lengths.
Day when a week starts (for weekly and daily frequency).
Days off (for daily frequency).

Calculation is performed for series with matching frequencies, otherwise an error message is displayed.

The calculation series with the calculation results is added to the workbook sheet. Calculations will be made using scaled values, that is values with the same measurement unit scale.

Depending on the transformation method, a calculated series can contain different sets of child series: facts, a modeling series with forecast values, remainders, confidence limits, and so on. For example:

Operations with Calculated Series

If any errors occurred during series calculation, the calculation is aborted. When a calculated series is filled with empty values, a red corner is displayed in the cell with the title:

Hover the cursor over series header to read error message. The message is displayed as a tooltip.

To view summary statistics:

Select a calculated series in the data table.
Go to the statistics panel.

Locking enables the user to fix selection on a calculated series. As a result, tabs that are used to work with the locked series are always displayed on the side panel independently on the current table selection, and the buttons in the Time Series group on the Data ribbon tab are locked.

To lock:

Select a calculated series in the data table.
Click the Lock button on the Data ribbon tab.

The selected series is locked.

To unlock, release the Lock button.

The option is available only for transformation methods, in which input and modeling series match.

To perform transformation:

Select a time series in the data table.
Press the CTRL key.
Execute the command corresponding to the required calculation method on the Calculation ribbon tab.

The time series is transformed into a calculated one.

To cancel the transformation, select the Undo Transformations item in the series's context menu in the data table.

NOTE. Transformation and undoing of transformation are available for the series that are transformed by all the methods, except for the Calculator method.

Select a calculated series in the data table.
Set series attributes values.
Select the Save Selected Series item in the context menu of the calculated series.

On saving to the time series database the calculated series is transformed into the time series.

The calculated series can be saved as a model to the internal time series database modeling container. To save:

Select a calculated series in the data table.
Set series attributes values.
Select the Save As a Model item in the context menu of the calculated series.

Further working with the obtained model is performed within the modeling container.

TIP. To open the internal modeling container, select the Open Modeling Container item in the context menu of the time series database in the object navigator.

On working with the desktop application the setup of several calculated series is available. To do this:

In the workbook select calculated series, for which it is necessary to specify parameter settings.
Go to the Series tab group on the side panel.

In this tab group the Primary side panel tab is displayed and tabs containing general settings of series.

Values of parameters on the tabs are specified in the following way:

The Several Rows value is displayed in the Name box.
If different settings are specified for the selected calculated series, which assume selecting a checkbox, for example Edit Measurement Unit and Apply Transformation, the checkbox view is changed to , the boxes contain Measurement Units and Different Transformations values.
On clicking the checkbox parameter value is reset.
To specify same parameters, select the checkbox and specify the required parameter value.
If no parameters are specified for the selected series, checkboxes of parameter names are deselected.
If specifying parameters does not require selecting checkboxes, the Multiple Values message is displayed on values mismatch.
Corresponding values can be displayed on the Series Attributes side panel tab next to series attributes.
If the existence of parameters for different calculated series differs, tabs with settings of such parameters are not displayed on selecting these series.
For example, the Parameters tab is not displayed for series calculated with different methods.
If the forecast period is not set up for calculated series of different types or if it is the same forecast period, the Forecast Periods tab is displayed.

Creating and Setting Up Calculated Series

Operations with Calculated Series