mode(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]]) >>