Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Jan 01, 2017 09:47 AM
I want to track meter readings for electricity and water consumption.
The relevant columns are:
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?
Thanks!
Sep 15, 2018 10:05 AM
Thanks @Csaba_Vass
Let me know if you see anything when you look at it later.
I think I follow you… when you add a new date to the table ‘electricity’ will it automatically add the date to the ‘calculation’ table or do you need to keep adding dates to both tables for the calculations to keep going?
Sep 15, 2018 12:03 PM
It won’t work automatically. When I add a new entry, I need to add (select) the proper dates in calculation fields. I’ll check the sample and fill with some new entry, and then I’ll write the method step by step.
Russ_Layton airtable@discoursemail.com ezt írta (időpont: 2018. szept. 15., Szo 19:15):
Sep 17, 2018 02:30 AM
The step by step guide:
Last date and check date fields in calculation table are linked fields to ‘electricity’ table so they show the primary field (date)
‘last check’ and ‘el.meter check’ - renamed to ‘actual check’ - fields are lookup field and pointed to electricity table’s ‘el meter at date’ fields, so they show the checked data.
‘… check’ fields’ format is set to currency, and the currency symbol is customized to kWh. You can use it to show any measured unit
The lookup field is working only when you have a linked field too. thats why the actual check fields aren’t filled while the check dates aren’t selected.
I set the your share options to editor, you can try it now in work. It is only a sample copy with some filled data