Support multiple formulas in Trends

[samwinslow]

From a user, it would be nice to have the ability to:

1. Retain the formula and original metrics in the same graph. Adding a formula should not "reduce" the series down to the formula line but rather show it alongside. This may not be what everyone expects so the option to toggle may be important.
2. Support more than 1 formula on a graph.

Describe the solution you'd like

• Formulas displayed as discrete graph series items (i.e. you'd press Add Graph Series to create).
• By default, adding formula(s) would dim / reduce opacity of the source series but not remove them. User can always hit the ☑️ checkbox to remove unwanted series.

Describe alternatives you've considered

Additional context

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

[Twixes]

+1 from ZEN-3896

[ramnes]

From what I've seen so far, this is PostHog's biggest shortcoming compared to Mixpanel. (But don't get me wrong, PostHog is impressive!)

Is there any workaround?

[Gursukh]

+1

[nicollegah]

This would be great! +1

[natasha-landa]

+1

[kdawgwilk]

I think a better solution would be to support a formula per graph variable along side the current aggregate formula. A concrete use case for example is I want to compute AI token costs. Each model has its own pricing and so i want to use a formula to support computing the cost on each model as a graph variable so that way I can see a breakdown of the costs per model. Right now i have to create a unique insight per model. I can get a total costs as is. Or i could go to SQL. I would prefer to use the trends UI though

[JorienDialog]

+1

[natasha-landa]

We were able to work around it while still using the Trends UI by aggregating events by HogQL expression. If the formula uses data from multiple events, "All events" can be selected as series.

[Kiopsy]

+1 🥲

[reddavis]

+1 🙏

[rajephon]

+1

[baysaageorg]

+1

[thisismikovic]

+1

[Raj1v]

+1

[SofieKatan]

+1 would be nice if you could add formula as a graph series

[cojo]

+1 - this is a major issue for us as well and we would expect it given that Amplitude, Mixpanel, and others all have clear ways to accomplish this goal in their charts.

[vignesarul]

+1

[Edofo]

+1

[Fralleee]

+1

[andyvan-ph]

Good news folks, we now support multiple formulas, so go wild! :)

[kdawgwilk]

@andyvan-ph If you give a ~~mouse~~ hedgehog a cookie... 😅 I would love to be able to name each formula output