This function is used by Ignition's Expression language.
Calculates the simple standard deviation of the values in the given column of the given dataset, or the standard deviation for a series of numbers specified as arguments. When looking up the standard deviation in a dataset, the column may be specified as an index or as a column name. Any null values in the column are ignored.
stdDev(dataset, columnIndex)
Integer/Float - The standard deviation of the values in that column.
stdDev(dataset, columnName)
Integer/Float - The standard deviation of the values in that column.
stdDev(value, [value, ...])
Integer/Float - The standard deviation of the values in the list of values.
The following feature is new in Ignition version
8.1.8
Click here to check out the other new features
The following overload was added in 8.1.8:
stdDev(sequence)
Integer/Float - The standard deviation of the values in the list of values.
For example, suppose you had a table with this dataset in it:
ProductCode | Quantity | Weight |
BAN_002 | 380 | 3.243 |
BAN_010 | 120 | 9.928 |
APL_000 | 125 | 1.287 |
FWL_220 | 322 | 7.889 |
stdDev({Root Container.Table.data}, "Weight") //... would return 3.4687.