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)


      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!