Notification

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

Požadovaná stránka aktuálně není k dispozici ve vašem jazyce. V dolní části stránky však můžete vybrat jiný jazyk, případně pomocí funkce překladu integrované v prohlížeči Google Chrome jakoukoli stránku okamžitě přeložit do vybraného jazyka.

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.

Pomohly vám tyto informace?

Jak bychom článek mohli vylepš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
Main menu
8211570524991197674
true
Prohledat Centrum nápovědy
true
true
true
true
true
102097
false
false