How to make a visualization with time?

[zacksoft]

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 ?

[mayurr98 · Accepted solution]

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!

[zacksoft]

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

[mayurr98]

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!

[zacksoft]

This helps. Thank you. The 'Delta' thing is what I was looking for. Thanks again.