I have a sequence of data (from a water supplier) in the following format in influxdb
timestamp : daily_usage
The data is provided hourly from the water co. So i have data like:
2018-01-01 00:00:00 - 0.5
2018-01-01 01:00:00 - 0.2
2018-01-01 02:00:00 - 0.6
2018-01-01 03:00:00 - 0.1
Now - the issue is that sometimes the data misses a report or two. Sometimes, just an hour, sometimes a day or two.
In this instance i now have data like:
2018-01-02 00:00:00 - 0.5
2018-01-02 01:00:00 - 0.3
2018-01-02 05:00:00 - 8.2
2018-01-04 02:00:00 - 72
As you can imagine, when then graphing this to analyze daily usage it creates all sorts of issues!
So my question is: when you have data with gaps in timestamping, and the first value after that gap is a cumulative result of the missing reports, can i either:
a) instruct grafana to average that first value over the missing timestamps (unlikely i know)
b) ignore that first value entirely so that i may create usable graphing
If neither are possible i would be curious if there is any other app that i could use to parse the csv data to achieve the above prior to sending to influxdb.
Many thanks for any thoughts