Hi grant2,
Thanks for the reply, the version of influxdb is as follows:
InfluxDB shell version: 1.8.2
I will review what you said to see the possibility of updating Grafana, as it is a pod within Kubernetes I do not really know how to do it.
and if I am not mistaken the language is JSON, I attach the query:
{
“aliasColors”: {},
“dashLength”: 10,
“fieldConfig”: {
“defaults”: {},
“overrides”:
},
“fill”: 2,
“fillGradient”: 1,
“gridPos”: {
“h”: 10,
“w”: 15,
“x”: 0,
“y”: 0
},
“id”: 23763571993,
“legend”: {
“alignAsTable”: true,
“avg”: false,
“current”: true,
“hideEmpty”: true,
“hideZero”: true,
“max”: true,
“min”: true,
“rightSide”: false,
“show”: true,
“total”: false,
“values”: true
},
“lines”: true,
“linewidth”: 1,
“nullPointMode”: “null”,
“options”: {
“alertThreshold”: false
},
“pluginVersion”: “7.5.9”,
“pointradius”: 1,
“renderer”: “flot”,
“seriesOverrides”: [
{
“$$hashKey”: “object:434”,
“alias”: “MAC COUNT”,
“points”: true
}
],
“spaceLength”: 10,
“targets”: [
{
“aggregation”: “disable”,
“device”: “$ACX7509”,
“deviceGroup”: “hb-default:acx-mgn”,
“deviceGroups”: [
“hb-default:acx-mgn”
],
“devices”: [
“$ACX7509”
],
“groupBy”: “*”,
“groupBys”: [
“device-id”,
“vlan-name”
],
“limitField”: “”,
“limitFunction”: “none”,
“limitNumber”: “”,
“limitType”: “none”,
“measurement”: “onnet-protocol.evpn/onnet-check-mac-count-netconf/mac-count”,
“orderByTime”: “asc”,
“policy”: “default”,
“query”: “[{"query_name":"insights_grafana","deviceGroup":"hb-default:acx-mgn","device":"$router","measurement":"onnet-packet-errors/onnet-check-in-errors-iagent/input-errors","fields":["input_errors"],"where":"$timeFilter","groupBy":["device-id","name"],"deviceAggregation":{}}]”,
“rawQuery”: false,
“refId”: “A”,
“resultFormat”: “time_series”,
“select”: [
[
{
“params”: [
“mac-count”
],
“type”: “field”
}
]
],
“tags”:
}
],
“thresholds”: ,
“timeRegions”: ,
“title”: “MAC COUNT”,
“tooltip”: {
“shared”: true,
“sort”: 0,
“value_type”: “individual”
},
“transformations”: [
{
“id”: “renameByRegex”,
“options”: {
“regex”: “”,
“renamePattern”: “”
}
},
{
“id”: “calculateField”,
“options”: {
“alias”: “MAC COUNT”,
“mode”: “reduceRow”,
“reduce”: {
“include”: ,
“reducer”: “sum”
},
“replaceFields”: true
}
}
],
“type”: “graph”,
“xaxis”: {
“buckets”: null,
“mode”: “time”,
“name”: null,
“show”: true,
“values”:
},
“yaxes”: [
{
“$$hashKey”: “object:462”,
“format”: “string”,
“label”: null,
“logBase”: 1,
“max”: null,
“min”: null,
“show”: true
},
{
“$$hashKey”: “object:463”,
“format”: “short”,
“label”: null,
“logBase”: 1,
“max”: null,
“min”: null,
“show”: true
}
],
“yaxis”: {
“align”: true,
“alignLevel”: null
},
“bars”: false,
“dashes”: false,
“decimals”: null,
“hiddenSeries”: false,
“percentage”: false,
“points”: false,
“stack”: false,
“steppedLine”: false,
“timeFrom”: null,
“timeShift”: null,
“datasource”: null
}
What I also noticed is that for example if I download the graph data in CSV, I see that I have different values of the sum in the same time, and the end point in red square is the same value as the yellow square but with the difference of 1 second.
Anyway I will check Grafana to see how to update its version, I hope it is not something related to some delay or malfunction in the data pull that generates this problem.
