Influxdb: Enhancement request: Allow nested select functions, ex: select sum(derivate(value))...;

[cboggs]

We store our data in InfluxDB such that each individual metric is its own series, and we insert a hostname value into each update so that we can build out dashboards for clustered services without falling back to regex'd series names, and we keep our series count down.

Some of our metrics are counters that we take a derivative of at search time. When viewing each host individually this works fine, but if I want to roll up those values easily across a set of hostnames that exist in the series, I can't do much other than:
select derivative(value) from seriesName group by time(30s), hostname;
and then see independent lines graphed for each hostname in tools like Grafana.

If I could instead query it as follows, aggregate graphs would be much easier and more universally applicable:
select sum(derivative(value)) from seriesName group by time(30s);

[jvshahid]

This should address all nested aggregates. Or at least return an error for invalid combinations.

[reardencode]

:+1: sum(derivative(value)) would also be very useful for me.

[srikara]

+1

[h-svab]

mean(derivative(value)) would be very welcome

[grypyrg]

+1

[daniel-nichter]

+1

[nethalo]

+1

[beckettsean]

As mentioned in my post to the mailing list we are experimenting with simplifying our open GitHub Issues. This feature request has been rolled into an aggregate issue for all function requests, so that we can close this issue until we are ready to work on it.

You may continue to make comments here. Closing the issue does not mean we are rejecting this idea.

[fillest]

I'm getting error parsing query: expected field argument in sum() for SELECT sum(non_negative_derivative("requests_started", 1s)) FROM "nginx.status" WHERE "host" =~ /censored-.*/ AND $timeFilter GROUP BY "host" - is it the same issue, should I reopen it?

[fillest]

Aaah sorry, I didn't read previous comment about the aggregated issue.

[erowan]

+1

[dddda212]

+1

[leftwukaixing]

+1

[henriklb]

+1
sum(non_negative_derivative(value)) would be useful for me