Interpret an Insights Report

Mixpanel's Insights allows you to analyze your user data as a current snapshot or as a trend over time. This article explains how to interpret an Insights report. Learn about Insights report basics here. Learn about how to build an Insights report here.

Visualization Tools

In Insights, you can either choose to get a metric calculated across the entire time period selected in the date picker, or get a time-segmented view of the metric (e.g. daily breakdown). 

  • Metric calculated across the entire time period
    • Bar chartmceclip0.png
    • Stacked bar chartmceclip1.png


    • Pie chartmceclip2.png


  • Metric time-segmented
    • Line chartmceclip4.png
    • Stacked line chartmceclip5.png


You can easily resize the columns in the bar chart in order to see more or remove detail.


When breaking down results, click on a bar in the chart to either filter or exclude that property value. Filter zooms in on that property value, filtering the entire report to that property value. Exclude filters out that property value from the results.


Analysis & Value Settings

You can switch between Absolute and Relative totals by selecting the # dropdown in the top right of the chart and selecting either # Absolute or  % Relative.


You can only select Absolute or Relative values for the Table, Stacked Line, Stacked Bar, and Bar charts.


The Absolute view will show you, in numbers, your totals for different event counts. Relative view will display these counts as a percentage of the whole.

The Analysis options will determine the way the chart is calculated and visualized. The options are:

  • Linear: This is the standard view for the chart.
  • Rolling: Rolling analysis calculates the rolling average of the data set. A rolling average curve is a series of averages from subsets of data. Use rolling average analysis to remove noise or spikes from data and smooth out trends over time. Mixpanel calculates the rolling average based on the selected time interval (hour, day, week, month or quarter) for each data point in the graph.

    Time Interval

    Default Rolling Time Range

    Hour Last 12 hours
    Day Last 7 days
    Week Last 5 weeks
    Month Last 3 months
    Quarter Last 2 quarters
    For example, if you make a rolling analysis query for the past 30 days, Mixpanel calculates the rolling 7-day average by default. The value reported at each day in the line graph is the average of the values from the 7 days leading to that day. In the case of the first 6 days in your selected time period, the 7-day-average calculation will include days before the selected time period.
  • Logarithmic: A nonlinear scale based on orders of magnitude, rather than a standard linear scale, so the value represented by each equidistant mark on the scale is the value at the previous mark multiplied by a constant.
  • Cumulative: Adds up the values of each point on the graph as it goes along, so the height of the line will increase over time.


Bar chart

When you are viewing a bar chart, you have four different sorting options: A-Z Ascending, Z-A Descending, Value Ascending, or Value Descending. To switch sorting views, select the Events icon in the upper left hand of the report and select which view you would like to see.


Line chart

Line charts in Insights are accompanied with a table of values to give users another way to consume the trends information. This data table can also be sorted by clicking column headers.

Click on a "data column" header to sort by that column. Click the header again to reverse the sort order. The table below is sorted by event counts on August 2nd:


Results that are segmented (from one or more “group by” clauses in your query) have four different sorting options when you click on the "segment column" headers:

  • Segment Ascending: sort by segment name in ascending order. 
  • Segment Descending: sort by segment name in descending order. 
  • Value Ascending: sort by segment value in ascending order. 
  • Value Descending. sort by segment value in descending order.

When sorting by segments, the sort is carried out left to right.


Clicking on the "Average" data column performs a flat sort across all segments:


Time Period Comparisons

Compare the current period of time to previous periods of time in order to track trends and growth in your product’s use. Compare traffic from a specific campaign period or event from one year to the next, or compare the success of that campaign to your normal traffic.

Note that if a data point for a previous year falls on a weekend, the data point is automatically moved to the next Monday to give a more clear picture of the data change from one year to the next.

Click on the Compare to past button at the top of your Insights graph and select the time period you wish to compare to. You can also select a custom date range.



Insights will automatically group your high-cardinality segments into ranges. Ranges can be edited by using the "Customize Range" option in the overflow menu:


If you want custom buckets that are non-uniform, you can create custom properties to manipulate these buckets.


In order to clarify the results in your Insights report add detailed annotations directly to the line chart. Annotations are tied to a specific date on the chart, rather than a specific data point on the chart.

Only project admins can create, save, and delete annotations.

To add an annotation, hover your mouse over the point on the chart you want to annotate, and click the blue + button that appears.Enter a description for the annotation, such as a holiday that occurred on that day or the end date of your fiscal year, then click Save. If you accidentally selected the incorrect date on the chart, you can edit the date and time of the annotation in this window.


View an existing annotation by clicking on the number found at the bottom of a report. You will be able to see who submitted the annotation.


Hover the cursor over the annotation to edit or delete it. Click on the pencil icon to edit an annotation, or the trash icon to delete an annotation. Add additional annotations to the same date by clicking Add annotation.


Analyze Time Periods in Reports

Analyze your data further by highlighting a specific time period in a report. If you would like to reset the report to the original time frame, select the Reset Zoom icon that appears in the upper right-hand corner of the chart.


View Users from Insights

You can dive deeper into the specific set of users that make up your metric by clicking directly into a data point in the visualization and select the "View Users" action, this redirects you to the users page where you get a full list of the users that are contributing to the metric from your report, you can then save this as a cohort to perform analysis on, or directly export them.


It is also possible to view users at a specific point in time in a line chart by clicking a data point; optionally you can filter down or zoom into a data point with the "Zoom In" action which will change the date range and unit of your visualization to dive deeper into a spike in your report.



View Events from Insights

You can now click on a chart segment (bar, line) in Insights and view the raw events that made up that metric (redirects you to Events page):



View Sample Events

If you've ever wanted to see a few samples of an event to help you decide whether that's the right event you want for analysis or which property you should use for filters/breakdowns, this is for you.

You can hover over any event and in the context panel, you now have the ability to "View Sample Events", which redirects you to the Events page with 100 most recent samples of that hovered event:


Did this answer your question?



Article is closed for comments.