Output - Aster Analytics

Teradata AsterĀ® Analytics Foundation User GuideUpdate 2

Product
Aster Analytics
Release Number
7.00.02
Published
September 2017
Language
English (United States)
Last Update
2018-04-17
dita:mapPath
uce1497542673292.ditamap
dita:ditavalPath
AA-notempfilter_pdf_output.ditaval
dita:id
B700-1022
lifecycle
previous
Product Category
Software

Because the window size is 5, the stockprice_mavg and volume_mavg columns contain the weighted average value of the previous five rows (days). Because of IncludeFirst argument('true'), the output table includes the first five rows even though they contain null values for those columns.

WMAVG Example Output Table
id name period stockprice volume stockprice_mavg volume_mavg
1 IBM 1961-05-1700:00:00 460 640000    
1 IBM 1961-05-1800:00:00 457 707200    
1 IBM 1961-05-1900:00:00 452 747200    
1 IBM 1961-05-2200:00:00 459 1.3312e+06    
1 IBM 1961-05-2300:00:00 462 1.848e+06 458.4 1257386.6666666667
1 IBM 1961-05-2400:00:00 459 779200 458.73333333333335 1165546.6666666667
1 IBM 1961-05-2500:00:00 463 528000 460.46666666666664 980693.3333333334
1 IBM 1961-05-2600:00:00 479 843200 467.1333333333333 912853.3333333334
1 IBM 1961-05-2900:00:00 493 1.728e+06 476.6666666666667 1133546.6666666667
1 IBM 1961-05-3100:00:00 490 880000 482.93333333333334 1045120.0
1 IBM 1961-06-0100:00:00 492 760000 488.0 981226.6666666666
1 IBM 1961-06-0200:00:00 498 1.848e+06 492.8666666666667 1281280.0
1 IBM 1961-06-0500:00:00 499 1.3472e+06 495.73333333333335 1326400.0
... ... ... ... ... ... ...