Hi
Been trying for quite some time now to figure out Grafana. Getting nowhere in my queries I hope for some help here.
I have a TouCAN connected to my
NMEA 2000 and a working Signal k server on a raspberry PI. All the measured values are written to a InfluxDB database also on the PI. And Grafana to present the values. I have no trouble make a query, in influxQL, getting a serie of values for different measurements.
My goal is to use this for calibrating my H3000. The measurements I am intressted in are
Speed overground
Speed through
water
Roll
First I calculate in Grafana the difference between speedover ground / speed through
water. This works fine.
But I also want the difference at different roll angles and in different speeds envelopes. Like between 0 and 5 degrees roll and 0 and 5knops speed, what is the average error. Then 5-10 degrees roll and 5-10 knops speed. And so on.
Lots of testing with no success. I asked ChatGPT and got an answer that did not
work.
SELECT Mean("your_measurement") As "average_value"
From "your measurement"
Where "measurement1" >= minvalue1 and "measurement1" <= maxvalue1
and "measurement2" >= minvalue2 and "measurement2" <= maxvalue2
and time >= 'start_time* and time <= 'end_time'
Any help or pointers would be very much appreciated.
Thanks / Christian