agg_expavg

The agg_expavg function calculates the exponential moving average of numeric values within each group during aggregation.

Spec

agg_expavg(column)
agg_expavg(column, alpha)

Parameters

column - A numeric column to calculate the exponential moving average for.
alpha  - (Optional) The smoothing factor between 0 and 1. Defaults to 0.6.

Return Value

The exponential moving average as a float64 value.

Example

Calculate exponential moving average with default alpha:

datatable(Group:string, Score:int64)
[
    "A", 10,
    "A", 20,
    "A", 30,
    "B", 50,
    "B", 60
]
| summarize agg_expavg(Score) by Group

Group	agg_expavg_Score
A	22.4
B	56.0

Calculate with custom alpha:

datatable(val:real)[1.0, 2.0, 3.0, 4.0, 5.0]
| summarize agg_expavg(val, 0.5)

agg_expavg_val
3.0625