6 Replies Latest reply: Jul 21, 2017 1:05 PM by Pankaj Thakur RSS

    Set analysis help (count based on a distinct modifier)

    Ryan Minaker

      Hi,

       

      I need some help with set analysis please.

      I'm trying to count the number of student records (Student ID), but I only want to count each student record once per course (Course ID).

       

      For example, with this data I'd like to get the count of 4 (rminaker123 has attended 4 courses).

        

      Student_IDCourse_ID
      rminaker123aabbcc
      rminaker123aabbcc
      rminaker123aabbcc
      rminaker123ddeeff
      rminaker123gghhii
      rminaker123gghhii
      rminaker123gghhii
      rminaker123jjjkkll
      rminaker123jjjkkll

       

       

      Count(

      {$<[Course_ID] ={ ?? } 

      >}

      [Student_ID]

      )

       

      Thanks in advance!