Ignoring a Data Point after Gap in Timestamping

Hello -

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