Keypup

Function: <code>SUM_CUMULATIVE</code>

Syntax: <code>SUM_CUMULATIVE(field or expression)</code>

Description: Returns a cumulative sum of values for each grouping, which takes into account the sum of previous groupings. The return values of this aggregator therefore depend on the sort order of the groupings (ascending or descending).

Important: requires sorting on a dimension

The <code>SUM_CUMULATIVE</code> operator requires sorting your data on a dimension column. Sorting your data on a metric (e.g. another <code>COUNT</code> column) will result in incorrect results for the cumulative operator.

<code>SUM_CUMULATIVE(lines_changed)</code> returns the cumulative sum of lines of code changed, based on the requested sort-order.

<code>ROUND(SUM_CUMULATIVE(lines_changed) / SUM_TOTAL(lines_changed), 2) * 100</code> returns the percentage of lines of code changed up until this point (e.g. from the beginning of the period up until this month) in comparison to the grand total.

<code>ROUND(SUM(lines_changed) / SUM_CUMULATIVE(lines_changed), 2) * 100</code> returns the percentage of lines of code changed by each grouping in comparison to the total up until this point.

- <code>SUM_CUMULATIVE(lines_changed)</code> returns the cumulative sum of lines of code changed, based on the requested sort-order.
- <code>ROUND(SUM_CUMULATIVE(lines_changed) / SUM_TOTAL(lines_changed), 2) * 100</code> returns the percentage of lines of code changed up until this point (e.g. from the beginning of the period up until this month) in comparison to the grand total.
- <code>ROUND(SUM(lines_changed) / SUM_CUMULATIVE(lines_changed), 2) * 100</code> returns the percentage of lines of code changed by each grouping in comparison to the total up until this point.