Databases Reference
In-Depth Information
tABle 7.5
Market Basket Analysis BI View
Driver
Object
Key
Corr
Object
Key
Driver
Quantity
Sum
Driver
Dollars
Sum
Driver
Count
Sum
Corr
Quantitym
Sum
Corr
Dollars
Sum
Corr
Count
Sum
Quantity
Ratio
Dollars
Ratio
Count
Ratio
15
0
3
$45.93
2
0
$0.00
1
0.0000%
0.0000%
50.0000%
15
16
3
$45.93
2
1
$12.21
1
33.3333%
26.5839%
50.0000%
15
64
3
$45.93
2
1
$12.37
1
33.3333%
26.9323%
50.0000%
15
78
3
$45.93
2
4
$53.76
1
133.3333%
117.0477%
50.0000%
15
98
3
$45.93
2
1
$2.45
1
33.3333%
5.3342%
50.0000%
16
15
3
$36.63
2
2
$30.62
1
66.6667%
83.5927%
50.0000%
16
43
3
$36.63
2
1
$14.32
1
33.3333%
39.0936%
50.0000%
16
57
3
$36.63
2
2
$18.18
1
66.6667%
49.6314%
50.0000%
16
64
3
$36.63
2
2
$24.74
2
66.6667%
67.5403%
100.0000%
16
78
3
$36.63
2
4
$53.76
1
133.3333%
146.7649%
50.0000%
16
98
3
$36.63
2
1
$2.45
1
33.3333%
6.6885%
50.0000%
43
16
4
$57.28
2
2
$24.42
1
50.0000%
42.6327%
50.0000%
43
57
4
$57.28
2
3
$27.27
2
75.0000%
47.6082%
100.0000%
43
64
4
$57.28
2
1
$12.37
1
25.0000%
21.5957%
50.0000%
43
78
4
$57.28
2
1
$13.44
1
25.0000%
23.4637%
50.0000%
43
87
4
$57.28
2
1
$16.87
1
25.0000%
29.4518%
50.0000%
43
98
4
$57.28
2
1
$2.45
1
25.0000%
4.2772%
50.0000%
57
16
3
$27.27
2
2
$24.42
1
66.6667%
89.5490%
50.0000%
57
43
3
$27.27
2
4
$57.28
2
133.3333%
210.0477%
100.0000%
(
Continued
)
