Calculating Ratio of Two Funnel Behaviors in Insight Report

Hi, I have two funnel behaviours saved (sum of revenue in each of them but different filtering). I want to count ratio - I mean funnel behaviour 1 / funnel behaviour 2 * 100. How can I do it? I cannot choose them (list of events) when I create insight report.

2 comments

kapa.ai
APP
·
·
Hi Monika, 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
kapa.ai
APP
·
·
To calculate the ratio between two saved funnel behaviors in Mixpanel, you can use the Formula feature in the Insights report. Here's how you can do it:1. In the Insights report, click on "+ Metrics" and select "Formula" Insights: Visualize trends and compositions within your data.2. In the Formula menu, you should be able to select your saved funnel behaviors. If you don't see them immediately, look for an option to load existing behaviors Loading a Saved Behavior.3. Once you've selected your two funnel behaviors, you can create a formula using them. The formula would look something like this: (Funnel Behavior 1 / Funnel Behavior 2) ** 1004. Mixpanel supports basic arithmetic operators for formulas, including division (/) and multiplication (**) Insights: Visualize trends and compositions within your data.5. After creating your formula, you can rename it for easier reference in the future.If you're unable to see your saved funnel behaviors in the Formula menu, it's possible that there might be some limitations or settings preventing this. In that case, I recommend reaching out to Mixpanel support for specific assistance with your account setup.Remember that formulas can't reference other formulas, so make sure you're using the base funnel behaviors in your calculation Insights: Visualize trends and compositions within your data.
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.