how can i reference a foprmula inside another formula? how do I reference calculated metrics inside a formula? how do I reference calculated metrics inside another report?
Hi Tobias, Please stand by as I search the Mixpanel knowledge base for an AI-powered answer. I normally take about 15 seconds or so. In case AI cannot answer your question, feel free to reach out to Mixpanel support at mixpanel.com/get-support. If you have follow-up questions for this thread, please tag me again with your question: @kapa.ai <follow-up question> đź‘‹
Feel free to ask a follow-up question once I've answered by mentioning me with @kapa.ai
I'm sorry, but according to the knowledge sources, you cannot nest a formula metric inside another formula in Mixpanel. When constructing a new formula, you can only reference the base metrics (such as events, profiles, funnels, retention, or cohorts) that are present in your report, not other formulas. Specifically: > To note, you cannot nest a formula metric when constructing another formula.
...A saved formula can’t reference another formula ...When a saved metric is updated, it will update across all reports it’s being used in Docs / Reports / Insights: Visualize trends and compositions within your dataFor referencing calculated metrics (like formulas, funnels, or retention metrics) inside another report, you can save these behaviors (if you are on a paid plan) and then reuse them across reports. However, this applies to funnel and retention behaviors, not formulas: > Once you’ve drilled down your reporting to identify a specific user behavior, you can now save a funnel or retention behavior definition and reuse it across your reports. Blog / More analysis and customization: Here’s what you can do with Mixpanel’s latest featuresIn summary: - You cannot reference a formula inside another formula.
- You cannot reference calculated metrics (formulas) inside another formula. - You can save and reuse funnel and retention behaviors across reports, but not formulas.If you need to use a complex calculation, you must build it as a single formula using the available base metrics in your report.
kapa.ai is still learning and improving, please let me know how I did by reacting below.
ℹ️ Tip: Mention @kapa.ai in the thread for follow-ups or DM the app for 1-to-1 help.