I am trying to setup an energy-clock graph and I am a bit lost at the following issue: my energy clock counts in Wh (watt-hours), and I think I can convert it to kWh on the query side (should be possible to just divide by 1000, I guess).
However, the numbers are well over 1000 (currently around 2900), so Grafana converts this to mWh. Not that it would be technically wrong (1000 kWh is 1 mWh, after all), but nobody uses mWh in normal one-house energy calculations.
Having read about short+postfix workaround, I tried “stat” visualization, but that one does not offer any postfix nor even unit selection (I am on Grafana v7.5.3).
So in a nutshell, I want to ideally only convert to kWh, or if it is not possible, prevent unit conversion entirely (while still displaying a kWh postfix).
Thanks in advance