Notification

This article is about Looker Studio. For Looker documentation, visit https://cloud.google.com/looker/docs/intro.

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(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:

COUNT Example

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.

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