I’ve tried to search but can’t seem to find a reference for the problem I am having. I have some queries that are using a Group By (tag_device) and I am needing to show null as zero, but I cannot add the time filter and fill(null) or fill(0) options.
On the first two graphs, the queries are as follows:
SELECT “value” FROM “gpu_temp” WHERE (“host” =~ /^Worker/) AND $timeFilter GROUP BY “gpu_device”
SELECT “value” FROM “gpu_powerdraw” WHERE (“host” =~ /^Worker/) AND $timeFilter GROUP BY “gpu_device”
The third graph works properly with the following:
SELECT mean(“value”) FROM “current_hashrate” WHERE (“host” =~ /^Worker/) AND $timeFilter GROUP BY time(5m) fill(0)
I have set the stacking/null options to “null as zero” in the display options, but it doesn’t seem to make a difference as the query is not interpreting the null/zero values when the rig is down. If there is a better way to accomplish a similar graph, please let me know.