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	362	September 28, 2023
Getting the next/previous value based on calculation Fluxlang flux	0	376	January 8, 2022
Using the previous and the subsequent row value to conditionally interpolate the current value between the two Fluxlang flux	1	2643	July 7, 2021
Take difference of current value and value one week ago (Ever increasing data) Fluxlang time-series , flux	3	809	March 6, 2022
Create a new column adding _measurement as suffix Fluxlang influxdb , schema , query , flux	0	371	September 12, 2022