InterpolateP

Syntax

InterpolateP(Input: ITimeSeries,
             TargetFrequency: MsFrequency,
             Pattern: ITimeSeries,
             PatternType: MsPatternType,
             Period: IMsPeriod)

Parameters

Input. Input variable

TargetFrequency. Output frequency

Pattern. Pattern variable, on which the interpolation is based. It must contain output frequency

PatternType. Pattern type, on which the interpolation is based. Optional parameter. By default the parameter is set to MsPatternType.Average - average by elements.

Period. Period, at which the method is calculated. Optional parameter. By default the parameter is set to Null, the method is calculated at the entire time period.

Description

It interpolates variable values by the template.

Comments

On data disaggregation the following calendar frequency settings are taken into account: start period offset relative to its start/end.

Example of data aggregation from weekly to daily frequency

Example

Formula Result Application
= InterpolateP({Brazil|BCA[t]}, MsFrequency.Quarterly, {China|BCA[t]})

The Brazil|BCA series data will be disaggregated to quarter frequency by template set by the China|BCA series for the whole time period.

It can be used in formulas of calculated series of time series database and in formulas of attribute-based models of modeling container.
= InterpolateP(X1, MsFrequency.Monthly, X2, MsPatternType.Last,  SetPeriod("01.01.2000","01.01.2015")) The X1 factor data will be disaggregated to monthly frequency by the last template element set by the X2 factor for the period from 2000 to 2015. It can be used in model variable-based formulas of modeling container.

See also:

Functions Available in Expression Editor │ AggregationIModelling.InterpolateP