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)