Feature request: Lookup table for breakdown values #42825
Description
Feature request
Is your feature request related to a problem?
Requested by a customer, and a few others have asked for this too:
Vitally: Add static mapping of strings to make insights more understandable
Describe the solution you'd like
Being able to add a lookup table so that the insight displays the lookup value(s) in addition to (or instead of) the original breakdown value. Examples:
- Breakdown by status code, should also show the status name (404 -> "Not found")
- Breakdown by city for display in a world map ("Munich"-> "de")
Describe alternatives you've considered
The lookup could be done:
a) at query time from a joined table
b) when assembling the response from a backend model
Debug info
- [ ] PostHog Cloud, Debug information: [please copy/paste from https://us.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]