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

# Nested LOD, or another approach?

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,

Annay

• ###### 1. Re: Nested LOD, or another approach?

Hi Annay,

Not sure....but find my approach as reference below and stored in attached workbook version 9.3

First year: {fixed[student id],[program]:min( [Date])}

At the same time find here link on Cohort Analysis

1 of 1 people found this helpful
• ###### 2. Re: Nested LOD, or another approach?

HI

your issue is solved check the attachment.

• ###### 3. Re: Nested LOD, or another approach?

Thank you so much, Norbert. Such an elegant and simple solution!

EDIT: This approach is very helpful in calculating general retention at the program level. However, I still need help with a part of the problem. Specifically, I need to calculate retention of students new to program into the second calendar year, for only those students who registered in the second year (status = "registered" in first year +1).

Appreciate any ideas

• ###### 4. Re: Nested LOD, or another approach?

While your workbook does calculate retention since first year, I also need to take account of the first year in any given program, since students can switch programs.

Best,

Annay

• ###### 5. Re: Nested LOD, or another approach?

Hi Annay,

NICE:) Glad I could help out! Thanks for the "Awards".