count Dimension

[#1]

Hi

How can count number of string , for example , how can i count the number of countries in the list below

[swuehl · Accepted solution]

You can count the distinct field values like

=COUNT( DISTINCT COUNTRY_AGG)

If you want to count all field records, remove the DISTINCT qualifier from the count.

And if you want to count disregarding any user selections:

=COUNT({1} DISTINCT COUNTRY_AGG)