Example: Calculate a cumulative sum
0 min
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:
- Click + > Universal exploration.
- Choose the Event aggregate block.
- 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.
- Expand the block shelf, click + > Moving aggregation.
- Select Cumulative as the aggregation type from the drop-down list and sum as the aggregator.
- Select the event aggregate block you created earlier as the value and click Apply to reference it.
- Click + > Metric and select the cumulative sum block as the value.
- Set the time range to 30 days and run the exploration. The daily count and cumulative sum of Make purchase events are displayed.