mode(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 mode 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
mode of all values in a group
Example
text = mode("Quantity", "State", "field['Discount']>0");
See Also
mode(cellRange), for the Table version.
SI.22, Section Object, for additional functions pertaining to Sections.
Sections, for scripting issues related to Sections.
| << min(column[, group[,condition]]) | © 1996-2013 InetSoft Technology Corporation (v11.4) | nthLargest(n, column[, group[,condition]]) >> |