I am trying to model an electrical meter as well as various data points associated with it. Some data we're collecting from the meter includes Start Date, End Date, and Consumption.
Modeling the meter itself has been fairly straight forward, but has anyone found a good method for modeling billing range data points? I'm collecting this data every month and therefore it is a time series point, but I'm not sure on how to tag/model the billing period (start and end ranges).
Any help would be great!
Brian FrankTue 22 Mar 2022
There is no standard for that in Haystack today.
In our software we model model bill periods as a stream of timestamps for the beginning of the billing period and the value is the billing tariff in effect for that period:
Brett Boyer Tue 22 Mar 2022
I am trying to model an electrical meter as well as various data points associated with it. Some data we're collecting from the meter includes Start Date, End Date, and Consumption.
Modeling the meter itself has been fairly straight forward, but has anyone found a good method for modeling billing range data points? I'm collecting this data every month and therefore it is a time series point, but I'm not sure on how to tag/model the billing period (start and end ranges).
Any help would be great!
Brian Frank Tue 22 Mar 2022
There is no standard for that in Haystack today.
In our software we model model bill periods as a stream of timestamps for the beginning of the billing period and the value is the billing tariff in effect for that period:
So that Jan billing period would start at the given timestamp, and then end at the next timestamp (2022-02-01T00:00).
Brett Boyer Tue 22 Mar 2022
Thanks Brian! That's exactly what we proposed to do as well!