breadlysm / SpeedFlux

Script to periodically run the Speedtest CLI application by Ookla and post results to InfluxDB.
MIT License
112 stars 68 forks source link

jitter ? #31

Closed P6g9YHK6 closed 1 year ago

P6g9YHK6 commented 2 years ago

would it be possible to add to the dashboard a ping jitter panel? here is an exemple of a speed test with a jitter display http://ting.speedtestcustom.com/

ChiefGyk3D commented 2 years ago

So Jitter is included partially already in alternative dashboard and it looks like pulled in with the data so it wouldn't be too hard I suppose for someone who has the knowledge to add it. https://github.com/breadlysm/SpeedFlux/blob/master/GrafanaDash-SpeedTests.json

image image image

Selta commented 2 years ago

It's fairly simple to include jitter and latency in different panels of a dashboard. One example query that will get the values for you and alias (rename) them as Latency ms and Jitter ms is:

SELECT "latency" AS "Latency ms", "jitter" AS "Jitter ms" FROM "ping" WHERE ("namespace" =~ /^$namespace$/) AND $timeFilter GROUP BY "server_name"

One easy way to simply dig around the available data is to go into Explore: image

Once in there, you can use the UI to build queries. This setup will produce a table that shows the datetime, server_name, jitter, and latency values: image

Once you have a handle on the querying, it's as simple as making a new panel, or inserting the queries into an existing panel to add the columns to a table.

P6g9YHK6 commented 1 year ago

Thanks everyone i didn't know that the jitter was a value already logged by the tool i have made my little panel to have an overview of the jittter per ISP

image