Dear experts, I’m storing data from a bunch of sensors in an InfluxDB database (to monitor them in Grafana). Besides the actual sensor readings I also want to monitor if the sensors are sending regularly new values, since the sensors use a wireless connection that may have problems. Since I know …

Hello @cortlieb , If you want to look back in time use the where clause The WHERE clause | InfluxDB Cloud (TSM) Documentation Use the WHERE clause to filter data based on fields, tags, and/or timestamps. for example SELECT * FROM "h2o_feet" WHERE time > now…

GROUP by time looking "backwards" from a specific timestamp

InfluxDB 2

Anaisdg August 8, 2024, 12:00am 3

Unfortunately there isn’t a way to look at time relative to the last timestamp with influxql.
I might suggest using another processing tool like quix or bytewax.

Topic		Replies	Views
Influxdb group by time() not working	3	1797	July 30, 2019
Data operations on a group of data Fluxlang	1	411	June 25, 2021
Data returned outside of time range specified influxdb	5	1349	January 9, 2019
Influxdb group by from most recent time influxdb	0	658	January 27, 2018
Query Problem - including GROUP BY time() acts weird? Store influxdb , influxql	3	2274	May 4, 2017

GROUP by time looking "backwards" from a specific timestamp

Related topics