跳转至

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

Rolling aggregate example

Usage information

Functionality Availability
Standard Quiver card Supported
Transform table transform Supported

中文翻译


滚动聚合(Rolling aggregate)

滚动聚合通常用于对序列进行"平滑"处理,并展示其平均化版本。对于序列中的每个数据点,滚动聚合会根据您设定的窗口函数(window function)和聚合方法(aggregate method)计算出一个新数据点。

  • 例如,若选择窗口大小为一周且方法为average(平均值),则每个数据点将基于前一周的平均值计算得出。
  • 若选择窗口大小为三天且方法为sum(求和),则每个数据点将是前三天的总和。
  • 窗口计算基于截至当前数据点(含该点)的先前值。

输入类型

时间序列(Time series)

输出类型

时间序列

示例

滚动聚合示例

使用信息

功能 支持情况
标准 Quiver 卡片 支持
转换表转换 支持