Notification

This Help Center is moving to Cloud. Learn more about the migration.

COUNT

Returns the of number of items in a set of values.

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:

 

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.

Was this helpful?

How can we improve it?
true
What's new in Looker Studio?

Learn about new features and recent changes. Looker Studio release notes live on Google Cloud.

Search
Clear search
Close search
Google apps
Main menu
13557058094726620683
true
Search Help Center
true
true
true
true
true
102097
false
false