Are there plans for supporting time weighted queries in InfluxDB?
For example, if I am recording the RPM of some equipment then I want to know the total time (typically in seconds) that the RPM was > than a threshold within a varying time window. This is typically a dynamic search request from a user so trying to pre-calculate it is not particularly useful here.
@Rhys_Kirk_TGG there’s an open feature request to add time weighted queries. It’s not currently assigned to a release milestone. See if the requested feature lines up with what you need. Feedback on the issue is welcomed & encouraged.
That issue only focuses on the mean value weighted by time.
There are a few other scenarios, like total time true for a query (e.g. total time compressor > ‘x’ rpm within last 7 days). Obviously the time range is configurable so it would need to be a low impact query.
At the moment you would need to hack it with a daily totaliser for each field you want the ‘time true’ result for, running that totaliser each second, then something like a stdev per day.
A slight irony that a time-series database doesn’t support time weighted functions?
@Rhys_Kirk_TGG We have had a lot of requests for this feature however everyone I’ve heard from has asked for different tine weighting methods. If you could comment on that issue with exactly what you are looking for it would help us implement the feature.
