{"action":"created","issue":{"url":"https://api.github.com/repos/influxdata/influxdb/issues/5806","repository_url":"https://api.github.com/repos/influxdata/influxdb","labels_url":"https://api.github.com/repos/influxdata/influxdb/issues/5806/labels{/name}","comments_url":"https://api.github.com/repos/influxdata/influxdb/issues/5806/comments","events_url":"https://api.github.com/repos/influxdata/influxdb/issues/5806/events","html_url":"https://github.com/influxdata/influxdb/issues/5806","id":135833351,"number":5806,"title":"Different aggregates for intra-series vs cross-series","user":{"login":"cxreg","id":55474,"avatar_url":"https://avatars.githubusercontent.com/u/55474?v=3","gravatar_id":"","url":"https://api.github.com/users/cxreg","html_url":"https://github.com/cxreg","followers_url":"https://api.github.com/users/cxreg/followers","following_url":"https://api.github.com/users/cxreg/following{/other_user}","gists_url":"https://api.github.com/users/cxreg/gists{/gist_id}","starred_url":"https://api.github.com/users/cxreg/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/cxreg/subscriptions","organizations_url":"https://api.github.com/users/cxreg/orgs","repos_url":"https://api.github.com/users/cxreg/repos","events_url":"https://api.github.com/users/cxreg/events{/privacy}","received_events_url":"https://api.github.com/users/cxreg/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":10,"created_at":"2016-02-23T19:12:56Z","updated_at":"2016-03-10T22:34:45Z","closed_at":null,"body":"Is there any way to run different aggregate functions in a query, so that I could max(some_counter) within a time bucket but sum() across the series?  I have a lot of values that are monotonically increasing counters across a bunch of hosts, and to run a fleet-wide derivative I really only need one sample per host.\r\n\r\nWhen I just use sum() it works a lot of the time, but if a sample is lost, it skews the derivative and I get massive spikes in the graph making it unreadable.\r\n\r\nDoes this make sense?"},"comment":{"url":"https://api.github.com/repos/influxdata/influxdb/issues/comments/195081311","html_url":"https://github.com/influxdata/influxdb/issues/5806#issuecomment-195081311","issue_url":"https://api.github.com/repos/influxdata/influxdb/issues/5806","id":195081311,"user":{"login":"cxreg","id":55474,"avatar_url":"https://avatars.githubusercontent.com/u/55474?v=3","gravatar_id":"","url":"https://api.github.com/users/cxreg","html_url":"https://github.com/cxreg","followers_url":"https://api.github.com/users/cxreg/followers","following_url":"https://api.github.com/users/cxreg/following{/other_user}","gists_url":"https://api.github.com/users/cxreg/gists{/gist_id}","starred_url":"https://api.github.com/users/cxreg/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/cxreg/subscriptions","organizations_url":"https://api.github.com/users/cxreg/orgs","repos_url":"https://api.github.com/users/cxreg/repos","events_url":"https://api.github.com/users/cxreg/events{/privacy}","received_events_url":"https://api.github.com/users/cxreg/received_events","type":"User","site_admin":false},"created_at":"2016-03-10T22:34:45Z","updated_at":"2016-03-10T22:34:45Z","body":"BTW I verified that in Graphite, using this same sourec data, I can do nonNegativeDerivative(sumSeries(keepLastValue(<multiple series>))) which does not exhibit my problem, but when I do nonNegativeDerivative(keepLastValue(sumSeries(<multiple series>))), it does look like the broken graphs that Influx is giving me.  Maybe further evidence that both forms could be useful in different situations."}}