IMsPointwiseCollapseTransform.Tolerance

Syntax

Tolerance: Integer;

Description

The Tolerance property determines the number of skipped values in output series, which is regarded as acceptable when aggregating data.

Comments

The default value is 0.

Work features of this property depend on the aggregation method set in the IMsCollapseTransform.MethodType property:

Method Tolerance
First If the number of the missing values at the beginning of series is greater than Tolerance, the result is Nan. If the number of missing values is less or equal to Tolerance, the data is aggregated by the First method.
Last If the number of the missing values at the end of series is greater than Tolerance, the result is Nan. If the number of missing values is less or equal to Tolerance, the data is aggregated by the Last method.
Minimum
Maximum
Range
These aggregation methods ignore the Tolerance value. If the output series has at least one value, the aggregation is performed.
Total
Average
Spread
If the number of missing values in the whole series is greater than Tolerance, the result is Nan. If the total number of missing values is less or equal to Tolerance, the data is aggregated by the selected method.

For example, aggregation is calculated by the Average method, and the value of Tolerance is 2. Thus, if there is no data for three quarters of 2001, the output series at 2001 contains the Nan value. And if there is no data only for one quarter of 2001, the output series at 2001 contains the calculated value.

Example

The property use is given in the example for IMsPointwiseCollapseTransform.Input.

See also:

IMsPointwiseCollapseTransform