search

PostHog / posthog

🦔 PostHog provides open-source web & product analytics, session recording, feature flagging and A/B testing that you can self-host. Get started - free.
https://posthog.com
Other
21.9k stars 1.31k forks source link

Saved Views: (ex. default filters for persons page) #19477

Open MarconLP opened 10 months ago

MarconLP commented 10 months ago

Is your feature request related to a problem?

When trying to search for persons, I do not care about users who haven't created an account that I have several filters for.

Describe the solution you'd like

The ability to add default filters for https://us.posthog.com/persons

Additional context

https://posthoghelp.zendesk.com/agent/tickets/8517

Thank you for your feature request – we love each and every one!

benjackwhite commented 10 months ago

I actually like this idea as a sort of generic "saved views"... Could work across many places in the UI...

mariusandra commented 10 months ago

We have plans to work on unifying the very similar listing pages for Events (EventsQuery), Persons & Groups (ActorsQuery), and other similar tables that are fed by HogQL. These queries follow similar patterns for filtering and column selection, which could then saved as views by users. Merging onto a common query type will help, but is not strictly needed for saving views.

For the event explorer, we now have a "Column Configurator", but due to the way it saves data, we can't reuse it on person pages. This should change as well.

mariusandra commented 10 months ago

The prerequisite for any of that is to actually move our person listing pages from the current postgres-based PersonsNode to the HogQL powered PersonsQuery. We can then truly reuse filters across the UI, as we don't need to merge different databases for results.

This migration to ClickHouse powered persons listings was started, but I ran into performance bottlenecks with one of our largest users (joining distinct IDs is slow, selecting all properties is slow). I have since updated the query to remove these bottlenecks (makes a second query to get the distinct_id and display properties), but haven't yet tested it on large customers.

It's a bad idea to release this before going off for a week, so I'll be for January.

MarconLP commented 10 months ago

+1 https://posthoghelp.zendesk.com/agent/tickets/8368

MarconLP commented 9 months ago

+1 https://posthoghelp.zendesk.com/agent/tickets/9767

mariusandra commented 9 months ago

Great news, since this week, the migration to PersonsQuery is complete. You can now add custom columns onto the person pages by clicking the "..." menu on the columns themselves.

What's missing is the column configuration dialog and an option to save the configured columns as a default. Work on that can now start, though it's not a current priority (getting the other insights converted to HogQL still is)

MarconLP commented 9 months ago

+1 https://posthoghelp.zendesk.com/agent/tickets/9695

darkopia commented 2 days ago

+1 https://posthoghelp.zendesk.com/agent/tickets/20245