| Aggregate summary |
|---|
| avg | Return the arithmetic mean of the items in the window. |
| count | Return the number of items in the window, optionally with modifications. |
| countUnique | Return the number of unique strings in the window. |
| first | Return the earliest value in the window. |
| last | Return the latest value in the window. |
| max | Return the largest item in the window. |
| mean | Return the arithmetic mean of the items in the window. |
| min | Return the smallest item in the window. |
| nth | Return the window element that is the specified distance from the start of the window. |
| percentile | Return the value in the window which has the specified percentage of the window smaller than it. |
| stddev | The standard deviation of the values in the window. |
| stddev2 | The sample standard deviation of the values in the window. |
| sum | The sum of the values in the window. |
| wavg | The weighted average of the values in the window. |