I want to know when the latest data point is for each value of some other field, and how old it is. Here’s the query I wrote: select now() - time, last("temperature") from temps group by location; But I get ERR: undefined function now() which seems odd because I can use that expression in the “w…

I should clarify: The thing I want to “groupy by” is a tag, not a field. So the grouping, I believe, should be fairly efficient. The problem with certain uses of now() remains.

@ezquat Did you fixed this, I have the same issue.

@daochun_zhao I never solved it, or found a workaround, alas!

Probably best to report as a bug on the slack channel regarding flux, or something.

Now() is sometimes not a function?

InfluxDB 2

ezquat August 12, 2020, 12:24am 6

In another thread, @anaisdg explains this can’t be done in InfluxQL but it can be done in Flux: How to get how much time elapsed since data point is stored in influxdb

Topic		Replies	Views
How to get how much time elapsed since data point is stored in influxdb influxdb	2	3235	August 10, 2020
Time difference between last record and now() InfluxQL chronograf , grafana , influxql	2	1173	March 21, 2023
Get time delta in InfluxQL InfluxQL influxdb , chronograf , grafana , influxql	1	784	April 6, 2023
Time difference from now	0	1141	November 26, 2017
Getting incorrect time from InfluxQL query InfluxQL influxql	5	102	August 7, 2024

Now() is sometimes not a function?

Related topics