Using Average on Beast Mode

giannzi

I want to calculate the average number of semesters that students with bachelor's degrees have completed. Below is my Beast Mode calculation.

However, it currently counts all semesters (or terms) a student has attended, even if they pursued additional degrees after earning their bachelor's. I only want to count the semesters up to and including the term in which they obtained their bachelor's degree.

After that, I want to calculate the average. Do you know how I can achieve this?

ggenovese

Is Academic Plan the identifier for degree being pursued in the Term? If so, if you add it to your fixed function partition you would get a count of terms by student and degree being pursued. After that I believe you can divide by the number of students to get an average of terms per student.

giannzi

Hello @ggenovese,

When I add the Academic Plan into my fixed function partition, it would only give me one Term/semester because only the last Term have the Academic plan of bachelor's degree. The rest Terms have null Academic Plan. I tried doing this but it still gives me the same result as above.

Do you have any other suggestions?

ggenovese

Can you provide a sample of your data?