Hi, I try to get the following information out of my measurement: [image] when was the last value change from “0” to “1” and when was the last value change from “1” to “0”. I study already the flux help, but I haven’t found a solution for that kind of query. Simply using min() and max() will n…

Hello @dewenni , Have you tried: monitor.stateChanges() function | Flux 0.x Documentation monitor.stateChanges() detects state changes in a stream of data with a _level column and outputs records that change from fromLevel to toLevel. ? Thanks

How to get the latest timestamp of value change (0>1 or 1>0)

InfluxDB 2

Anaisdg April 13, 2022, 7:01pm 2

Hello @dewenni,
Have you tried:

?
Thanks

1 Like

Topic		Replies	Views
Get data only at points where value changes from previous timestamp Fluxlang	8	5029	October 13, 2021
Get the last value from a different measurement on a specific point of time InfluxDB 2 influxdb , query , flux	4	682	April 20, 2021
Find timerange based on the change of a value Fluxlang	3	3376	December 22, 2020
How to verify if the last value changed from last query? InfluxDB 2	1	267	November 26, 2022
How to filter data to show only changes in InfluxDB? InfluxDB 2 influxdb	0	55	November 21, 2024

How to get the latest timestamp of value change (0>1 or 1>0)

Related topics