
1. Re: Pass and Fail Rates Calculations
Peter Galimutti Feb 16, 2017 3:39 AM (in response to Tawa Kapfunde)1 of 1 people found this helpfulHi Tawa,
I am not able to open the packaged worksheet as I don't have latest version of Tableau
1. Number of students who passed as whole. There are many ways, but one thing I can rem off hand is
Create a Calculated field or on the fly on shelf
= SUM(IF CONTAINS ("A,B,C",GRADE) THEN 1 END ELSE 0)/TOTAL(COUNT OF STUDENTS)
or
SUM(IF CONTAINS ("A,B,C",GRADE) THEN 1 END ELSE 0)/sum(IF CONTAINS ("A,B,C,D,E,U,X",GRADE) THEN 1 END ELSE 0)
Hopefully this should answer your first part.
Second part you can use the same calculation in rows and drag region and or school to columns get the breakdown.
HTH,
Peter

2. Re: Pass and Fail Rates Calculations
Norbert Maijoor Feb 16, 2017 4:03 AM (in response to Tawa Kapfunde)Hi Tawa,
Find my approach as reference below and stored in original threat in version 9.3
I "grouped" all values to A, B, C, D, E, U X & Others
then I defined "Pass  Fail"
f [Symbol (group)]='A' then "PASS"
elseif [Symbol (group)]='B' then "PASS"
elseif [Symbol (group)]='C' then "PASS"
elseif [Symbol (group)]='D' then "FAIL"
elseif [Symbol (group)]='E' then "FAIL"
elseif [Symbol (group)]='U' then "FAIL"
elseif [Symbol (group)]='X' then "FAIL"
else "Other"
END
Defined count of Students
count([Surname])
total
Per Region
Per School
Upfront thanks for your feedback
Regards,
Norbert

O Level Results.twbx 1.2 MB


3. Re: Pass and Fail Rates Calculations
Tawa Kapfunde Feb 16, 2017 4:50 AM (in response to Norbert Maijoor)Thank you so much. This is exactly what i was looking for. If i am to drill down into the number of students that sat for the exam, and the number of students who had a total 5 passes(5 subjects). I hope i am not asking for too much

4. Re: Pass and Fail Rates Calculations
Norbert Maijoor Feb 16, 2017 5:06 AM (in response to Tawa Kapfunde)Hi Tawa,
No problem. You are welcome.
countd([Surname])= 1605 (sheet 5)
Count student with 5 passes or more: if attr([PASS FAIL])="PASS" and count([Surname])>=5 then 1 END = 74(sheet 6)
Please validate and let me know.
Regards,
Norbert

O Level Results updated.twbx 1.2 MB


5. Re: Pass and Fail Rates Calculations
Tawa Kapfunde Feb 16, 2017 6:10 AM (in response to Norbert Maijoor)Hi Norbert
Thank you. It does check out like a charm. Many thanks for the assistance.

6. Re: Pass and Fail Rates Calculations
Norbert Maijoor Feb 16, 2017 6:02 AM (in response to Tawa Kapfunde)Hi Tawa,
Your are welcome. Keep posting, if necessary, at your next challenge.

7. Re: Pass and Fail Rates Calculations
Tawa Kapfunde Feb 23, 2017 5:51 AM (in response to Tawa Kapfunde)Hi Norbert
I have created a dashboard and tried to use the calculations. There is a disparity with what i got from my manual count. May you assist in troubleshooting the work book. E.g 2,598 sat for the exams and were captured in my database. The overall pass rate and the number of students with at least 5 subject passes in one goal, are not showing correctly. Help me and explain where its going wrong.
Thanks,
Tawa

O Level Results updated.twbx 1.6 MB


8. Re: Pass and Fail Rates Calculations
Norbert Maijoor Feb 24, 2017 3:33 AM (in response to Tawa Kapfunde)1 of 1 people found this helpfulHi Tawa,
I reviewed the dashboard and cleaned it up. Please validate. When I look at the data I find a huge amount of duplicates, wrong notation etc. Please consider to proper validation of your dataset.
Regards,
Norbert

9. Re: Pass and Fail Rates Calculations
Tawa Kapfunde Feb 24, 2017 6:02 AM (in response to Norbert Maijoor)Thank you so much Norbet. i will start working on the dataset.

10. Re: Pass and Fail Rates Calculations
Norbert Maijoor Feb 24, 2017 6:09 AM (in response to Tawa Kapfunde)Hi Tawa,
You are welcome. Have a nice weekend.