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…

Which task are you trying to solve? Here is a simple code snippet for filtering out first and last records: import "sampledata" data = sampledata.int() first = data |> first() |> tableFind(fn: (key) => key.tag == "t1") |> getRecord(idx: 0) last = data |> last() |> tableFind(…

It’s a bit related to another issue I was trying to solve: InfluxDB sum of all values - #3 by jjm I wanted to sum all the values, but the inconsistent times were causing issues. Through lots of trial and errors, I finally got it working consistently well with this: option minWindowPeriod = 2m fr…

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
Removing first & last data points Time Series Panel influxdb , sql	5	1395	February 17, 2025
GroupBy 1day, last row value is always empty InfluxDB influxdb , query-help , time-series-panel	0	316	March 31, 2023
Reducing Series to First Value Bar Gauge Panel	5	607	July 11, 2024
Table showing last value with conditional	4	6202	December 9, 2019
Table with Influx 2.0 InfluxDB plugins , influxdb , query-help , flux	18	6772	August 3, 2022

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

Related topics