Hi everybody… I have a data with the following structure: [image] table_result _measurementgroupstring _fieldgroupstring _valueno groupdouble _startgroupdateTime:RFC3339 _stopgroupdateTime:RFC3339 _timeno groupdateTime:RFC3339 domaingroupstring entity_idgroupstring friendly_namegroupstring so…

Calculate time between a value change

grant1 February 20, 2024, 3:02am 2

Did you read / try this?

1 Like

Topic		Replies	Views
SQL statement to calculate difference between specified value and all other values of one field InfluxDB 2	0	938	April 7, 2019
Calcualte column/value from group query or using timespans with gapped data?	1	721	March 28, 2017
Calculating the time between 2 datapoints InfluxDB 2 query	4	65	August 6, 2024
Time changed when insert data into measurement by used to() InfluxDB 2 influxdb , query , flux	1	63	July 4, 2024
[InfluxQL] Selecting value and time since last value Dashboards	2	1643	August 16, 2020