Since a couple of months I got a digital water meter. I was promised I could read it via my energy meter, but due a new type, this is not working (yet). So my digital meter is for me dumber than my analogue one, because I was able to read it with a pulse counter…
This week I discovered an online platform where all my data can be found! Nice, but offcourse no open API, and not able to find out how the authentication works.
There is a possibility to download all data in a csv file . One value per day (liters). I started with Powershell to add all this data into my influxdb (v1). I choose to store the cumulative values, so I can use it in graphs and maybe ready for the future when I can connect directly to the meter.
This was not so hard, but when I display it in a chart and choose diff_last (as I do with all these kind of items), I don’t get any values for the first day of the month (chart type month). All other values are correct. When I choose the year chart, the values of each month are correct (even for the month January).
When I select diff_first and set offsetAmount: 1 & offsetUnit: hour, it seems to be fixed, but not the way to go I guess.
I remember these issues in the past, but they we’re fixed in oh v3.4, and I don’t have the issues with other items. So I think there’s an issue with the datapoints. I store each value on 23:59:59 of each day. I already tried to do it on 00:00:00, but doesn’t solve the problem.
Is there a better/different way to save these values in influx?