1 Reply Latest reply: May 22, 2016 5:28 PM by Stefan Wühl RSS

    count Dimension

    gilad Rahum

      Hi

       

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

       

      count.PNG

        • Re: count Dimension
          Stefan Wühl

          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)