standardDeviation(column[, group[,condition]])
average(column[, group[,condition]])
concat(column[, group[,condition]])
correlation(column, column2[, group[,condition]])
count(column[, group[,condition]])
countDistinct(column[, group[,condition]])
covariance(column, column2[, group[,condition]])
max(column[, group[,condition]])
median(column[, group[,condition]])
min(column[, group[,condition]])
mode(column[, group[,condition]])
nthLargest(n, column[, group[,condition]])
nthMostFrequent(n, column[, group[,condition]])
nthSmallest(n, column[, group[,condition]])
populationStandardDeviation(column[, group,condition])
populationVariance(column[, group[,condition]])
pthPercentile(p, column[, group[,condition]])
product(column[, group[,condition]])
standardDeviation(column[, group[,condition]])
sum(column[, group[,condition]])
Calculates the (sample) standard deviation of values in the specified column inside a group. This function is only available to elements within a Section.
Parameters
column column label of the column to summarize
group column label of the group to summarize
condition condition on the group to summarize
Return
standard deviation of all values in a group
Example
text = standardDeviation("Quantity","State",
"field['Discount']>0");
See Also
standardDeviation(cellRange), for the Table version.
populationStandardDeviation(column[, group,condition]), for population version.
SI.22, Section Object, for additional functions pertaining to Sections.
Sections, for scripting issues related to Sections.
| << product(column[, group[,condition]]) | © 1996-2013 InetSoft Technology Corporation (v11.5) | sum(column[, group[,condition]]) >> |