Databases Reference
In-Depth Information
tABle 14.5
Market Basket Analysis BI View
Driver
Instance
Key
Corr
Instance
Key
Driver
Quantity
Sum
Driver
Dollars
Sum
Driver
Count
Sum
Corr
Quantity
Sum
Corr
Dollars
Sum
Corr
Count
Sum
Quantity
Ratio
Dollars
Ratio
Count
Ratio
15
0
4
$61.24
2
0
$0.00
1
0.0000%
0.0000%
50.0000%
15
16
4
$61.24
2
1
$12.21
1
25.0000%
19.9379%
50.0000%
15
78
4
$61.24
2
3
$40.32
1
75.0000%
65.8393%
50.0000%
16
15
1
$12.21
1
2
$30.62
1
200.0000%
250.7781%
100.0000%
16
78
1
$12.21
1
3
$40.32
1
300.0000%
330.2211%
100.0000%
43
57
3
$42.96
1
4
$36.36
1
133.3333%
84.6369%
100.0000%
43
98
3
$42.96
1
2
$4.90
1
66.6667%
11.4060%
100.0000%
57
43
6
$54.54
2
3
$42.96
1
50.0000%
78.7679%
50.0000%
57
64
6
$54.54
2
3
$37.11
1
50.0000%
68.0418%
50.0000%
57
98
6
$54.54
2
4
$9.80
2
66.6667%
17.9685%
100.0000%
64
57
5
$61.85
2
2
$18.18
1
40.0000%
29.3937%
50.0000%
64
87
5
$61.85
2
1
$16.87
1
20.0000%
27.2757%
50.0000%
64
98
5
$61.85
2
2
$4.90
1
40.0000%
7.9224%
50.0000%
78
15
3
$40.32
1
2
$30.62
1
66.6667%
75.9425%
100.0000%
78
16
3
$40.32
1
1
$12.21
1
33.3333%
30.2827%
100.0000%
87
64
1
$16.87
1
2
$24.74
1
200.0000%
146.6509%
100.0000%
98
43
4
$9.80
2
3
$42.96
1
75.0000%
438.3673%
50.0000%
98
57
4
$9.80
2
6
$54.54
2
150.0000%
556.5306%
100.0000%
98
64
4
$9.80
2
3
$37.11
1
75.0000%
378.6735%
50.0000%
