Funnel query returns suspect results

[macobo]

Bug description

I'm trying to analyze conversion for funnels project using the following query:

However two things don't line up:

1. I see test users included in the output
2. The number of people who have finished the 2nd step does not match the people table, which shows fewer people

Expected behavior

1. Test users excluded
2. Number of people matches

How to reproduce

1. Run the above funnels query
2. Check results
3. See disparencies

Environment

• PostHog Cloud
• self-hosted PostHog, version/commit: please provide

Additional context

Thank you for your bug report – we love squashing them!

[timgl]

I'd suggest this is a duplicate of #3668

[EDsCODE]

Number doesn't match even without trying to filter test accounts. It could also be something where there's event data related to a number of users but somehow we weren't able to retrieve all of the person data for the table

[kpthatsme]

another data point re: person counts, I was looking at a steps chart earlier and I saw a user repeated twice within a funnel step when clicking into it

[macobo]

Weird - this query and others related seem to work for me now, both issues having disappeared.

[EDsCODE]

Large amount of this was resolved after @fuziontech redid the person_distinct_id table. Will close for now but monitor and reopen if necessary