tmwsum

New in version 2.00.2.

语法

tmwsum(T, X, Y, window)

参数说明和窗口计算规则请参考: 时序滑动窗口系列(tm 系列)

详情

在给定长度(以时间长度衡量)的滑动窗口内,计算 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