1 Reply Latest reply: Jun 13, 2018 5:07 AM by Sunny Talwar RSS

    Count distinct between two fields.

    Ipsita Mahapatra

      Hello Everyone,

       

      Need an urgent help.

      Say I have two fields like Location and Attended_PeopleStatus where location field will have duplicate values.

      Now I want the count of distinct status according to Region.

       

      LocationAttended_PeopleStatus
      A0
      A0
      B0
      C0
      C0
      C0
      C0
      D1
      D1
      E1
      F1
      F1
      F1
      G1

       

      Output Count of Attended_PeopleStatus should be:

      0 - 3

      1 - 4

       

      Can anyone please advice how can i achieve this.

       

       

      Thanks,

      Ipsita