I am trying to graph my home power usage by capturing data from my power meter and storing it in InfluxDB with Grafana for visualization.
The data coming from my meter is cumulative and so it is a large number that always grows, and I will be using Python to push the data to InfluxDB. I want to have the ability to view the data on a daily, weekly and monthly basis, and I am comfortable enough with Python that I could do some form of data transformation if needed.
This gets me to my question. What is the best way to store the data to be able to get the desired daily, weekly and monthly views?
My guess is that it would be easiest to store the changes as it would be easier to group the data. Is that right? (The one problem is that the data does not change all that rapidly.) If I stored the cumulative number, could I still access the desired views?
TIA in advance for any thoughts.