Electricity balance: flux magic to calculate

I am on an annual electricity plan and I want to calculate if I am using more or less power than I generate throughout the year. This video is about how I start doing that.

Chapters:
0:00 Intro
2:41 Why do I need this?
4:59 How it is stored in Influx
7:35 Data entry in Node-Red
12:57 Selecting data in Flux
16:23 Join()
19:48 Calculate the balance
20:51 Grafana panel
22:08 Thoughts for future

[BGazzah]

Excellent use of flux - Im still in the very early stages of converting from an old (>2 yrs) install of grafana to the newer version. So flux is a learning process for me. Agree on the community forums; they are really good and helpful.