1 Reply Latest reply on Aug 2, 2017 4:41 PM by Deepak Rai

    Getting Tableau to aggregate data that falls outside of group

    Gavin H

      Hello,

       

      I am trying to calculate mean grade points for students that have not enrolled for a particular class, to contrast with those who have.

       

      The courses are separated as such, with columns that would ideally show: # that did not enroll, mean GPA did not enroll, # that enrolled, mean GPA for enrolled as such

       

      mockup.png

      (apologies for the edits).

       

      Basically, I want to be able to take all data from people not enrolled in course A, and average their grade points, and so on for course B, C, etc.. displayed on the same row of the course that I am comparing.