ON 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()
count {[SetExpression] [DISTINCT ] [TOTAL [<fld {,fld}>]]} expr )
MissingCount
MissingCount()
missingcount {[SetExpression] [DISTINCT ]
[TOTAL [<fld {,fld}>]] expr )
NullCount
NullCount()
NULL values in each chart dimension.
nullcount {[SetExpression][DISTINCT ] [TOTAL [<fld {,fld}>]]} expr )
NumericCount
NumericCount()
numericcount {[SetExpression] [DISTINCT ] [TOTAL [<fld {,fld}>]]} expr )
TextCount
TextCount()
textcount {[SetExpression] [DISTINCT ] [TOTAL [<fld {,fld}>]]} expr )
