1 Reply Latest reply on Nov 29, 2016 5:46 PM by Shinichiro Murakami

    Retention Data Help - How to Check if a Field has a Value or Not

    Kristie Wirth

      Hi all,

       

      I'm trying to run retention numbers for my school, and I'm not sure how to do this in Tableau.

       

      I attached the Excel document that shows what my data looks like when it comes out of our database. I just have students IDs and the list of all semesters they were enrolled.

       

      What I need to do is use this dataset to compute multiple kinds of retention rates:

      • Of those students enrolled in 200650 - what percent enrolled in 200730 and what percent did not enroll in 200730?
      • Of those students enrolled in 200730 - what percent enrolled in 200950 and what percent did not enroll in 200950?

       

      Thank you so much for any help!