5 Replies Latest reply on Feb 6, 2017 7:15 AM by Norbert Maijoor

    Nested LOD, or another approach?

    Annay S

      Hi guys,


      Hoping for a little help. I'm working with student data, and for each program in each session year, I want to know how many of the students that were new to the program were also registered in the following session year.


      This way of calculating program retention that's a new approach for me. The retention information i need is about new students that start a program in any given year, and reference the their registration in the following year. I would like to display it in a similar way to what the workbook shows now, but only with counts of the first-year-in-program students that were retained to second year.


      I can calculate the first year for each student (in any program), but have trouble with calculating the first year that a student starts any specific program.


      Would appreciate any guidance.

      I'm working with Tableau 10.1.


      Thank you,