I want to analyse how many of our customers in Plan A have feature X enabled. I can do this by looking at User Profiles in an Insights Report, and filtering the Plan Type, as well as filtering on the Feature Name. Is there any way I can look at this with percentages? E.g., of all people in Plan A, 25% have feature X enabled. Instead of just looking at an absolute number. The "% Percentage" in the Compare button is disabled.
Hi Janine, 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
You are correct that in Mixpanel Insights, you can filter User Profiles by Plan Type and Feature Name to see the absolute number of users who have feature X enabled within Plan A. However, if you want to see this as a percentage of all users in Plan A (e.g., "25% of Plan A users have feature X enabled"), the built-in "% Percentage" comparison in the Compare button is not always available for profile-based metrics, which matches your observation.Workaround using Formulas:How to do this:
- Click the Metrics button, add your two metrics as described above.
- Then click + Formula, and use the variable letters (e.g., A and B) to build your formula: A / B ** 100.
- You can rename the formula for clarity (e.g., "% of Plan A with Feature X").This approach gives you the percentage you’re looking for, even when the "% Percentage" option in the Compare button is disabled for profile metrics. Note that you cannot nest formulas, so keep each calculation direct and simple Docs: Insights Advanced.If you are on a free plan, you can create formulas within a report but cannot save them for reuse; saving formulas is available on Growth and Enterprise plans.Summary:
Use the Formula feature in Insights to calculate the percentage of users in Plan A who have feature X enabled, as the "% Percentage" comparison is not always available for profile metrics. This method is supported and recommended for your use case.Docs: Insights Advanced
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 create your own metric in Mixpanel Insights that sums the data of property value A and property value B, you can use the Formula feature. Here’s how you can do it: 1. Add the two metrics:
- In your Insights report, add Metric A (e.g., the sum of property value A).
- Add Metric B (e.g., the sum of property value B).2. Create a Formula:
- Click the Metrics button, then select + Formula.
- Each metric you added will be assigned a letter (e.g., A and B).
- In the formula editor, enter A + B to sum the two property values.
- You can rename the formula for clarity.This will create a new metric that is the sum of property value A and property value B. You can use arithmetic operators like +, -, **, and / in formulas, and you can use numbers as constants if needed. Note that you cannot nest formulas within other formulas Docs: Insights Advanced.If you want to save this metric for reuse, you’ll need to be on a Growth or Enterprise plan.**Summary:*
- Add each property value as a separate metric.
- Use the Formula feature to sum them: A + B.For more details, see the documentation on Formulas in Insights.
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, you can create a Saved Formula in Mixpanel, which will be available from the "Metrics" menu across your entire project—not just in a single report. This allows you and your team to reuse the formula metric anywhere, ensuring consistency and saving time.How to create a Saved Formula:Summary: - Create your formula in Insights. - Save it as a metric for global reuse. - Access and manage it from the Metrics menu and Lexicon.This ensures your custom formula is standardized and available project-wide.
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.
kapa.ai Is there any way to change the chart colours of a bar chart so that I can make sure the colours are always the same for each entry, and not different per property? For example, I have bar chart 1 with 3 properties, where 'login' is the highest. However, in bar chart 2 with the same 3 properties but different filtering, the 'app_login' is higher than in the other bar chart. Ideally, I can make sure that 'login' gets pink in both of these graphs, regardless of their position in the graph. Same goes for 'app_login'.
Let me check the knowledge base for you again. One moment! 📚
Yes, you can customize the chart colors in Mixpanel so that each segment (such as 'login' or 'app_login') always uses the same color across different charts, regardless of their order or value. This is done through the Segment Coloring feature.To do this: 1. Select a segment from the legend in your bar chart. 2. Set the color for that segment. By default, Mixpanel assigns colors automatically, but you can override this by choosing a specific color for each segment. You can pick a color from the current theme or select a custom color. 3. Repeat for each segment you want to standardize.This ensures that, for example, 'login' is always pink and 'app_login' always has your chosen color, no matter their position in the chart or the filtering applied.> Note: Segment coloring is available in both Boards and individual reports.For more details, see the documentation on Segment Coloring.Important: Full theme and color customization (including creating and saving custom color themes) is only available on the Enterprise plan. However, setting segment colors in individual reports and boards is supported as described above Chart Customization Availability.
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.
