topic How to make a visualization with time? in Dashboards & Visualizations

How to make a visualization with time?

zacksoft — Tue, 29 Sep 2020 18:55:16 GMT

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 ?

Re: How to make a visualization with time?

mayurr98 — Tue, 10 Apr 2018 09:38:46 GMT

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!

Re: How to make a visualization with time?

zacksoft — Tue, 29 Sep 2020 18:55:24 GMT

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

Re: How to make a visualization with time?

mayurr98 — Tue, 10 Apr 2018 09:57:36 GMT

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!

Re: How to make a visualization with time?

zacksoft — Tue, 10 Apr 2018 10:06:50 GMT

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