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