Feature Request: Adding columns to DB for latency and jitter values

[alexdelprete]

Right now DL/UL/Ping values have specific columns in the results table, could it be possible to add the columns relevant to latency and jitter values for DL/UL/Ping? I know you also record the entire json result in a column, but it would be simpler to have the data in the columns to build graphs. :)

• ping/latency - ping/jitter
• download/latency/iqm - download/latency/jitter
• upload/latency/iqm - upload/latency/jitter

JSON result:

{
    "type": "result",
    "timestamp": "2022-10-19T14:58:06Z",
    "ping": {
        "jitter": 0.669,
        "latency": 9.098,
        "low": 8.265,
        "high": 9.836
    },
    "download": {
        "bandwidth": 101028973,
        "bytes": 731422984,
        "elapsed": 7206,
        "latency": {
            "iqm": 58.306,
            "low": 9.128,
            "high": 325.879,
            "jitter": 47.725
        }
    },
    "upload": {
        "bandwidth": 29942177,
        "bytes": 187101993,
        "elapsed": 6301,
        "latency": {
            "iqm": 10.126,
            "low": 8.357,
            "high": 12.516,
            "jitter": 0.967
        }
    },
    "packetLoss": 0,
    "isp": "Tecno General S.r.l",
    "interface": {
        "internalIp": "10.1.10.23",
        "name": "eth0",
        "macAddr": "XX:XX:XX:XX:XX:XX",
        "isVpn": false,
        "externalIp": "XXX.XXX.XXX.XXX"
    },
    "server": {
        "id": 4302,
        "host": "speedtest.vodafone.it",
        "port": 8080,
        "name": "Vodafone IT",
        "location": "Milan",
        "country": "Italy",
        "ip": "217.171.46.93"
    },

[alexdelprete]

I configured influxdb2 integration and checked data after the first speedtest. These are the available fields I could choose from:

I picked download/upload, but I noticed very low values in influx:

so I checked the mariadb data (record #7):

So the data was ok. But the reported speed of that test was this:

I didn't understand at first...then I thought maybe those download/upload columns in the db represent the amount of data sent/received, and that you get the actual speed values from the json in the data column. Problem is that the data column is not exported to influx.

So, to integrate my OP, I think also the DL/UL speed values should be in their own columns, probably the quantity of data sent/received is not so important, and you could actually reuse those columns. :)

[alexdelprete]

@alexjustesen from the json data, download/bytes and upload/bytes is being written in the download/upload db columns: maybe it's a bug, and download/bandwidth upload/bandwidth values should be written there.