I have an event with a property which is an object. Is there a way for me to breakdown the event by the fields within the object?
Hi Howard A., 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
Mixpanel supports object properties in a limited capacity. In the Mixpanel UI, you can use object properties as filters and breakdowns in core reports (such as Insights, Funnels, Flows, Retention, Users/Cohorts, and Events). However, you cannot directly select or reference the individual fields (keys) within an object property for breakdowns in the UI—property names within an object are not supported in Lexicon, and thus are not directly accessible for breakdowns or filtering by their subfields in the standard UI experience Supported Properties Data Type - Overview.If you are using JQL (JavaScript Query Language), you can access fields within an object property using dot notation in your groupBy keys. For example, if your event property is an object like {"info": {"size": "XL"}}, you can group by ["info.size"] to break down by the size field within the info object groupBy keys & reducer functions.Summary:
- In the Mixpanel UI: You can break down by the object property as a whole, but not by its individual fields.
- In JQL: You can break down by fields within an object using dot notation.If you need to analyze by object fields and are not using JQL, you may need to adjust your data model to send those fields as top-level properties.
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.
