Programming

Node Red

Node red in docker

Python

Logic Analyser

Instruction video

Software Sigrok

Install Zadig driver from programfiles pulseview

Fuxa HMI


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