RUNNING_SUM

RUNNING_SUM(SUM([Hours Spent]))

Syntax

RUNNING_SUM({aggregation method}(numerical expression))

A running sum is the summation of a sequence of numbers which is updated each time a new number is added to the sequence, by adding the value of the new number to the previous running value.

aggregation method: Any aggregation function SUM, MAX, COUNT and etc applied to numeric expression.

numerical expression: Basic arithmetic calculation created using the math operators +, -, *, /, numerical data fields and constants.

For example we have the data set below after applying aggregation COUNT([ID]) to income record set

#COUNT([ID])
15
235
325

Applying RUNNING_SUM(COUNT([ID])) will give the table below

#RUNNING_SUM(COUNT([ID]))
15
25 + 35 = 40
340 + 25 = 65

Use cases

Spent Time Cumulative

Shows the cumulative tasks spent time over date.

Source: Tasks

Time tracking stats for tasks of the building super hero suit

Completed OnTaskHours SpentFeature
03 Jan 2018 10:13 AMCreate a steel helmet to protect head19Protective Suit
20 Jan 2018 04:08 PMCreate a chest protection from steel45Protective Suit
05 Feb 2018 11:34 AMAsk agency to create fancy identity for new super hero30Design
09 Feb 2018 02:11 PMInstall super hero logo on body and helmet2Protective Suit
09 Feb 2018 02:11 PMPut on gloves with nice color2Protective Suit
12 Feb 2018 09:01 PMAsk Hulk to push in head5Combat Testing
01 Mar 2018 06:45 PMAsk Hulk to push in chest5Combat Testing

Chart AREA

X: DAY([Completed On])

Y: RUNNING_SUM(SUM([Hours Spent]))

LABEL: SUM([Hours Spent])

Chart

DAY(Completed On)RUNNING_SUM(SUM(Hours Spent))SUM(Hours Spent)
3 Jan 20181919
20 Jan 20186445
5 Feb 20189430
9 Feb 2018984
12 Feb 20181035
1 Mar 20181085