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


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


      Any guidance would be appreciated. thanks