Forum Discussion
Solved
Filter Out Rows Given List of Values
Background: We're a trucking company. Driver retention is a big issue for us so, I'm creating some retention analytics for the company to use. I'm working on a count of active drivers given a time co...
In the event anyone else runs across this, this is how I resolved my issue.
I never did figure out how to use NOT with IN to filter out the reason codes listed in the example.
I returned to the SQL that created this data and added a Y/N column of "Activated". Any driver with one of the codes listed was never activated. I then filtered by only including those with a 'Y'.
In the event anyone else runs across this, this is how I resolved my issue.
I never did figure out how to use NOT with IN to filter out the reason codes listed in the example.
I returned to the SQL that created this data and added a Y/N column of "Activated". Any driver with one of the codes listed was never activated. I then filtered by only including those with a 'Y'.