跳转至

Periodic aggregate(周期性聚合(Periodic aggregate))

Periodic aggregates are similar to Rolling aggregates except that they downsample the data.

  • If you have daily data and perform a Rolling aggregate using a window of one week with an average function, your chart will return a series with one point per day, with each point representing the previous week’s average.
  • However, if you do a Periodic aggregate with a window of one week, your new series will have one point per week rather than one point per day.

Input type

Time series

Output type

Time series

Examples

Periodic aggregate example

Usage information

Functionality Availability
Standard Quiver card Supported
Transform table transform Supported

See also

Rolling aggregate


中文翻译

周期性聚合(Periodic aggregate)

周期性聚合与滚动聚合(Rolling aggregate)类似,区别在于它对数据进行降采样。

  • 如果您拥有每日数据,并使用一周窗口的滚动聚合配合平均值函数,图表将返回一个每天一个数据点的序列,每个点代表前一周的平均值。
  • 然而,如果您使用一周窗口的周期性聚合,新序列将每周只有一个数据点,而不是每天一个数据点。

输入类型(Input type)

时间序列(Time series)

输出类型(Output type)

时间序列(Time series)

示例(Examples)

周期性聚合示例

使用信息(Usage information)

功能 可用性
标准 Quiver 卡片 支持
转换表转换 支持

参见(See also)

滚动聚合(Rolling aggregate)