Hi Mark N., 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, it is possible to calculate standard deviation in Mixpanel, but only through JQL (JavaScript Query Language) queries, not directly in the standard UI reports.Mixpanel’s JQL provides a built-in reducer called mixpanel.reducer.numeric_summary(accessor), which returns a summary including count, sum, sum of squares, average, and standard deviation for a collection of numeric values. Here’s an example from the documentation: LBKSfunction main() { return Events({ from_date: "2015-10-01", to_date: "2015-10-02", event_selectors: [{event: "pageview"}], }) .reduce(mixpanel.reducer.numeric_summary('properties.load_time_ms')); }LBKSThis will return an object containing the standard deviation (stddev) among other statistics for the specified property. This functionality is not available in the standard Insights or other UI reports, but is accessible via JQL queries for more advanced analysis needs Docs: JQL Builtins.
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.
