The timestamp cannot be used in the SELECT clause. The derivative function accepts a time interval for the units. You can use that with SUM or CUMULATIVE_SUM to generate a rate of change per interval.
On Thu, Nov 17, 2016 at 12:14 PM, <[email protected]> wrote: > I need to sum values on a time interval and divide them by the time > interval. > For instance, I have values for requests length (req_len) from nginx. > I would like to graph the request bytes / s with grafana. > How can I do that? > Something like: select sum(req_len)/interval .... group by time(interval) > Maybe with the new cumulative_sum function? > select derivative(cumulative_sum(req_len)) ... ? > > Many thanks for your help. > > -- > 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 [email protected]. > To post to this group, send email to [email protected]. > 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/da8b747c-60f5-4819-a0b2-77f6a884f14d%40googlegroups.com. > For more options, visit https://groups.google.com/d/optout. > -- Sean Beckett Director of Support and Professional Services InfluxDB -- 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 [email protected]. To post to this group, send email to [email protected]. 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/CALGqCvPh-GaqcTU0Fvuw0%2B78EFJhPMTsjKCdWDQ4_6%3DvckiYoA%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
