Hi Team, @Anaisdg , @scott , @grant1 Is there any way we can use map() or something similar that can use values from previous rows please? :pray: I’m trying to create a column call pct_change where in pct_change = value from colA at time t / value from colB at time t-1 Regards, Teja

Map function: Values from previous rows

ajetsharwin September 6, 2023, 7:10pm 2

Hey @alespour , maybe you have an idea based on your answer in this [post] ?(Create column based on previous row value - #4 by alespour)

Topic		Replies	Views
Create column based on previous row value Fluxlang influxdb , query , flux	3	1706	January 24, 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
Get data only at points where value changes from previous timestamp Fluxlang	8	5005	October 13, 2021
How can I get the value of the previous record? InfluxDB 2 query	2	691	December 12, 2023
Lead() to get next "row" value InfluxDB 2 flux	1	556	August 24, 2022