Question
How to return account values that are included in one table but not in another for a specific range of dates in Tableau Desktop.Using SQL, the following query would achieve the desired result:
SELECT AccountName FROM Accounts
WHERE AccountId NOT IN (SELECT AccountId FROM LoggingTable WHERE Date > 2016-08-01)
WHERE AccountId NOT IN (SELECT AccountId FROM LoggingTable WHERE Date > 2016-08-01)