2 Replies Latest reply on Apr 17, 2018 7:37 AM by Brady Atomos

    Mean Percentage Change from First Semester

    Brady Atomos

      Hello,

      I have a student retention project that I'm working on and I've run into a brick wall.

      First I would like to calculate mean number of students in each cohort by relative semester.

      This is easy enough.

       

      But I'm running into problems when I want to take those mean values and calculate them as

      a percentage of the initial mean of the cohorts.

       

      I'm fairly new to Tableau so forgive me if this question has already been answered elsewhere.

      This is actually my first post!

       

      I've included an excel mock up of my data and how I would like to calculate it.

      What I'm having trouble with is the bottom row.

       

      Any help anyone could give would be greatly appreciated.

       

      Thanks.