Tolerance: Integer;
Tolerance: integer;
The Tolerance property determines the number of skipped values in output series, which is regarded as acceptable when aggregating data.
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.
The property use is given in the example for IMsPointwiseCollapseTransform.Input.
See also: