Hello, I have a graph I am displaying showing the temperature of a room pulled via telegrafs snmp plugin and then stored in influxdb.
The graph displays visually fine, with the lines and points matching up to the data. However when hovering my mouse over each datapoint, the value is blank. If i put a legend item showing the current value, it is also blank.
When I try to set up an alert, the alert considers the data null as well.
I have set the group by time to be above the collection interval and have updated to the latest version of grafana with the same issue.
Thank you for any help or guidance, I’ve put more information from grafana below:
The query is this:
SELECT last(“TempSensor1”) FROM “autogen”.“RoomTempSnmp” WHERE $timeFilter GROUP BY time(2m) fill(null))
The values returned in the query viewer are:
0:Array[1535626680000,20.375]
1:Array[1535626800000,20.375]
2:Array[1535626920000,20.375]
3:Array[1535627040000,20.812]
4:Array[1535627160000,21.062]
5:Array[1535627280000,21.000]
6:Array[1535627400000,20.937]
7:Array[1535627520000,20.937]
8:Array[1535627640000,20.937]
9:Array[1535627760000,21.062]
10:Array[1535627880000,21.062]
11:Array[1535628000000,20.875]
12:Array[1535628120000,20.312]
13:Array[1535628240000,21.000]
14:Array[1535628360000,21.000]
15:Array[1535628480000,21.000]
16:Array[1535628600000,21.000]
17:Array[1535628720000,21.000]
18:Array[1535628840000,21.125]
19:Array[1535628960000,21.125]
20:Array[1535629080000,21.125]
21:Array[1535629200000,21.125]
22:Array[1535629320000,21.062]
23:Array[1535629440000,21.000]
24:Array[1535629560000,21.000]
25:Array[1535629680000,20.937]
26:Array[1535629800000,20.250]
27:Array[1535629920000,21.187]
28:Array[1535630040000,21.062]
29:Array[1535630160000,21.187]
30:Array[1535630280000,null]
When testing the alert, it shows the following:
firing:false
state:“no_data”
conditionEvals:“false = false”
timeMs:“2.000ms”
logs:Array[2]
0:Object
message:“Condition[0]: Query Result”
data:Array[1]
0:Object
name:“RoomTempSnmp.last”
points:Array[3]
0:Array[null,1535630160]
1:Array[null,1535630280]
2:Array[null,1535630400]
1:Object
message:“Condition[0]: Eval: false, Metric: RoomTempSnmp.last, Value: null”
data:null