Using Average on Beast Mode

giannzi · 2025-02-20T03:49:09+00:00

There was an error rendering this rich post.

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?

Find more posts tagged with

Beast Mode

Comments

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?