Function: COUNT
Syntax: COUNT()
or COUNT(field)
Description: Counts the number of records for each grouping (set of dimensions). When a field is provided the function counts the number of records where the field value is not null. .
Sample usage:
COUNT()
returns the total number of records for each group.COUNT(due_on)
returns the number of records wheredue_on
is not null.