Rolling aggregate(滚动聚合(Rolling aggregate))¶
Rolling aggregates are typically used to “smooth” a series and show an averaged version of it. For each point in your series, a Rolling aggregate will calculate a new point based on your window function and aggregate method.
- As an example, if you choose a window size of one week and method
average, each point will be calculated by finding the average value over the previous week. - If you choose a window size of three days and method
sum, then each point will be the sum of the previous three days. - Windows are calculated by previous values up to and including that point.
Input type¶
Time series
Output type¶
Time series
Example¶

Usage information¶
| Functionality | Availability |
|---|---|
| Standard Quiver card | Supported |
| Transform table transform | Supported |
中文翻译¶
滚动聚合(Rolling aggregate)¶
滚动聚合通常用于对序列进行"平滑"处理,并展示其平均化版本。对于序列中的每个数据点,滚动聚合会根据您设定的窗口函数(window function)和聚合方法(aggregate method)计算出一个新数据点。
- 例如,若选择窗口大小为一周且方法为
average(平均值),则每个数据点将基于前一周的平均值计算得出。 - 若选择窗口大小为三天且方法为
sum(求和),则每个数据点将是前三天的总和。 - 窗口计算基于截至当前数据点(含该点)的先前值。
输入类型¶
时间序列(Time series)
输出类型¶
时间序列
示例¶

使用信息¶
| 功能 | 支持情况 |
|---|---|
| 标准 Quiver 卡片 | 支持 |
| 转换表转换 | 支持 |