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.
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.
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.
Default Rolling Time Range
Hour Last 12 hours Day Last 7 days Week Last 5 weeks Month Last 3 months Quarter Last 2 quarters
- 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
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.
The past data will appear as a striped bar, a dotted line, or an additional table column.
As 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. 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 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.