Is there an easy way to drop the first and last values/rows? I was thinking something along the lines of this: |> filter(fn: (r) => r != first() and r != last())

Ok, I think I’ve finally got something that works. rowCount = data |> count(column: "_value") // Count total rows |> findRecord(fn: (key) => true, idx: 0) // Extract row count as a record data |> tail(offset: 1, n: int(v: rowCount._value) - 2) // Remove the first and last row The whole que…

Influx - drop the first and last rows/values from the table

Grafana InfluxDB

jjm November 29, 2024, 1:04pm 4

This topic seems to be discussing the exact same problem: Removing first & last data points

Topic		Replies	Views
Reducing Series to First Value Bar Gauge Panel	5	221	July 11, 2024
Removing first & last data points Time Series Panel influxdb , sql	4	555	November 29, 2024
Filter by time but not date or drop first record...? Grafana influxdb	3	208	June 3, 2024
Last() value within a time range InfluxDB influxdb , query-help , dashboard	5	8158	February 3, 2023
InfluxDB sum of all values InfluxDB influxdb , influx	10	99	November 27, 2024

Influx - drop the first and last rows/values from the table

Related topics