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_onis not null.