Hello.
I want to get a statistic for values of every X number of non-overlapping events. For example, for events with time and value fields, the average of the values for every 2 fields is
(1-1)
(2-1) --> (1+1)/2=1
(3-2)
(4-3) --> (2+3)/2=2.5
(5-1)
(6-4) --> (1+4)/2=2.5
(7-5)
(8-5) --> (5+5)/2=5
(9-7)
To end up with a chart (time-avg)
(2-->1)
(4-->2.5)
(6-->2.5)
(8-->5)
I looked at bucket (bins, minspan), timechart, streamstats. but couldn't figure it out. Thanks for your help.
Hello Try this:
| bucket _raw span=2
Regards