Counter aggregation functionsON THIS PAGE
Counter aggregation functions return various types of counts of an expression over a number of records in a data load script or a number of values in a chart dimension.
Use the drop-down on each function to see a brief description and the syntax of each function. Click the function name in the syntax description for further details.
Counter aggregation functions in the data load script
Count
Count() returns the number of values aggregated in expression, as defined by a group by clause.
count ( [distinct ] expression | * )
MissingCount
MissingCount() returns the number of missing values aggregated in the expression, as defined by a group by clause.
MissingCount ( [
distinct ] expression )
NullCount
NullCount() returns the number of NULL values aggregated in the expression, as defined by a group by clause.
NullCount ( [
distinct ] expression )
NumericCount
NumericCount() returns the number of numeric values found in the expression,
as defined by a group by clause.
NumericCount ( [
distinct ] expression )
TextCount
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 )
Counter aggregation functions in chart expressions
The following counter aggregation functions can be used in charts.
Count
Count()
is used to aggregate the number of values, text and numeric, in each chart dimension.
count ({[SetExpression] [DISTINCT ] [TOTAL [<fld {,fld}>]]} expr )
MissingCount
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
NullCount()
is used to aggregate the number of NULL values in each chart dimension.
nullcount ({[SetExpression][DISTINCT ] [TOTAL [<fld {,fld}>]]} expr )
NumericCount
NumericCount()
aggregates the number of numeric values in each chart dimension.
numericcount ({[SetExpression] [DISTINCT ] [TOTAL [<fld {,fld}>]]} expr )
TextCount
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 )