How to Display Average Events Per Day in KPI Metric View

Lloyd N. · 2025-12-11T04:23:51.590Z

Hi. I can't figure out how to simply display, in a KPI/metric view, the average number of events per day over a period of time. My current case is to track the average searches a user does per day (within a date range, i.e. from Dec 4th to today). I can calculate it in a line chart easily and the table under the line chart shows the average, but I can't figure out how to display just that average per day value. thanks!

How to Display Average Events Per Day in KPI Metric View | Mixpanel Community

10 comments

· Sorted by Oldest

kapa.ai
APP
·
·
Hi Lloyd 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
kapa.ai
APP
·
·
You’re looking for a single KPI that represents: > (Total searches in the date range) ÷ (number of days in the date range)rather than the per‑day series you see in the line chart.The provided docs explain how Mixpanel can compute averages and aggregate properties, but they don’t explicitly describe a way to show only the overall “average per day” as a single KPI/metric tile in Insights. They focus on: - Per‑interval trends (line chart) and aggregations like Sum/Average over event properties [Measurements; Aggregate Property]. - Analysis settings like Rolling Average and Cumulative, which still operate on a time series, not a single KPI [Analysis settings].Because of that, I can’t confidently confirm from the docs that there is a built‑in “show this series as a single KPI number = average per day over the range” toggle in the UI.Given what is documented, the closest supported approaches are: 1. Use the line chart + table and read the average from the table This is what you’re already doing: Insights can show averages and other aggregations over the series in the table below the chart, but the docs don’t show a way to promote that specific aggregate into a standalone KPI tile.2. Use a formula metric (if you’re on Growth/Enterprise) to approximate Formulas let you combine metrics with arithmetic (add, divide, etc.). [Formulas] However, the docs only describe formulas over existing metrics (e.g., DAU/MAU), not a direct “events ÷ number of days in range” function, and they don’t show a way to collapse that to a single KPI either.Because the documentation doesn’t explicitly cover a “KPI view of average events per day over a range,” I can’t give you a guaranteed in‑product click path to do exactly that as a single number.If you need that exact KPI: - Continue using the line chart and read the average from the table, or - Export the data (or use the Query API / JQL) and compute the average externally. The Query API supports average counts and aggregations over time buckets, but again returns a series rather than a single KPI [Segmentation query; JQL reducers].If you can share a screenshot of your current Insights setup (measurement, breakdowns, etc.), I can suggest the most precise configuration possible within those documented capabilities.
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.
Ansh A.
·
·
Lloyd N. There should be a time filter from which you can have unique days, and divide total search by it to get average per day.
Lloyd N.
·
·
Ansh A. Thanks for your suggestion. That would definitely resolve this but I can't figure out how to create unique days. Since time is only a property, I don't think I can create a metric giving me just the count of unique days.
Ansh A.
·
·
Lloyd N. When you choose time, it'll allow you to choose if you want to calculate unique days, months, etc.
Lloyd N.
·
·
Ansh A. I'm so sorry, but I just can't figure this out. Where should I be to calculate the unique days, months, etc? I can only find 'time' in the filter that filters the total events by a time period but I can't insert it like a time metric where i can use it in a formula as a denominator.
Lloyd N.
·
·
this is what i see now:
Ansh A.
·
·
See this, does this help?
Lloyd N.
·
·
OMG! Yes. that worked. Thanks
Ansh A.
·
·
Amazing.

kapa.ai
APP
·
·
Hi Lloyd 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
kapa.ai
APP
·
·
You’re looking for a single KPI that represents: > (Total searches in the date range) ÷ (number of days in the date range)rather than the per‑day series you see in the line chart.The provided docs explain how Mixpanel can compute averages and aggregate properties, but they don’t explicitly describe a way to show only the overall “average per day” as a single KPI/metric tile in Insights. They focus on: - Per‑interval trends (line chart) and aggregations like Sum/Average over event properties [Measurements; Aggregate Property]. - Analysis settings like Rolling Average and Cumulative, which still operate on a time series, not a single KPI [Analysis settings].Because of that, I can’t confidently confirm from the docs that there is a built‑in “show this series as a single KPI number = average per day over the range” toggle in the UI.Given what is documented, the closest supported approaches are: 1. Use the line chart + table and read the average from the table This is what you’re already doing: Insights can show averages and other aggregations over the series in the table below the chart, but the docs don’t show a way to promote that specific aggregate into a standalone KPI tile.2. Use a formula metric (if you’re on Growth/Enterprise) to approximate Formulas let you combine metrics with arithmetic (add, divide, etc.). [Formulas] However, the docs only describe formulas over existing metrics (e.g., DAU/MAU), not a direct “events ÷ number of days in range” function, and they don’t show a way to collapse that to a single KPI either.Because the documentation doesn’t explicitly cover a “KPI view of average events per day over a range,” I can’t give you a guaranteed in‑product click path to do exactly that as a single number.If you need that exact KPI: - Continue using the line chart and read the average from the table, or - Export the data (or use the Query API / JQL) and compute the average externally. The Query API supports average counts and aggregations over time buckets, but again returns a series rather than a single KPI [Segmentation query; JQL reducers].If you can share a screenshot of your current Insights setup (measurement, breakdowns, etc.), I can suggest the most precise configuration possible within those documented capabilities.
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.
Ansh A.
·
·
Lloyd N. There should be a time filter from which you can have unique days, and divide total search by it to get average per day.
Lloyd N.
·
·
Ansh A. Thanks for your suggestion. That would definitely resolve this but I can't figure out how to create unique days. Since time is only a property, I don't think I can create a metric giving me just the count of unique days.
Ansh A.
·
·
Lloyd N. When you choose time, it'll allow you to choose if you want to calculate unique days, months, etc.
Lloyd N.
·
·
Ansh A. I'm so sorry, but I just can't figure this out. Where should I be to calculate the unique days, months, etc? I can only find 'time' in the filter that filters the total events by a time period but I can't insert it like a time metric where i can use it in a formula as a denominator.
Lloyd N.
·
·
this is what i see now:
Ansh A.
·
·
See this, does this help?
Lloyd N.
·
·
OMG! Yes. that worked. Thanks
Ansh A.
·
·
Amazing.