Hallo Leute,
wie ihr seht, ist meine Tabelle eigentlich richtig sortiert, es beinhaltet die Daten von 500 000 Zeilen. Allerdings fasst er nicht alle Zahlen zusammen, zb die 1 taucht mehrmals auf und sie ist nicht richtig sortiert.
Kann mir einer sagen woran es liegt?
Es handelt sich um eine Pivot Tabelle:
Rows= No.of Document LineItems
Valeus = Average of Server Respond Time
No. Of Average of Sever Respond Time
1 00:00:04,409
2 00:00:04,766
3 00:00:04,500
4 00:00:04,527
5 00:00:04,000
6 00:00:04,364
8 00:00:05,706
9 00:00:05,667
10 00:00:04,273
11 00:00:04,000
12 00:00:05,222
13 00:00:05,400
14 00:00:04,692
15 00:00:04,500
16 00:00:05,000
18 00:00:05,143
19 00:00:05,000
20 00:00:05,182
21 00:00:04,000
22 00:00:05,222
24 00:00:05,250
25 00:00:05,000
26 00:00:05,500
28 00:00:05,000
29 00:00:05,000
30 00:00:04,714
31 00:00:05,000
32 00:00:05,600
33 00:00:05,500
34 00:00:05,667
36 00:00:05,000
37 00:00:05,000
38 00:00:05,000
39 00:00:05,000
40 00:00:07,000
41 00:00:05,000
43 00:00:10,500
44 00:00:06,750
45 00:00:05,000
46 00:00:09,000
47 00:00:05,000
48 00:00:05,000
52 00:00:06,000
58 00:00:05,500
59 00:00:05,000
66 00:00:06,500
67 00:00:06,000
70 00:00:06,000
74 00:00:06,000
88 00:00:13,000
97 00:00:06,000
98 00:00:07,000
99 00:00:07,000
108 00:00:08,000
122 00:00:07,000
154 00:00:12,000
1 00:00:03,781
10 00:00:03,467
100 00:00:08,000
102 00:00:06,000
104 00:00:06,500
107 00:00:06,000
108 00:00:06,750
11 00:00:03,667
116 00:00:06,000
12 00:00:03,194
122 00:00:07,000
126 00:00:07,000
13 00:00:03,615
130 00:00:06,750
132 00:00:07,000
134 00:00:07,000
139 00:00:07,000
14 00:00:03,380
140 00:00:06,000
144 00:00:07,000
145 00:00:07,000
15 00:00:03,500
157 00:00:07,000
16 00:00:03,730
168 00:00:08,000
17 00:00:03,000
18 00:00:03,788
19 00:00:04,000
196 00:00:07,000
2 00:00:03,468
20 00:00:04,206
21 00:00:03,667
22 00:00:03,483
23 00:00:03,333
24 00:00:03,737
242 00:00:09,000
25 00:00:04,000
256 00:00:10,000
26 00:00:03,500
27 00:00:03,667
28 00:00:03,783
29 00:00:03,000
3 00:00:03,667
30 00:00:03,565
31 00:00:03,500
32 00:00:03,720
33 00:00:04,000
34 00:00:03,731
35 00:00:04,000
36 00:00:04,071
37 00:00:03,857
370 00:00:15,000
38 00:00:04,000
39 00:00:04,200
4 00:00:03,416
40 00:00:04,684
41 00:00:04,333
42 00:00:04,437
43 00:00:05,333
44 00:00:04,250
45 00:00:04,800
46 00:00:06,000
47 00:00:04,500
48 00:00:05,000
488 00:00:14,000
5 00:00:03,000
50 00:00:04,500
51 00:00:04,333
52 00:00:04,286
53 00:00:06,000
54 00:00:04,250
55 00:00:04,000
56 00:00:04,000
57 00:00:04,000
58 00:00:05,333
6 00:00:03,514
60 00:00:04,800
62 00:00:04,833
64 00:00:05,833
66 00:00:04,500
67 00:00:06,500
68 00:00:05,400
7 00:00:03,750
70 00:00:04,333
72 00:00:04,667
74 00:00:04,000
78 00:00:05,167
8 00:00:03,652
81 00:00:06,000
82 00:00:04,750
84 00:00:04,500
86 00:00:05,000
87 00:00:10,000
88 00:00:05,000
9 00:00:03,000
90 00:00:05,000
92 00:00:05,000
98 00:00:05,000
Grand Total 00:00:03,783