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

This query returns the output shown in the table cfilter_output:

SELECT * FROM cfilter_output ORDER BY region, score;

Because all cntb values are equal, no z-scores appear.

CFilter Example 1 Output Table cfilter_output (Columns 1-6)
region col1_item1 col1_item2 cntb cnt1 cnt2
Atlantic Paper Office Furnishings 1 4 5
Atlantic Office Furnishings Paper 1 5 4
Atlantic Binders and Binder Accessories Office Furnishings 1 3 5
Atlantic Office Furnishings Binders and Binder Accessories 1 5 3
Atlantic Computer Peripherals Office Furnishings 1 2 5
Atlantic Office Furnishings Computer Peripherals 1 5 2
Atlantic Labels Pens & Art Supplies 1 3 2
Atlantic Pens & Art Supplies Labels 1 2 3
... ... ... ... ... ...
CFilter Example 1 Output Table cfilter_output (Columns 7-11)
score support confidence lift z_score
0.05 0.0555555555555556 0.25 0.9  
0.05 0.0555555555555556 0.2 0.9  
0.0666666666666667 0.0555555555555556 0.333333333333333 1.2  
0.0666666666666667 0.0555555555555556 0.2 1.2  
0.1 0.0555555555555556 0.5 1.8  
0.1 0.0555555555555556 0.2 1.8  
0.166666666666667 0.0555555555555556 0.333333333333333 3  
0.166666666666667 0.0555555555555556 0.5 3  
... ... ... ... ...