Group data by quarter as well as month

[pauldambra]

Is your feature request related to a problem?

https://posthogusers.slack.com/archives/C01GLBKHKQT/p1652185607954579

In this community slack message a user asked if it was possible to group by quarter instead of month

Describe the solution you'd like

Trends, stickiness, and lifecycle insights all allow grouping by interval (hour, day, week, or month). Add grouping by quarter

additional context

related ticket: https://posthoghelp.zendesk.com/agent/tickets/5110

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

[pauldambra]

cc @clarkus

[clarkus]

Related https://github.com/PostHog/product-internal/pull/305

[clarkus]

I think it makes sense to include a quarterly option here in addition to the other options shown. I don't want to drop months because those are generally more applicable than quarters.

[MarconLP]

additionally the grouping option "two weeks" would be useful: https://posthoghelp.zendesk.com/agent/tickets/5110

[maxprilutskiy]

Having the option to group biweekly would be just amazing!

[vrcprl]

The "two weeks" option sounds fantastic! In a perfect situation, it would be really nice to have an extra dropdown where we can pick a number. Then, we could keep the dropdown for the time period, and choose things like '11 days' or '3 weeks'. That would be just what we need!

[MarconLP]

Our HogQL feature actually does a really good job of handling the sort of breakdowns. Checkout this short tutorial on how to do it! Note: You might need to wrap the entire HogQL query in toString(). Additionally this can count unique users multiple times if a higher frequency than month is being used.

[MarconLP]

+1 https://posthoghelp.zendesk.com/agent/tickets/8254 group by year

[abigailbramble]

+1 group by 90 days https://posthoghelp.zendesk.com/agent/tickets/19809