Interpolate data every hour

[Baarken]

Hi all

Is the following possible to do in influx:
I have kWh-data comming into influx every 10 minutes +/- a random delay of a few seconds.

Lets say I have data at 14:54 and 15:04, is it possible to interpolate and get the value at 15:00, and do the same for all hours the last 24h?

Or do I have to write my own script in e.q. python?

Thanks

[rawkode]

Hi, you can use linear fill. We have an article on this:

InfluxQL Support For Linear Interpolation in GROUP BY Time() Queries

Let us known if we can help further

Thanks

[Baarken]

Sweet!

I’ll look at it at the beginning of next week, thanks.