This content has been marked as final. Show 3 replies
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 ID||Log ID||Date of Log||Was 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!