Is there a workaround to get a center zero gauge or histogram?
I want to monitor/report on Net Energy. If generation from solar panels exceeds consumption then we are exporting (-ve) otherwise we are importing (+ve).
I have seen other questions on centre zero guages but not found a way to to do it - how have others solved this problem?
Datasourse is influxDB v1.8 which receives data from my energy monitor (IoTaWatt)
Grafana version is 7.5.5
What I am aiming for is a dial that runs from (say) minus 10Kw to + 10kw with zero in the centre. The color (reading) should then from the centre towards the left if negative and from the centre towards the right if positive.
A histogram would work for this use case (instead of a dial) but if I set the histogram limits from -10 to +10 and have a reading of (say) 2 then the bar starts at -10 and runs to 2 instead of starting at zero and running to 2.
is there a way to say ‘start the bar at zero rather than the minimum’ for a histogram?