4 Replies Latest reply: Dec 2, 2016 12:04 PM by Michael Goldshteyn RSS

    Set analysis in graph

    Michael Goldshteyn

      Hello Community,

       

      Im currently working on developing a count of students that completed a module.

       

      my logic looks like this:

       

      Count(DISTINCT {$<Student = {"=Sum({<Question = {'Question 1','Question 2','Question 3', 'Question 4','Question 5','Question 6'}>} [Correct answers]) = 6 "}>} Student)

       

      each Module is has 6 questions and all 6 need to be complete to finish the module..

       

      my problem is that when I place this logic from a gauge to a bar chart it gives me the same number across all modules.

       

      I understand that the statement is connect to one module but I am unsure how to do the set analysis between different modules.

       

      any thoughts??