Hi Team,
I have the following result in place with 30min bucket using stats values() and then xyseries
time field1 field2 field3 field4
05:30
4,10,11,12,30
1,13,14,9,8,7
5,7,3,8,9,1,55
23,24,17,18,19
06:00
19,10,11,12,30
12,3,14,9,8,7
1,17,3,8,1,34
22,2,25,17,18,19
06:30
20,10,11,12,55
11,13,14,9,18,7
10,7,3,8,9,1,4
23,24,26,1,18,49
07:00
21,10,11,12,44
12,13,17,9,7
6,7,3,9,1,23
23,24,25,17,18,19
07:30
31,10,11,12,50
1,13,14,9,8,7
5,7,3,8,9,11
23,24,25,17,18,19
08:00
1,10,11,12,30,88
12,13,14,9,81
5,7,3,8,9,17
23,24,25,17,18,19
08:30
1,10,11,12,30,99
12,13,14,9,81
5,7,3,8,9,18
23,24,25,17,18,19
09:00
1,11,12,30,23
11,1,14,9,7
10,7,3,8,9,18
23,24,25,17,18,19
09:30
1,10,11,12,300
12,13,4,9,8,7
4,7,3,8,9,1
23,24,25,17,18,19
Currently the result shows all the values for each field. What I am looking here is the top 3 values which has maximum count for each field, not sure how to pull that result.
Request someone to guide.
... View more