Forum Discussion
Solved
Retention analysis
Dear team, I am working on calculting the retention between semesters per program, the data is organized in the different format so I am finding it difficult to caluclate the retention. Here is the ...
Hi,
PBI file attached.
Hope this helps.
Here is the link of the spreadsheet which has a sample data set i am working on. The enrolment data grouped by Audit date make more sense and it will give you the output which is listed in above screenshot ( In this screenshot i transpose the semester data into column and then count the distinct unique id grouped together by audit date). I want to achieve something like this:
The retention of unique id from one semetesr to 2 and 2nd to 3rd an dthen 3rd to 4th etc. how many people we loose from start to completion of the module. Does it make sense?
This is great, thank you so much for your response