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 addition to the stacked bar chart and stacked line chart, Insights has regular bar charts, line charts and a table view. Resize the columns in the bar chart in order to see more or remove detail.


Analysis & Value Settings

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


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.


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.


Time Period Comparisons

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.

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.


The past data will appear as a striped bar, a dotted line, or an additional table column.

Screen_Shot_2019-08-23_at_2.08.12_PM.pngScreen_Shot_2019-08-23_at_2.08.27_PM.pngScreen_Shot_2019-08-23_at_2.08.37_PM.pngAs you can see from this graph, there was significantly more activity in the top events for this company in the previous week than there was this week. This information can be used to diagnose the effects of major changes to the product. In this case, perhaps a change to the product made it less usable for customers, making the overall activity drop. Hover over a line on the graph to see details.


This makes it easy to see the actual difference in numbers between two time periods, including the percentage difference. This percentage difference is not available in tables.


Insights will automatically group your high-cardinality segments into ranges. Ranges cannot be manually edited.


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 blue button containing “” 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.


Is this article helpful?
3 out of 3 found this helpful



Article is closed for comments.