2 Replies Latest reply on Sep 13, 2018 11:58 PM by Huey Shin Tan

    Get initial cohort numbers

    Huey Shin Tan

      Hi,

      Am still new to LOD but I believe ut can be done using that.

      This is my dataset :

         

      RPT_MTHCohortStudentCntInitial Cnt%
      Jan-172017S144100%
      Jan-172017S244100%
      Jan-172017S344100%
      Jan-172017S444100%
      Feb-172017S13475%
      Feb-172017S23475%
      Feb-172017S33475%
      Mar-172017S22450%
      Mar-172017S32450%
      Jan-182017S31425%

       

      Scenario :

      I want to track the number of active students and the % of student still remaining by Cohort (Column B) over time (Column A). I am trying to get Columns E so that I can calculate Column F (Cnt / Initial Cnt). I can get the initial numbers in the earliest reporting month for each Cohort by {FIXED Cohort : min(Rpt_Mth)}.

      Then I am stuck. I am not sure how to get the count for this earliest month (Column E) before I can get the % (Column F).

       

      Any advise is appreciated.

      Thanks much!