Is it possible keep only value changes in influxdb?

Question

Is it possible to downsample older data using influxdb in a way that it only keeps change of values?

My example is the following:
I have a binary sensor sending data every 10 min, so naturally the consecutive values look something like this: 0,0,0,0,0,1,1,0,0,0,0...

My goal is to keep this kind of raw data over a certain period of time using retention policies and downsample the data for longer storage. I want to delete all successive values with the same number so that I have only the datapoint with their timestamps when the value actually changed. The downsampled data should look like this: 0,1,0,1,0,1,0.... but with the correct timestamp when the event actually occurred.

score 0 · Answer 1 · answered Jun 20 '16 at 15:37

0

Currently this isn't possible with InfluxDB, though the plan is to eventually support this kind of use case.

I would encourage you to open an feature request on the InfluxDB repo asking for this.

answered Jun 20 '16 at 15:37

Michael Desa

4,607
24
19

1

hi Michael. Has something changed since 4 years? – MR.GEWA Apr 22 '20 at 17:21
Me too waiting. – Arun Pal Sep 03 '20 at 09:47
Definitely would be a nice feature. if it could work for values and tags it would be even better. – Grimmy Jun 14 '22 at 18:14

Is it possible keep only value changes in influxdb?

1 Answers1