I have a field that asks for Gender
When I filter by ‘Female’ or ‘Other’ the filter works correctly.
However, when I filter for ‘Male’, the filter returns all ‘Male’ and ‘Female’ rows.
My suspicion is that it is because male is a substring of female.
The filters should be searching by an option variable ideally, especially for ‘Select One’ or ‘Select Many’ questions but if you must do them by string matching, then it should be an exact match in these cases.