500 error from /insights/funnel when breaking down funnel by HogQL person property #14730
Description
Bug description
When trying to break a funnel down by the HogQL person.properties.$initial_os I get "no matching events for this query.
The POST to https://app.posthog.com/api/projects/6316/insights/funnel/ fails with a 500.
If I select "Initial OS" from the "Person properties" tab then the query runs OK.
The request payload was:
{
"insight": "FUNNELS",
"actions": [],
"events": [
{
"id": "IntroPageDisplayed",
"name": "IntroPageDisplayed",
"type": "events",
"order": 0
},
{
"id": "ProvidersPageDisplayed",
"type": "events",
"order": 1,
"name": "ProvidersPageDisplayed"
}
],
"new_entity": [],
"properties": [],
"filter_test_accounts": true,
"funnel_viz_type": "steps",
"exclusions": [],
"breakdown": "person.properties.$initial_os",
"breakdown_type": "hogql",
"client_query_id": "2f5420e6-3a1d-40f1-a170-63764955d72a",
"session_id": "**REMOVED**"
}The response payload was:
{
"type": "server_error",
"code": "error",
"detail": "A server error occurred.",
"attr": null,
"error_event_id": "3ffc0332003e448581b1464334444227"
}How to reproduce
- Goto
https://app.posthog.com/insights/new - Click the "Funnels" tab.
- Add event 1 as "IntroPageDisplayed"
- Add event 2 as "ProvidersPageDisplayed"
- Click "+ Add breakdown"
- Enter the HogQL
person.properties.$initial_os
Environment
- PostHog Cloud US, project ID: 6316
Additional context
Slack thread in #community-support - https://posthogusers.slack.com/archives/C01GLBKHKQT/p1678724181826419