Why do i lose virtually all records in a query dataset when I apply a filter using the analysis tool
Summary: i am trying to pull a report listing all those who are on the Basic life insurance Benefits. When I apply a filter based on Participant Enrollment Status to omit those who 'backed out' i end up with too few records. Before i apply the filter I get a recor count of over 700, as soon as i apply the filter it drops to 76 records.
Content (please ensure you mask any confidential information):
I am constructing an analysis to determine who in my organization has Basic Life insurance benefits offered by the company I work for. i am working in the 'Benefits - Enrollments Real Time' subject area