Logic Analyser
Install Zadig driver from programfiles pulseview
GRAFANA
Query for hour values
SELECT sum("mean")/3600000 FROM (
SELECT mean("PowerToBoiler") FROM "PowerToBoiler" WHERE $timeFilter GROUP BY time(1s) fill(previous)
) WHERE $timeFilter GROUP BY time(1h) fill(null)
Query for day values
SELECT sum("mean")/3600000 FROM (
SELECT mean("PowerToBoiler") FROM "PowerToBoiler" WHERE $timeFilter GROUP BY time(1s) fill(previous)
) WHERE $timeFilter GROUP BY time(1d) fill(null)
<div style="overflow:auto;max-height:150px;">
<pre><code>
</code></pre>
</div>
test