Well. I thought that worked. After testing it this morning, we found that several entries that were not empty were shown (but shown with no data) when they should not have been. so I'm back to figuring out the WHERE clause approach.
I entered advanced setting and changed the query to the below and it shows no results at all, neither complete or incomplete entries, just zero entries.
WHERE leads.estimator = ''
ORDER BY jobtype DESC