Set analysis in graph

[Anonymous]

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

[sunny_talwar]

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

[Anonymous]

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

[sunny_talwar]

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?

[Anonymous]

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.

‌