Counter aggregation functions

Count() returns the number of values aggregated in expression, as defined by a group by clause.

count([ distinct ] expression)

MissingCount() returns the number of missing values aggregated in the expression, as defined by a group by clause.

MissingCount([ distinct ] expression)

NullCount() returns the number of NULL values aggregated in the expression, as defined by a group by clause.

NullCount([ distinct ] expression)

NumericCount() returns the number of numeric values found in the expression, as defined by a group by clause.

NumericCount([ distinct ] expression)

TextCount() returns the number of field values that are non-numeric aggregated in the expression, as defined by a group by clause.

TextCount([ distinct ] expression)

Count() is used to aggregate the number of values, text and numeric, in each chart dimension.

count([{SetExpression}] [DISTINCT] [TOTAL [<fld {,fld}>]] expr)

MissingCount() is used to aggregate the number of missing values in each chart dimension. Missing values are all non-numeric values.

missingcount([{SetExpression}] [DISTINCT] [TOTAL [<fld {,fld}>]] expr)

NullCount() is used to aggregate the number of NULL values in each chart dimension.

nullcount([{SetExpression}][DISTINCT] [TOTAL [<fld {,fld}>]] expr)

NumericCount() aggregates the number of numeric values in each chart dimension.

numericcount([{SetExpression}] [DISTINCT] [TOTAL [<fld {,fld}>]] expr)

TextCount() is used to aggregate the number of field values that are non-numeric in each chart dimension.

textcount([{SetExpression}] [DISTINCT] [TOTAL [<fld {,fld}>]] expr)