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` function works

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](https://docs.cloud.google.com/data-studio/edit-fields-in-your-reports) 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.

## Related resources

- [Calculated fields](https://docs.cloud.google.com/data-studio/about-calculated-fields)
- [Data Studio function list](https://docs.cloud.google.com/data-studio/function-list)