Splice

The method is included in the Transformations group and is used to splice some series or their parts. The output series consists of source series values spliced by specified parameters.

NOTE. Only series or series parts having the same calendar frequency can be spliced.

Select series/parts of series, which need to be spliced, in the data table. Hold down the CTRL key to select parts of some series.
Select the Time > Splice item in the drop-down menu of the Transformations button on the Calculations ribbon tab.

After the method is applied, in the workbook, based on the selected series, a calculated series named Splice series(<Spliced_Series_List>) is created, containing splice results. The children of this series are the spliced series. Observations of children series, which take place in the splice, are highlighted.

The chart for the Splice Series calculated series differs from the standard chart:

Child series of the spliced series are marked with ordinary lines. Bold lines indicate series areas that form the spliced series. The spliced series itself is indicated with a bold line of the same color as the highlighting of table cells.

Setting Up Calculation Parameters

NOTE. The option is available only in the desktop application.

Select observations of the child series, which should be added to the splice, in the data table.
Select the Add to Splice context menu item.

Selected observations are added to the splice.

NOTE. The option is available only in the desktop application.

Select observations of the child series, which should be removed from the splice, in the data table.
Select the Delete from Splice context menu item.

Selected observations are deleted from the splice.

The Parameters Tab

Make sure that the side panel is displayed.
Select the series calculated by the Splice method in the data table.
Select the Series radio button on the side panel.
Go to the Parameters tab.

NOTE. The option is available only in the desktop application.

To change the start and end date of the splice area:

1. Double-click the required cell in the Start and End columns. The date is switched to the edit mode.
2. Enter the required value and click outside the cell.

To change the spliced series:

1. Double-click the required cell in the Series column. The list of spliced series is displayed.
2. Select the required series and click outside the cell.

Click the Add button. A new splice area is added to a table.
Select the spliced series in the corresponding cell of the Series column.
Specify the start and end dates of the spliced area in the corresponding cells of the Start and End columns.
Click outside the splice areas list.

The calculated series is rebuilt according to the specified parameters.

Select the required area and click the Remove button. Removal is performed without a request.

The calculated series is rebuilt.

1. Lock the calculated series.
2. Select new spliced areas in the data table.
3. Click the Apply Current Selection button.
4. Unlock the calculated series.

The calculated series is recalculated.