This deprecated node calculates standard deviation, average (mean), sum, and count statistics for the specified field.
The node outputs one row of data with four columns, as follows, where "FieldName" is the value of the ResultPrefix property, if it is specified, or the value of the InputField property if the ResultPrefix is not specified:
- FieldNameStandardDeviation
- FieldNameAverage
- FieldNameCount
- FieldNameSum
Properties
InputField
Specify the name of the field on which to calculate the statistics. The specified field must have a numeric data type.
A value is required for this property.
Biased
Optionally specify whether to calculate the sample standard deviation or the population standard deviation.
If set to True, the node calculates the population standard deviation.
If set to False, the node calculates the sample standard deviation.
The default value is False.
InputExpr
Optionally specify an expression on which to calculate the statistics. By default, this is the same as the InputField property, however, the InputExpr property may be used to change the InputField to a different data type or perform a calculation on it first. For example, if the field specified by the InputField property is a string data type, the values could be converted to a double data type prior to calculating the statistics by inserting the following value in the InputExpr property:
double( {{^InputField^}} )
ResultPrefix
Optionally specify the text to prepend to the column names that are output. For example, if this property is set to 'Prefix', the result fields would be PrefixStandardDeviation, PrefixAverage, PrefixCount and PrefixSum.
Inputs and outputs
Inputs: in1.
Outputs: out1.