Skip to main content



Calculate the cumulative sum


Explains what the feature is or what its benefits are to the user or customer.


You can use the cumulative function in a search to measure from the start of your data to the current point.

This example will demonstrate using the cumulative_sum formula, also known as a running total. To use the cumulative function in a search:
  1. Start a new search.

    Aggregation Answer example

  2. In the upper right hand side of the table, click Actions and select Add formula.
  3. File:01_The_Basics/end_user_guide_bookmap/030/040/010/010/create_formula_in_answer.png

    Create a new formula in an answer

  4. Enter the cumulative_sum formula, providing a measure and one or more attributes. The example will return the sum of revenue, accumulated by the commit date.

    Cumulative Sum Formula

  5. Name the formula by clicking on its title and typing the new name. Click Save.
  6. The formula will appear in the search bar and in the table as its own column.

    Cumulative Sum Table

    A headline box displaying the cumulative sum within the entire table will appear at the bottom. You can click on it to toggle between different aggregations.


Cumulative formulas video

  • Was this article helpful?