Hello together, I’m trying to create a query that operates on a given table. The goal is to add a new column val that calculates the difference between the current and the previous value of column _value if the current value is bigger than the previous and _field of the current row is equal to _fiel…

Create column based on previous row value

alespour January 24, 2022, 9:16am 4

I think the subtraction is always calculated, if you try it without nonNegative: true and fill(), you will see.

Map function: Values from previous rows

Topic		Replies	Views
Map function: Values from previous rows InfluxDB 2 flux	2	683	September 28, 2023
Getting the next/previous value based on calculation Fluxlang flux	0	468	January 8, 2022
Using the previous and the subsequent row value to conditionally interpolate the current value between the two Fluxlang flux	1	3148	July 7, 2021
Take difference of current value and value one week ago (Ever increasing data) Fluxlang time-series , flux	3	962	March 6, 2022
Compare consecutive values of the same field Fluxlang influxdb , time-series , query , flux	0	552	October 25, 2021