8 Replies Latest reply: Nov 30, 2016 9:58 AM by Michael Goldshteyn RSS

    set analysis

    Michael Goldshteyn

      Hello Community,


      I am trying to get this set analysis correct. but i cant seem to figure it out.

       

      i need to find the number of completed "modules". each module has 2 courses

       

      The way this is figured out is that every course have 3 questions and only one has to be right to complete that course.

      Example
      Course1 - Questions1
                     Questions2

                     Questions3

      Course2 - Questions4
                     Questions5

                     Questions6

       

        

      StudentPool/QuestionCorrect answersScore
      MikeQuestion100%
      MikeQuestion21100%
      MikeQuestion300%
      MikeQuestion400%
      MikeQuestion51100%
      MikeQuestion600%

       

       

      (This is for course 1)

      count({$<[Question] = {'Questions1','Questions2','Questions3'}, [Correct answers] = {1}>}distinct Student)

       

      I'm having trouble getting the second half of this, which is to tell me when they completed course 1 and course 2 they completed the module.

       

      Any suggestions?