Analyzing Events by Numeric Property for Frequency Distribution
Is there a way to analyze events based on a property? For example, to get a frequency distribution of a numeric property
Hi Jofred C., 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
Yes, Mixpanel provides several ways to analyze events based on properties, including getting frequency distributions of numeric properties. Here are some relevant methods:1. Aggregate Property: In Insights, you can use the "Aggregate Property" measurement to analyze numeric property values across events. This allows you to calculate sum, average, median, percentiles, minimum, and maximum of a numeric property. Docs Reports > Insights: Visualize trends and compositions within your data> provides details on these calculations.2. Aggregate Property per User: This measurement allows you to analyze property values on a per-user basis, which can be useful for understanding distributions. You can calculate sum, average, distinct count, minimum, and maximum per user, and then further aggregate these results. Docs Reports > Insights: Visualize trends and compositions within your data> explains this feature.3. Breakdowns: You can use the breakdown feature to segment your data by property values. This is particularly useful for understanding the distribution of events across different property values. Docs Reports Overview> describes how to use breakdowns.4. Custom Buckets: For numeric properties, you can use custom buckets to group values into ranges, which is helpful for creating frequency distributions. Docs Reports > Insights: Visualize trends and compositions within your data> mentions this feature.5. JQL (JavaScript Query Language): For more advanced analysis, you can use JQL. The
mixpanel.numeric_bucket()function can be used to segment events over numeric ranges. Docs Reports > Apps > JQL Builtins> provides examples of how to use this function.These features allow you to analyze events based on properties and create frequency distributions of numeric properties in various ways, depending on your specific analysis needs.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.