Dashboards - filtering by "doesn't contain" does not work.

[geng0610]

Bug Description

Bug description

internal users aren't filtered out from the dashboard by using "Filter out internal and test users" option when using email "contains" as an exclusion criteria.

Please describe. If this affects the front-end, screenshots would be of great help.

How to reproduce

1. Add a filter for email doesn't contain xx
2. Save and apply the filter
3. Click on an event to see the list of users and confirm that the those applicable aren't filtered out

Additional context

Seems like a very similar issue as this. https://github.com/PostHog/posthog/issues/23655

Debug info

- [ ] PostHog Cloud, Debug information: [please copy/paste from https://us.posthog.com/settings/project-details#variables or https://eu.posthog.com/settings/project-details#variables]
- [ ] PostHog Hobby self-hosted with `docker compose`, version/commit: [please provide]
- [ ] PostHog self-hosted with Kubernetes (deprecated, see [`Sunsetting Kubernetes support`](https://posthog.com/blog/sunsetting-helm-support-posthog)), version/commit: [please provide]

[ngryman]

For me none of the filters work anymore when using a person's property.

[sdbarrington]

For anyone coming across this from google (like me), they recently added this to their docs which fixed the problem for me.

[RobbieMcKinstry]

Unfortunately, I don't believe that suggestion works any long, as PostHog no longer lets you update queries using the cohort property, since the property is not calculated by the time the event is created.

[kyleswank]

It appears filtering internally does work but inconsistently.

I checked a simple Pageview trend insight that had internal users for several days. There were three days where there was only one internal user, which was properly removed. I had one other day that had 3 internal users, only one was removed and two remained. On an incomplete day (current date) there was 2 internal users and it removed both. Until this last day it did appear it was just removing the first instance of an internal user but keeping all others but the last day seems to disprove that theory.