0 Replies Latest reply: Sep 13, 2012 2:24 PM by monydochev RSS

    % of users that logged yesterday but not logged today

      Hello, i have one table like that:

      DateUSERS_ID
      ID
      2012-05-221
      1
      2012-05-222
      2
      2012-05-223
      3
      2012-05-224
      4
      2012-05-231
      5
      2012-05-233
      6
      2012-05-234
      7
      2012-05-241
      8
      2012-05-242
      9
      2012-05-243
      10

       

      I want to known how many users logged yeasterday but not logged today

      for example

       

      for 2012-05-23 [1 user, 25%]

      for 2012-05-24 [1 user, 33.33%]