Visualization Tools

In addition to the stacked bar chart and stacked line chart, Insights has regular bar charts, line charts and a table view. You can 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 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

Compare the data in your Insights graph to data from the previous day, week, month, etc. 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.

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.

Screen_Shot_2018-07-18_at_3.49.31_PM.pngThis 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.


In order to clarify the results in your Insights report, you can 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 occured 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 even 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. You can also choose to add additional annotations to the same date by clicking Add annotation.


Drill Down into a Report

Drill down into the chart by highlighting the time period you would like to analyze. 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?
16 out of 32 found this helpful



Article is closed for comments.