nthSmallest(n, 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 nth smallest value in the specified column inside a group. This function is only available to elements within a Section.
Parameters
n the nth smallest value to search
column column label of the column to summarize
group column label of the group to summarize
condition condition on the group to summarize
Return
nth smallest value in a group
Example
text = nthSmallest(2,"Quantity","State",
"field['Discount']>0");
See Also
nthSmallest(n, cellRange), for the Table version.
SI.22, Section Object, for additional functions pertaining to Sections.
Sections, for scripting issues related to Sections.
| << nthMostFrequent(n, column[, group[,condition]]) | © 1996-2013 InetSoft Technology Corporation (v11.4) | populationStandardDeviation(column[, group,condition]) >> |