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

# set analysis

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

 Student Pool/Question Correct answers Score Mike Question1 0 0% Mike Question2 1 100% Mike Question3 0 0% Mike Question4 0 0% Mike Question5 1 100% Mike Question6 0 0%

(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?

• ###### Re: set analysis

May be like this:

Count(DISTINCT {<Student = {"=Sum({<[Question] = {'Questions1','Questions2','Questions3'}>} [Correct answers]) > 1 and Sum({<[Question] = {'Questions4','Questions5','Questions6'}>} [Correct answers]) > 1"}>} Student)

• ###### Re: set analysis

It worked very well!

Thank you Very much Sunny!!

• ###### Re: set analysis

I think I forgot to add > 1 for the second Sum() within the set analysis. Not sure if that would make any difference, but I have fixed that in my response above.

Best,

Sunny

• ###### Re: set analysis

noted and changed.

I have tested both ways and it seems not to affect the result, but I placed it in regardless to reduce any error that may occur.

-Mike

• ###### Re: set analysis

The Requirements have changed a little for this assignment.

The set analysis will have to be placed in a bar chart and correct amount of questions to complete a course has changed from 1 to 3.

Any suggestions?

• ###### Re: set analysis

Based on the data provided above, what would be the expected output?

• ###### Re: set analysis

expected output would be to see the count of students that have completed each module.

In the original example above neither course would be completed until all the questions that correspond to the course are correct.

Furthermore, the module wouldn't be complete till the both courses are complete.

• ###### Re: set analysis

i have been able to get it to show the correct count for Module 1, but unfortunately it gives me the same number across the rest of the modules as well.

Count(DISTINCT {\$<Student = {"=Sum({<Question = {'Question1','Question2','Question3'}>} [Correct answers]) = 3 and Sum({<Question = {'Question4','Question5','Question6'}>} [Correct answers]) = 3 "}>} Student)