I want to track meter readings for electricity and water consumption.
The relevant columns are:
- Date of the reading
- Reading (eg. kWh, m^3)
I want to calculate how much kWh or m^3 was used between meter readings and then how much was used per day.
In excel or similar systems I referenced the Date and Readings Entries for the previous Record to calculate the difference in kWh or m^3 and Time. I’m having problems modelling the same concept here. How would you do it?
Or do I need another table for my analysis? If so: can I automatically populate the Date column in the Analysis Table from the Readings Table?