tmwsum

语法

tmwsum(T, X, Y, window)

参数说明和窗口计算规则请参考:tmFunctions

详情

在给定长度(以时间长度衡量)的滑动窗口内,计算 XY 元素的内积。

例子

T = 1 1 1 1 2 5 6 8 9 10
X = 1..10
Y = double(1..10)\10
m = table(T as t,X as x, Y as y)
select *, tmwsum(t, y, x, 3) from m
t x y tmwsum_t
1 1 0.1 0.1
1 2 0.2 0.5
1 3 0.3 1.4
1 4 0.4 3
2 5 0.5 5.5
5 6 0.6 3.6
6 7 0.7 8.5
8 8 0.8 11.3
9 9 0.9 14.5
10 10 1 24.5
T = 2021.01.02 2021.01.06 join 2021.01.07..2021.01.14
X = 1..10
Y = double(1..10)\10
m=table(T as t,X as x, Y as y)
select *, tmwsum(t, y, x, 3) from m
t x y tmwsum_t
2021.01.02 1 0.1 0.1
2021.01.06 2 0.2 0.4
2021.01.07 3 0.3 1.3
2021.01.08 4 0.4 2.9
2021.01.09 5 0.5 5
2021.01.10 6 0.6 7.7
2021.01.11 7 0.7 11
2021.01.12 8 0.8 14.9
2021.01.13 9 0.9 19.4
2021.01.14 10 1 24.5
select *, tmwsum(t, y, x, 1w) from m
t x y tmwsum_t
2021.01.02 1 0.1 0.1
2021.01.06 2 0.2 0.5
2021.01.07 3 0.3 1.4
2021.01.08 4 0.4 3
2021.01.09 5 0.5 5.4
2021.01.10 6 0.6 9
2021.01.11 7 0.7 13.9
2021.01.12 8 0.8 20.3
2021.01.13 9 0.9 28
2021.01.14 10 1 37.1

相关函数:wsum, mwsum