PostHog / posthog

🦔 PostHog provides open-source product analytics, session recording, feature flagging and A/B testing that you can self-host.
https://posthog.com
Other
19.39k stars 1.13k forks source link

Feature Request: allow viewing day-by-day retention for full period without truncation #23355

Open skoob13 opened 4 days ago

skoob13 commented 4 days ago

Feature request

Is your feature request related to a problem?

It's not possible to view day-by-day retention for each date in the period in the retention insight because it truncates data points even if there is already data for them.

For example, users who registered between May 1 and May 15 would have already produced a 30-day retention rate on July 1st. If I want to know the 30-day retention rate for users who registered on each day from May 1 to May 15, it's not possible to see it because we show data up to the end date (May 15) truncating columns.

Filters

Screenshot 2024-07-01 at 10 23 12

Retention Insight

Screenshot 2024-07-01 at 10 05 09

May 15th has only 16-day retention.

Describe the solution you'd like

We'd like to see 30-day retention for all dates. We could add a checkbox that changes the truncation behavior.

Describe alternatives you've considered

Additional context

Requests from users:

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]