3 Replies Latest reply on Jan 30, 2019 8:18 AM by Andy Eunada

    Help with counting a dimension with multiple values

    Andy Eunada

      Hello All,

       

      I am trying to do a count of users that has more than one email address.

      I tried using the below calculated field, but I'm not getting the desired results.

      {FIXED [User] : COUNTD([email_address]) }

       

      Please see below sample data

       

      Desired output:

      In the example below, the output I want would be 3.

      3 users had more than one email address

       

      UserEmail Address

      Andy

      Email 1
      AndyEmail 2
      BobEmail 1
      ChrisEmail 1
      ChrisEmail 2
      JaneEmail 1
      JaneEmail 2
      JaneEmail 3

       

      Any guidance would be appreciated. thanks