how to show a formula % growth over time in a graph
how to show a formula % growth over time in a graph
how to show a formula % growth over time in a graph
Hi event, 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
To show a formula representing percentage growth over time in a graph in Mixpanel, follow these steps: 1. Create a Formula Metric: In the Insights report, click the Metrics button and select Formula. Use arithmetic operators to define your growth formula. For example, to calculate percentage growth between two metrics (A and B), you might use:
```LBKS This will display the percentage change from A to B. You can use constants and arithmetic as needed to express your growth calculation. You can also rename the formula for clarity within the report.LBKS2. **Visualize Over Time**: By default, Insights displays results as a line chart, which is ideal for showing trends over time. Ensure your date range and time granularity (e.g., daily, weekly, monthly) are set appropriately to visualize the growth trend.LBKS3. **Compare to Past**: To highlight growth, you can use the **Compare to past** feature to compare your formula metric to a previous period (e.g., previous week or month). This can help you visualize how your percentage growth changes over time.LBKS4. **Save and Reuse (if available)**: If you are on a Growth or Enterprise plan, you can save your formula for reuse in other reports. Free users can create formulas locally within a report but cannot save them for reuse elsewhere.LBKS**Example Formula for % Growth:**LBKS```LBKS((CurrentPeriod - PreviousPeriod) / PreviousPeriod) ** 100LBKS```LBKSReplace `CurrentPeriod` and `PreviousPeriod` with the appropriate metrics or events in your Mixpanel project.LBKS**Note:** You cannot nest formula metrics within other formulas. Also, formulas can be visualized in any supported chart type, with line charts being the most common for trends over time.LBKSFor more details, see the documentation on formulas and time period comparisons in Insights: [Mixpanel Insights: Advanced Features](https://docs.mixpanel.com/docs/reports/insights#advanced) and [Mixpanel Insights: Basic Features](https://docs.mixpanel.com/docs/reports/insights#basic-features).
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.
Let me check the knowledge base for you again. One moment! đź“š
To clarify, in Mixpanel, when you want to show percentage growth over time (for example, last week was 10% and this week is 15%), you typically want to plot the value of your metric (e.g., a conversion rate or other percentage) for each time period (week, day, etc.) on a line chart. Mixpanel will automatically show the trend over time for that metric.If you want to show the change (growth) in that percentage from one period to the next (e.g., from 10% to 15%, the growth is 5 percentage points, or a 50% increase), you can use Mixpanel’s Compare to Past feature. This allows you to compare the current value to a previous period and see the difference or percent change directly on the chart.How to do this in Mixpanel:Note: In Mixpanel, you do not need to manually create a formula for this comparison; the “Compare to past” feature handles it for you and displays the percent change over baseline directly in the UI see documentation.If you want to plot the actual percentage metric (e.g., conversion rate) over time, just select your metric and set the time granularity. If you want to see the week-over-week growth, use the “Compare to past” feature.If you need to create a custom formula for a percentage metric (not the growth), you can do so using the formula builder, but for period-over-period growth, use the built-in comparison tools see more.Let me know if you need step-by-step instructions for a specific metric!
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.
Let me check the knowledge base for you again. One moment! đź“š
Yes, this is possible in Mixpanel. You can visualize your percentage metric (e.g., 20% now, aiming for 100%) over time using an Insights report. Here’s how you can do it: 1. Create or select your percentage metric (for example, a conversion rate or any other percentage-based metric). 2. Set the time granularity (e.g., daily, weekly) so you can see how the percentage changes over time as a line chart or another suitable visualization. 3. Add a target line: While the knowledge sources do not explicitly mention a built-in “target line” feature, you can visually compare your metric’s trend to your target (e.g., 100%) by observing the chart. Some users annotate or manually note the target for reference.This approach allows you to track your progress toward your goal (e.g., from 20% to 100%) and see how close you are to reaching it over time. You can also use the Compare to past feature to see how your metric is improving period over period, but for tracking against a fixed target, simply plotting the metric over time is the recommended method in Mixpanel Docs: Insights Overview Docs: Insights Basic Features.If you need to highlight the target more clearly, you may consider exporting the data and adding a reference line in another tool, as the knowledge sources do not mention a native target/goal line feature.
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.
Let me check the knowledge base for you again. One moment! đź“š
Based on the available knowledge sources, Mixpanel does not natively support adding a fixed target value directly into a formula and then automatically plotting the percentage change toward that target over time. You can: - Plot your percentage metric over time using the Insights report and set the time granularity (e.g., daily, weekly) to see how your metric trends. - Use the Compare to past feature to see period-over-period changes, such as week-over-week growth, but this compares to previous actual values, not a fixed target Docs: Insights Advanced Docs: Features Advanced.However, the knowledge sources do not mention a feature where you can set a target value (e.g., 100%) in a formula and have Mixpanel automatically calculate and display the percentage of progress toward that target over time. There is also no mention of a way to add a reference or goal line to the chart within Mixpanel.If you need to visualize progress toward a target, you would need to manually compare your metric’s value to your target outside of Mixpanel, or visually estimate it on the chart.I'm sorry, but the knowledge sources do not contain information about a built-in way to calculate or display "% to target" over time within Mixpanel formulas.
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.
Let me check the knowledge base for you again. One moment! đź“š
Based on the knowledge sources, Mixpanel does not have a built-in feature to set a fixed target value within a formula and automatically plot "% to target" over time. However, here are possible ways to approximate or refine this analysis using Mixpanel’s available features: 1. Formula Calculation (Manual Target Reference): - You can create a formula that divides your metric by your target value and multiplies by 100 to express progress as a percentage. For example, if your metric is "Conversion Rate" and your target is 100%, your formula would be:
```LBKS If your target is something other than 100%, replace `1` with your target value (e.g., for a 50% target, use `0.5`). This will show your progress toward the target as a percentage over time. However, the knowledge sources do not explicitly confirm that you can use constants in formulas in this way, so this may require testing in your Mixpanel environment [Docs: Insights Advanced](https://docs.mixpanel.com/docs/reports/insights#advanced).LBKS2. **Visual Comparison:**
- Plot your percentage metric over time in an Insights report. While Mixpanel does not support adding a reference or goal line natively, you can visually compare your metric’s trend to your target by observing the chart. This is the standard approach described in the documentation [Docs: Insights Overview](https://docs.mixpanel.com/docs/reports/insights).LBKS3. **Annotations or Export:**
- If you need a more explicit reference to your target, you can export the data and add a target line in an external tool, or use chart annotations if available.LBKS4. **Compare to Past:**
- Use the "Compare to past" feature to see how your metric is improving period over period, which can help you understand the rate of progress, though not directly "% to target"Â [Docs: Features Advanced](https://docs.mixpanel.com/docs/features/advanced#comparison-time-baseline-and-overall).LBKS**Summary:*
While Mixpanel does not natively support a "% to target" visualization, you can approximate it by dividing your metric by your target in a formula (if supported), or by visually comparing your metric’s trend to your target on a line chart. For more advanced target tracking, you may need to use external tools.LBKSIf you need step-by-step guidance on setting up a specific formula, let me know!
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.