Help with Grafana

[chris the rat]

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

[HeywoodJ]

So many questions. If you can post the SOG/STW query that works, and a small sample of the data table so that we can see structure it would go a long way toward being able to offer suggestions.