Returns the of number of items in a set of values.
The COUNT
function counts the number of items in a field.
Syntax
COUNT(value)
Parameters
value
- a field or expression that contains the items to be counted.
How the COUNT function works
The COUNT
function takes 1 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.
COUNT Example
COUNT(
Page) - counts the number of non-unique values in the Page dimension.