# RUNNING_AVG

`RUNNING_AVG(SUM([Hours Spent]))`

## Syntax

RUNNING_AVG({aggregation method}(numerical expression))

A running avg is the average of a sequence of numbers which is updated each time a new number is added to the sequence with the following calculation `({Previous Value} - {Previous Value} / Count) + ({Current Value} / Count)`.

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_AVG(COUNT([ID]))` will give the table below

#`RUNNING_AVG(COUNT([ID]))`
15
2(5-5/2) + (35/2) = 20
3(20-20/3)+25/3 = 21.67

## Spent Time Running Average

Shows the running average for tasks spent time over date.

#### Source: `Tasks`

Time tracking stats for tasks of the building super hero suit

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
01 Mar 2018 06:45 PMAsk Hulk to push in chest5Combat Testing

### Chart `AREA`

#### LABEL: `SUM([Hours Spent])`

DAY(Completed On)RUNNING_AVG(SUM(Hours Spent))SUM(Hours Spent)
3 Jan 20181919
20 Jan 20183245
5 Feb 201831.3330
9 Feb 201824.54
12 Feb 201820.65
1 Mar 2018185