countDistinct(column[, group[,condition]])

Calculates the number of distinct 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

number of distinct values in a group

Example

text = countDistinct("Quantity", "State",

   "field['Discount']>0");

See Also

countDistinct(cellRange), for the Table version.

SI.22, Section Object, for additional functions pertaining to Sections.

Sections, for scripting issues related to Sections.

<< count(column[, group[,condition]]) © 1996-2013 InetSoft Technology Corporation (v11.5) covariance(column, column2[, group[,condition]]) >>