3 Replies Latest reply on Jul 31, 2018 6:09 AM by Zhouyi Zhang

    Identify Users that Were Inactive in the Past

    Goncalo Alemao

      Hello all,

       

      I was wondering if anyone could help me with a simples but yet tricky analysis.

       

      So, I want to identify all the users that were inactive at some point in the past, meaning that I would like to know all the users that were inactive for 1 month or more, at least once in their life.

      My database is displayed as the table below:

       

      User IDLog IDDate of LogWas he Inactive? (Column that I want to calculate)
      1101/01/2000Yes
      1202/01/2000Yes
      1605/02/2000Yes
      2305/01/2000No
      2415/01/2000No
      2525/01/2000No
      2710/02/2000No

       

      In conclusion, I want a Y/N column per User ID that tells me if the biggest Date Diff between logs is bigger than 1 month or not.

      PS: The dates may not be in chronological order.

       

      Thank you very much for your help!