+- OpenMarine (https://forum.openmarine.net)
+-- Forum: OpenPlotter (https://forum.openmarine.net/forumdisplay.php?fid=1)
+--- Forum: How do I...? (https://forum.openmarine.net/forumdisplay.php?fid=3)
+--- Thread: SignalK - InfluxDB - Grafana - how to display customized units (/showthread.php?tid=2459)
SignalK - InfluxDB - Grafana - how to display customized units - SkipperEarly - 2020-03-28
I understand that units used in SignalK are standardized, which means e.g. temperature is in Kelvin.
My brain however just works in Celsius and I have therefore set in the OP diagnose SiglakK the privat units from K>C. Converted values are sent correctly in NMEA strings to Ocpn.
I now would like to store historic values in InfluxDB and display them with Grafana - which was recommended by some other users. Have managed to configure the grafana dashboard but struggle to get the units for temperature and pressure converted to my preferred units.
Do I miss some setting in either of the tools?
Has anyone solved this little problem without programming or scripting?
RE: SignalK - InfluxDB - Grafana - how to display customized units - e-sailing - 2020-03-28
When you go to your grafana query you have to add math (-273).
It should look like:
FROM default environment.cpu.temperature
WHERE SELECT field (value) mean () math (-273)
GROUP BY time ($__interval) fill (null)
RE: SignalK - InfluxDB - Grafana - how to display customized units - Blue Ocean - 2020-03-28
RE: SignalK - InfluxDB - Grafana - how to display customized units - SkipperEarly - 2020-03-28
(2020-03-28, 04:46 PM)e-sailing Wrote: When you go to your grafana query you have to add math (-273).
It should look like:
FROM default environment.cpu.temperature
WHERE SELECT field (value) mean () math (-273)
GROUP BY time ($__interval) fill (null)
GREAT - thanks a lot e-sailing!!!
got it to work