Forum Discussion
Retention analysis
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:
Hi,
PBI file attached.
Hope this helps.
Hello Ashish,
Can we track by semester ( i mean semester 1 , semester 2, semester 3, and so on)? and also listed by Year. something like this :
Instead of months
Yes, you can. Please study my solution and adapt it to your needs.
Hello Ashish,
I apply the formula which you gave me for retention analysis , but my output is giving me the sum instead of year by year retention , this is how my output looks like [ also i am trying to use this formula for the multiple programs [ please let me know what i am doing wrong here]
I appreciate all your help
Thank u
Hello Ashish,
This might be a silly question, but i am trying to understand how the retention is working here as I would like to calculate the semester wise retention grouped by year : as this course has 4 semesters ( i do not know how i am anayzing the retention here)
As you progress through each column of a row, you will see the retnetion percentage of that year.