Example: Calculate a cumulative sum

You can create cumulative sums in Universal Explorations in Analytics. For example, the following steps walk through creating a cumulative sum of make purchase events in the last 30 days:

1. Click + > Universal exploration.
2. Choose the Event aggregate block.
3. Select the Count of events measure and the Make purchase event from the drop-down list. When you run this exploration, it displays the number of purchase events in the last 30 days.
4. Expand the block shelf, click + > Moving aggregation.
5. Select Cumulative as the aggregation type from the drop-down list and sum as the aggregator.
6. Select the event aggregate block you created earlier as the value and click Apply to reference it.
7. Click + > Metric and select the cumulative sum block as the value.
8. Set the time range to 30 days and run the exploration. The daily count and cumulative sum of Make purchase events are displayed.