Comparing Averages over Search Intervals
You can compare the average (m1) of a search over the
hours with the
latest 1 hour of the same
average (m1). Run the search on
24h for that.
filters... | [avg(m1,as=all), bucket(function=avg(m1,as=lastHour), span=1h)] | rename(_bucket,as=@timestamp) | tail(2) | head(1)
That calculates the average over whatever the search interval (max 1500 hours) and gets you that next to the average of the latest hour. In this case for the field "m1".