So I will start off by first saying I watched the Enterprise DNA videos on Cohort Analysis and then Grouping and Segmenting. I think perhaps my specific scenario is not as straight forward so I couldn’t follow those videos to arrive at the outcome that I need for my specific case.
What am I trying to Accomplish?
For the students who have graduated, place them in a cohort that is based on their Admitted Academic Year.
The first thing I know that needs to be done is to get the time to completion in Years which would be using the Admitted Date and the Degree Conferred Date because that will tell how many years it took them to complete the degree.
The next thing I know that needs to be done is we need to ensure that the individuals are tagged to their cohort and that it respects the Academic Career. So if the Admitted Academic Career is not equal to the Graduation Career they should not be excluded from the cohort grouping. But I do not know how to accomplish this and everything after this point. I attached the PBIX file as well.
Below I tried to create a visual of the final table and how I figured the things that lead to the final table should be generated and where they are placed. I have attached excel spreadsheets if that helps.