{"action":"closed","issue":{"url":"https://api.github.com/repos/influxdata/influxdb/issues/4820","repository_url":"https://api.github.com/repos/influxdata/influxdb","labels_url":"https://api.github.com/repos/influxdata/influxdb/issues/4820/labels{/name}","comments_url":"https://api.github.com/repos/influxdata/influxdb/issues/4820/comments","events_url":"https://api.github.com/repos/influxdata/influxdb/issues/4820/events","html_url":"https://github.com/influxdata/influxdb/issues/4820","id":117357025,"number":4820,"title":"Continuous Query Every Minute grouped by 5m","user":{"login":"sundarv85","id":11090193,"avatar_url":"https://avatars.githubusercontent.com/u/11090193?v=3","gravatar_id":"","url":"https://api.github.com/users/sundarv85","html_url":"https://github.com/sundarv85","followers_url":"https://api.github.com/users/sundarv85/followers","following_url":"https://api.github.com/users/sundarv85/following{/other_user}","gists_url":"https://api.github.com/users/sundarv85/gists{/gist_id}","starred_url":"https://api.github.com/users/sundarv85/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/sundarv85/subscriptions","organizations_url":"https://api.github.com/users/sundarv85/orgs","repos_url":"https://api.github.com/users/sundarv85/repos","events_url":"https://api.github.com/users/sundarv85/events{/privacy}","received_events_url":"https://api.github.com/users/sundarv85/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/influxdata/influxdb/labels/category/continuous%20queries","name":"category/continuous queries","color":"207de5"},{"url":"https://api.github.com/repos/influxdata/influxdb/labels/category/feature%20request","name":"category/feature request","color":"006b75"}],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":4,"created_at":"2015-11-17T13:44:35Z","updated_at":"2016-05-27T17:51:29Z","closed_at":"2016-05-27T17:51:29Z","body":"We are developing an alerting system, which checks whether the threshold is crossed in the last 5 minutes. However, we want to test this every minute whether the last five minutes has crossed a specific interval.\r\n\r\nCurrently this is not possible in continuous queries.\r\n\r\nEven when we give \"group by time(5m)\", and have *compute-runs-per-interval* as 10 and *compute-no-more-than* set to 1m, even though it would run every minutes, it would only store once in 5 minutes. ie. we will find 01:05 and then 01:10.\r\n\r\nOur requirement is to have five entries\r\n\r\n01:05 (this has avg of 01:01 till 01:05)\r\n01:06 (this has avg of 01:02 till 01:06)\r\n01:07 (this has avg of 01:03 till 01:07)\r\n...\r\n01:10 (this has avg of 01:06 till 01:10)\r\n\r\nSuch a feature would be very helpful.\r\n\r\n[Refer discussion at google groups](https://groups.google.com/forum/#!topic/influxdb/6zwYutM5K5k)"}}
{"actor":{"display_login":"beckettsean"}}