6

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.

p0fi
  • 1,056
  • 12
  • 28

1 Answers1

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.

Michael Desa
  • 4,607
  • 24
  • 19