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

# Set analysis in graph

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

• ###### Re: Set analysis in graph

Would you be able to provide a sample to look at this Michael?

• ###### Re: Set analysis in graph

Questions - FR 1-3 and PFMEA 1-3 are Module 1

MPFMEA 1-3 and QRA 1-3 are Module 2

 Student Question Number of questions Questions answered Correct answers Score Mike Goldshteyn FR 1 1 1 1 100 Mike Goldshteyn FR 2 1 1 1 100 Mike Goldshteyn FR 3 1 1 1 100 Mike Goldshteyn PFMEA 1 1 1 1 100 Mike Goldshteyn PFMEA 2 1 1 1 100 Mike Goldshteyn PFMEA 3 1 1 1 100 Mike Goldshteyn MPFMEA 1 1 1 1 100 Mike Goldshteyn MPFMEA 2 1 1 1 100 Mike Goldshteyn MPFMEA 3 1 1 1 100 Mike Goldshteyn QRA 1 1 1 1 100 Mike Goldshteyn QRA 2 1 1 1 100 Mike Goldshteyn QRA 3 1 1 1 100
• ###### Re: Set analysis in graph

Problem is that I am not sure how this information is needed in a bar chart. Is there going to be a bar for 1 student? or what exactly are you looking to plot here?

• ###### Re: Set analysis in graph

I am looking to plot a completion of all students per module.

Though I was able to figure out how to display the information I needed through the rangesum() function.