Hi I am new to the Tableau software, and would like to use it for Institutional Research work at my college. Through data blending on the SQL server, this is the data that I am using to generate retention and graduation (cumulative) report for as many as 10 years following a cohort.
| Cohort ID | People Code ID | Academic Year | Academic Term | Term Sequence | Enrollment | Graduation |
| 110FF | A | 2010 | Fall | 1 | Y | N |
| 110FF | A | 2014 | Spring | 8 | Y | Y |
| 113FF | B | 2013 | Fall | 1 | Y | N |
| 113FF | B | 2014 | Spring | 2 | Y | N |
| 113FF | B | 2017 | Spring | 8 | Y | Y |
Below is the format I am using for retention and graduation report:
I am able to get enrollment count, retention rate per term with addressing fields by term sequence, and partitioning field being Cohort ID, and also running total of graduation count, but not running total percent of students who have graduated as of a term. Could any one share how you think this can be done? Thanks!
| Enrollment | Enrollment | Enrollment | Enrollment | Enrollment | Enrollment | Enrollment | Enrollment | Graduation | Graduation | Graduation | Graduation | Graduation | Graduation | Graduation | Graduation |
| Cohort | Term 1 | Term 2 | Term 3 | Term 4 | Term 5 | Term 6 | Term 7 | Term 8 | Term 1 | Term 2 | Term 3 | Term 4 | Term 5 | Term 6 | Term 7 | Term 8 |
| 110FF | | | | | | | | | | | | | | | | 2 |
| 113FF | | | | | | | | | | | | | | | | |
| | | | | | | | | | | | | | | | |
| Summarize enrollment for term 1: total count of students in the cohort, and % from Term 2-8 for enrollment | | | | | |
| Summarize graduation for each term should be cumulative % of cohort students who have graduated. | | | | | | |
