Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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??
Would you be able to provide a sample to look at this Michael?
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 |
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?
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.