The rounding of search results has already been discussed numerously. But unfortunately, it doesn't work for me.
I want to sort the result by total_time in descending order:
index="main" sourcetype="web_ping" response_code="200" | stats latest(total_time) by title | sort -num(total_time)
But the result is still sorted by the title.
title latest(total_time)
brxxx 34.03
bsxxx 86.04
efxxx 157.03
gxxx 265.71
loxxx 340.82
stexxx 179.74
thxxx 239.87
winxxxe 292.73
Do you have a hint? Thank you!
Works like a charm! Thank you!
Thanks for your answer. I don't get it.
index="main" sourcetype="web_ping" response_code="200" | stats latest(total_time) by title | sort -latest
still deliver the result in the wrong order (highest number first)
title latest(total_time)
bxxx 30.01
bxxx 84.33
efxxx 144.48
gxxx 251.93
loxxx 263.72
etc...
Please look at my answer.
total_time does not exist. It is now latest (total_time).
| stats latest(total_time) by title | sort -latest(total_time)