Cumulative Functions - Invoca

Cumulative formulas calculate the average, max, min, or sum of your data over time, or any other sequential data.

Cumulative formulas are aggregate formulas that let you calculate the average, max, min, or sum of your data accumulated over time — or over any other sequential data. Each cumulative formula accepts a Measure and one or more optional attributes to group by (like region or department):

formula (Measure, [attribute, attribute, ...])

Only the Measure value is required. If you supply both a Measure and attributes, the formula returns the aggregate of the Measure accumulated by the attribute(s) in the order specified.

The cumulative formulas

Function	Description	Example
`cumulative_average`	Average of the Measure, accumulated by attribute(s) in the order specified	`cumulative_average (revenue, order date, state)`
`cumulative_max`	Maximum of the Measure, accumulated by attribute(s) in the order specified	`cumulative_max (revenue, state)`
`cumulative_min`	Minimum of the Measure, accumulated by attribute(s) in the order specified	`cumulative_min (revenue, campaign)`
`cumulative_sum`	Sum of the Measure, accumulated by attribute(s) in the order specified	`cumulative_sum (revenue, order date)`

You may have attributes in your search that aren’t part of the cumulative formula. The formula resets its results for different values of any attribute not included in it.

Calculate a cumulative sum

Start a new search.
In the upper-right of the table, click the more options menu icon and select Add formula.
Enter the cumulative_sum formula, providing a Measure and one or more attributes.
Name the formula by clicking its title and typing a new name.
Click Save. The formula appears in the search bar and as its own table column. A headline box showing the cumulative sum for the entire table appears at the bottom — click it to toggle between aggregations.

Where to go next

Last modified on September 23, 2026