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.

  • giannzi
    giannzi Member

    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.

    image.png

    Do you have any other suggestions?

  • ggenovese
    ggenovese Coach

    Can you provide a sample of your data?

Categories