Discussion:
[influxdb] How to calculate the average, but ignore actual date?
m***@gmail.com
2017-10-23 12:57:21 UTC
Permalink
Is there a way to calculate the average in a certain time window ignoring the date? I have a need to get the average on certain time intervals..

Example:

00.00h - 00.10h - <field average>
00.10h - 00.20h - <field average>
...

So i would like to get an average on certain timeslots without the date values. The normal mean() method takes into account the actual dates.

Any hints or tips on how this can be done using InfluxDB sql?
--
Remember to include the version number!
---
You received this message because you are subscribed to the Google Groups "InfluxData" group.
To unsubscribe from this group and stop receiving emails from it, send an email to influxdb+***@googlegroups.com.
To post to this group, send email to ***@googlegroups.com.
Visit this group at https://groups.google.com/group/influxdb.
To view this discussion on the web visit https://groups.google.com/d/msgid/influxdb/65b5812b-bcda-4128-b89a-9b9523af4cb3%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
Loading...