Counter aggregation functions in charts

The following counter aggregation functions can be used in charts:

Chart aggregation functions can only be used on fields in chart expressions. The argument expression of one aggregation function must not contain another aggregation function.

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.

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)

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – please let us know!

Leave your feedback here