I have a fault status that I’m monitoring and recording in my InfluxDB, the Value is true or false. I want to count the number of faults during the last X amount of time, according to the time range selected in the Grafana interface. But I cannot get the Query to work in any of the Panels.
My query works in InfluxDB CLI and the data looks like this (see picture for both):
One problem is that I cannot access the Value column of the data, only DeviceId is available:
Next, I tried to enter it manually instead of using the Query wizard in the Panel Configuration, but this didn’t work either. It seems to ignore it. It looked like this:
SELECT count(“Value”) FROM “EndPositionWarning” WHERE (“Value”=true) AND $timeFilter GROUP BY time(10m) fill(null)
But this returns “No Data” in all the visualizations (Single Stat, Graph, Bar Graph, etc.)
In the end, I would like a bar graph to show different counts of different faults to see which one is worse. But I can’t get the simple query working yet.
Any ideas? Much appreciated…