I have a base query that returns the field transfer_speed . And the transfer_speed changes (keeps on changing). Sometimes it has a low value like 2 and sometimes as 150 (in kbps).
| basequery
| table transfer_speed
I want to be able to see the transfer_speed in a graph/line chart / or any such way having x asis showing time and y axis as speed.
Also is it possible to see the "rate of change" of transfer_speed at any particular point in the graph ?
well you can try something like this
| basequery
| timechart span=1h avg(transfer_speed) as transfer_speed | delta transfer_speed as "rate of change"
you can change the span as per your need.
let me know if this helps!
well you can try something like this
| basequery
| timechart span=1h avg(transfer_speed) as transfer_speed | delta transfer_speed as "rate of change"
you can change the span as per your need.
let me know if this helps!
It won't give any value. adding that last line is not giving any value.
Nothing comes in the visualization and in the statistics tab also under avg(transfer_speed) it shows nothing.
This is what I tried
| base query
| table transfer_speed
| timechart span=1h avg(transfer_speed)
It shows me transfer_speed when I give |table command. But nothing comes when I add the timechart command
Yes but obviously it will not give any value because of | table transfer_speed
.
just try this
| base query
| timechart span=1h avg(transfer_speed) as transfer_speed | delta transfer_speed as "rate of change"
Remove | table transfer_speed
from your query and try.
let me know if this helps!
This helps. Thank you. The 'Delta' thing is what I was looking for. Thanks again.