Forum Discussion
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 screenshot of the data ( just one program data)
In this image,dates are their audit date ( when i group my data by audit date , then it is giving me right caluclation ), this is the visualization , the data is organized in raw format where each enrolment is listed as one row ( there are 20,000 rows per student_id).
1. This image shows the enrolment numbers semester -wise (1,2,3,4,5,6,7) and so on as this program has 7 semesters
2. the retention should be caluclated semester wise (1-2,2-3,3-4 and so on) if we read first row : 97( nov 2011), 69(march 2012) and so on
3. there are some of the rows which have null values so we have to consider that as well
can you please let me know how should i achieve this in power BI (any feedback would be highly appreciated)
Hi,
PBI file attached.
Hope this helps.
14 Replies
Hey Harpreet1405_12 ,
I have difficulties understanding what data looks like and what you want to achieve. For this reason, I recommend that you prepare a pbix file that contains sample data but reflects your semantic model (tables, relationships, calculated columns, and measures). Upload the pbix to OneDrive, Google Drive, or Dropbox and share the link. If you do not use the manual input method for the sample data, make sure that the sample data is available in a spreadsheet and share this spreadsheet as well.
Do not forget to explain the expected result based on the sample data.
Regards,
Tom
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.
