Interpret your analysis, part 2: Advanced features

This article explores some of the more advanced features available to you as you interpret your event segmentation analyses. For a primer on the basics, see part one.

Rolling averages

Rolling averages will display the unweighted mean, which works to smooth out a chart. This is useful if you have cyclical users—for example, people who use your product during the week, but not on weekends. 

To apply a rolling average to your chart, click Advanced and select Rolling Average from the drop-down list.

This chart displays the daily event totals between February 26th and March 28th, without a rolling average. Note the sharp peaks and valleys in the line.

But when a rolling average of seven days is added, those fluctuations disappear. That’s because each data point is now an average of the previous seven days’ worth of data.

Bear in mind that each day’s data is included in that day’s data point:

• When looking at the current day, Amplitude will use a dotted line to show data collection for today isn’t finished yet. You can hide the dotted line by using Offset in the date picker.
• Also, with a seven-day rolling average, the first six days of your selected time frame will fetch data from outside the selected time period. For example, in an analysis covering the month of February, the result for February 6th would average data over January 31st to February 6th.

Rolling windows

A rolling window is another method of smoothing out your data. It will display the aggregate last N days of information in a single data point. This is useful if you want to see aggregated metrics—such as your 7-day active user count—on a daily basis.

This differs from the rolling average, in that a rolling window does not average your data over the selected time frame. Instead, it sums the data.

To apply a rolling window to your chart, click Advanced and select Rolling Window from the drop-down list.

This chart displays daily uniques between April 5th and May 5th without a rolling window. With Microscope, we can see that on April 21st, there were 7,560,891 users.

Below, we see the daily uniques displayed with a rolling window of seven days. The April 21st data point is the number of unique users between April 15th and April 21st, with duplicates removed.

As with a rolling average, when using a seven-day rolling window, the first six days of your selected time frame will fetch data from outside the selected time period. For example, in an analysis covering the month of February, the result for February 6th would average data over January 31st to February 6th.

Cumulative sum

Cumulative sum will display a running total of events in a single data point. For example, you might want to show a running total of revenue generated by purchase events. Cumulative sum will help you do that.

To apply a cumulative sum to your chart, click Advanced and select Cumulative from the drop-down list.

This chart shows a running total of revenue generated by Complete Purchase events. The April 19th data point represents a sum of revenue generated on all the preceding days of the selected time frame. Here, that means April 5th to April 19th.

Using cumulative sum with uniques will generate a count of unique users for each data point, with duplicates removed.

For example:

• • On April 5th, User A triggered Complete Purchase.
    • On April 11th, User A and User B triggered Complete Purchase.
    • On April 19th, User C and User D triggered Complete Purchase.

On the data point for April 19th, a total count of four will be returned because four unique users fired this event from April 5th to April 19th.

Real-time segmentation

You can view segmentation data in real time. However, there are some caveats:

• You can only segment one day's worth of data for real-time.
  • The event times are rounded down.
  • Charts are cached every five minutes for everyone.

Period-over-period comparison (compare to past)

Using Compare to past, you can compare the results of the current time range with the previous day, or the same day from previous week, month, quarter or year.

For example, let's say you want to compare completed purchases for the current week to last week.

The blue segment shows you the current period and the green segment shows you your data for last week. 

Since the period-over-period comparison interval is configurable, you can choose what dates you actually want to compare. You can also toggle to see the percentage change between values instead.

Period-over-period for custom formulas

You can also use the period-over-period comparison with the custom formula metric. For example, you can compare your current rolling average with that of the previous month: