2 Replies Latest reply: Jun 13, 2018 3:00 AM by Prasad P RSS

    Repeat Case Analysis - 7days (Above & Below - Dates)

    Prasad P

      Count of repeat cases for past 7 days and next 7 days interval. count will varry day by day.

       

      Example Data:

         

      Sn NoDateCase
      11/1/201823456
      21/1/201834567
      31/1/201867891
      41/1/201891011
      51/1/201891011
      61/2/201801234
      71/2/201823456
      81/2/201834567
      91/2/201867891
      101/2/201891011
      111/2/2018131415
      121/3/201823456
      131/3/201834567
      141/3/201889101
      151/3/201889101
      161/3/201891011
      171/3/2018131415
      181/4/201801234
      191/4/201801234
      201/4/201812345
      211/4/201867891
      221/4/201889101
      231/4/201891011
      241/4/2018111213
      251/4/2018121314
      261/4/2018141516
      271/4/2018151617
      281/5/201812345
      291/5/201823456
      301/5/201845678
      311/5/201856789
      321/5/201878910
      331/5/2018111213
      341/5/2018121314
      351/5/2018131415
      361/5/2018141516
      371/6/201845678
      381/6/201856789
      391/6/201889101
      401/6/2018101112
      411/6/2018101112
      421/6/2018121314
      431/7/201812345
      441/7/201845678
      451/7/201845678
      461/7/201856789
      471/7/201856789
      481/7/201878910
      491/7/201891011
      501/7/2018131415
      511/7/2018141516
      521/7/2018151617