Using Average on Beast Mode

giannzi
giannzi Member
in Magic ETL

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

image.png

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?

Tagged:

Comments

  • ggenovese
    ggenovese Coach

    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.

Categories