Combining Duplicate Property Values in Mixpanel Insights

event · 2025-09-19T09:57:17.015Z

For instances where it 2 property values are the same, how can I combine them together in Mixpanel insight report

Combining Duplicate Property Values in Mixpanel Insights | Mixpanel Community

2 comments

· Sorted by Oldest

kapa.ai
APP
·
·
Please stand by event as I search the knowledge base. I normally take about 15 seconds or so. 👋
Feel free to ask a follow-up question once I've answered by mentioning me with @kapa.ai
kapa.ai
APP
·
·
If you want to treat two property values as the same in an Insights report, you have a few options depending on what you mean by “combine”: 1) Merge property names in Lexicon (admin-level, permanent mapping) - If you have duplicate property names (e.g., "Country" and "country") that should be one property, a project owner can merge them in Lexicon. After merging, Mixpanel recognizes them as a single property everywhere. [Lexicon merging]2) Create a Custom Property that normalizes or groups values (flexible, reusable) - Use Custom Properties to define a new property that maps multiple values into one canonical value (e.g., “US” and “United States” → “United States”). This lets you group “same” values on the fly and reuse the result across reports (Growth/Enterprise can save). [Custom properties] - Example logic you could build: IF Country IN ["US","United States"] THEN "United States" ELSE Country. (Built via the Custom Properties UI.)3) Use Custom Bucketing in Insights for ad‑hoc grouping - For a quick, report-local solution, use Custom Buckets to group multiple values into one bucket (e.g., “US, United States” → “United States”). This is useful when you only need the combination in a specific chart. [Advanced / Custom Bucketing]Notes: - If your goal is to compute a metric only when two different properties are equal (e.g., “Signup Country” equals “Current Country”), you can create a Custom Property that evaluates equality and then filter or break down by that result. The Custom Properties feature explicitly supports creating new properties by comparing different properties. [Custom properties]If you can share whether you’re merging property names, normalizing values, or creating an equality flag, I can suggest the exact steps in the UI.
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
APP
·
·
Please stand by event as I search the knowledge base. I normally take about 15 seconds or so. 👋
Feel free to ask a follow-up question once I've answered by mentioning me with @kapa.ai
kapa.ai
APP
·
·
If you want to treat two property values as the same in an Insights report, you have a few options depending on what you mean by “combine”: 1) Merge property names in Lexicon (admin-level, permanent mapping) - If you have duplicate property names (e.g., "Country" and "country") that should be one property, a project owner can merge them in Lexicon. After merging, Mixpanel recognizes them as a single property everywhere. [Lexicon merging]2) Create a Custom Property that normalizes or groups values (flexible, reusable) - Use Custom Properties to define a new property that maps multiple values into one canonical value (e.g., “US” and “United States” → “United States”). This lets you group “same” values on the fly and reuse the result across reports (Growth/Enterprise can save). [Custom properties] - Example logic you could build: IF Country IN ["US","United States"] THEN "United States" ELSE Country. (Built via the Custom Properties UI.)3) Use Custom Bucketing in Insights for ad‑hoc grouping - For a quick, report-local solution, use Custom Buckets to group multiple values into one bucket (e.g., “US, United States” → “United States”). This is useful when you only need the combination in a specific chart. [Advanced / Custom Bucketing]Notes: - If your goal is to compute a metric only when two different properties are equal (e.g., “Signup Country” equals “Current Country”), you can create a Custom Property that evaluates equality and then filter or break down by that result. The Custom Properties feature explicitly supports creating new properties by comparing different properties. [Custom properties]If you can share whether you’re merging property names, normalizing values, or creating an equality flag, I can suggest the exact steps in the UI.
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.