Calculate and display Energy (kWh) use from smart meter energy readings

[koenwindey]

Another option is to calculate the difference in the query from the totals stored in InfluxdB.

I do something very similar with NodeRed and Influx. There is no need to save daily totals in the database, instead you calculate them using the difference() function available in Flux.

See my post here:

Can't get side-by-side bar graph with multiple series

So it gets a bit more complicated than just adding a time offset. Although my first attempt (above) worked well, it did not consistently render with the same column width. The column width is calculated dynamically, see @torkel 's comment here: https://community.grafana.com/t/chart-with-custom-bar-width-for-each-time-intervall/11269 So in order to avoid overlapping columns you should not only offset the series’ timestamps, you also should add ‘dummy’ zeros in each series. In my flux query, the …