Delete single data point

InfluxDB 2
1

Hi all, I want to delete the single data point with a value of 0

Screenshot 2023-01-28 at 09.23.18
Screenshot 2023-01-28 at 09.23.181154×405 50.9 KB

My command is

influx delete \
  --bucket dht22 \
  --org esp8266 \
  --token 4WW43qswEQUdpTnWedvhuyQa8ftEgi0vJNv6zfTV0bOhtSdrMYei-MJYSCpawRxcKkNs1NBrMf1ORV0kxdMK23D== \
  --start 2023-01-28T08:54:20.000Z \
  --stop 2023-01-28T08:54:20.000Z

Running it as root from a terminal, it seems to accept the command but the data point is still there?

2

Got it, had to select the data point before and the one after the actual point I wanted to delete.

  --start 2023-01-28T08:54:05.00Z \
  --stop 2023-01-28T08:54:45.00Z
2 Likes
3

@HenrysCat
Thanks for sharing your solution! PS what do you use influxdb for?

4

Logging temperature and humidity readings and sending to Grafana, will have over 10 sensors eventually.

5

you should probably censor your org, bucket and token and delete the token you posted from your database