The COUNT function counts the number of items in a field.
Syntax
COUNT( X )
Parameters
-
X- a field or expression that contains the items to be counted.
How the COUNT
The COUNT function takes one parameter, which can be the name of a metric, dimension, or an expression of any type. COUNT returns the total number of items in that field or expression, including duplicates.
To count only unique items, use COUNT_DISTINCT or APPROX_COUNT_DISTINCT.
There are 2 other ways to apply this function:
- In a data source, change a field's Aggregation type to
Count.- in a report, edit the field's aggregation in a chart.
Examples
COUNT(Page) - counts the number of non-unique values in the Page dimension.
Limits of COUNT
You can't apply this function to a pre-aggregated field ( Aggregation type of Auto ), or to an expression which is the result of another aggregation function. For example, a formula such as COUNT(SUM(x)) will produce an error.