Comparing categorical fields in two different tables
I have one table with a list of all users using an app. Another dynamically generated column in a straight table that generates a list of users who have used the app in the recent past based on Date, Minute, Week, Hour etc.
I need to create another field that shows all the users who are NOT using that app even if they have access. I want to do something like ALL USERS - Users logged in = Users not logged in.
Also, I want to see these results based on the filters, i.e Date, Month, Hour etc.