Hey Everyone!
Got a bit of a puzzler here. I’ve got a simple InfluxDB database that collects temperature readings, and an even simpler Grafana visualizer that shows it.
The First Graph is a SingleStat visualization of the most current temperature, which in this case is 37° C.
The Second Graph is a bar graph that maps all temperature readings over time.
The issue already is pretty clear: the bar graph does not show the most recent temperature reading. Data points do randomly appear hours afterward, but it is delayed for some reason.
The query for the First Graph is:
SELECT "temperature_c" FROM "autogen"."overwatch" WHERE $timeFilter
The query for the Second Graph is:
SELECT distinct("temperature_c") FROM "overwatch" WHERE $timeFilter GROUP BY time($__interval) fill(null)
If I query inspector for the First Graph I get 15 values, terminating in 37:
values:Array[15]
0:Array[1593616042000,39]
1:Array[1593616174000,28]
2:Array[1593616288000,28]
3:Array[1593616372000,28]
4:Array[1593616393000,37]
5:Array[1593616470000,28]
6:Array[1593617340000,37]
7:Array[1593617461000,29]
8:Array[1593619320000,39]
9:Array[1593619458000,39]
10:Array[1593619485000,38]
11:Array[1593619902000,30]
12:Array[1593621276000,37]
13:Array[1593624236000,29]
14:Array[1593628121000,37]
and if I query inspector for the Second Graph, I get 14 values, ending in 29:
values:Array[14]
0:Array[1593616020000,39]
1:Array[1593616140000,28]
2:Array[1593616260000,28]
3:Array[1593616320000,28]
4:Array[1593616380000,37]
5:Array[1593616440000,28]
6:Array[1593617340000,37]
7:Array[1593617460000,29]
8:Array[1593619320000,39]
9:Array[1593619440000,39]
10:Array[1593619440000,38]
11:Array[1593619860000,30]
12:Array[1593621240000,37]
13:Array[1593624180000,29]
Does anyone have ANY idea why the same data set returns 14 items in one graph but 15 in another? Surely it wouldn’t be an InfluxDB problem, as the data is visualized in one graphic but not another?