{"action":"opened","issue":{"url":"https://api.github.com/repos/influxdb/influxdb/issues/1654","labels_url":"https://api.github.com/repos/influxdb/influxdb/issues/1654/labels{/name}","comments_url":"https://api.github.com/repos/influxdb/influxdb/issues/1654/comments","events_url":"https://api.github.com/repos/influxdb/influxdb/issues/1654/events","html_url":"https://github.com/influxdb/influxdb/issues/1654","id":58279736,"number":1654,"title":"mean(...) query fails when using group by time with no data in one time period","user":{"login":"jnutzmann","id":3182307,"avatar_url":"https://avatars.githubusercontent.com/u/3182307?v=3","gravatar_id":"","url":"https://api.github.com/users/jnutzmann","html_url":"https://github.com/jnutzmann","followers_url":"https://api.github.com/users/jnutzmann/followers","following_url":"https://api.github.com/users/jnutzmann/following{/other_user}","gists_url":"https://api.github.com/users/jnutzmann/gists{/gist_id}","starred_url":"https://api.github.com/users/jnutzmann/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jnutzmann/subscriptions","organizations_url":"https://api.github.com/users/jnutzmann/orgs","repos_url":"https://api.github.com/users/jnutzmann/repos","events_url":"https://api.github.com/users/jnutzmann/events{/privacy}","received_events_url":"https://api.github.com/users/jnutzmann/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":0,"created_at":"2015-02-19T22:20:59Z","updated_at":"2015-02-19T22:20:59Z","closed_at":null,"body":"When running a query for the mean value with a `GROUP BY time(...)` specified, no data is returned when one of the time periods has no data present.  For example, this query fails to return data (HTTP 200 with no response payload):\r\n\r\n`SELECT mean(value) FROM my_data_series GROUP BY time(10h)`\r\n\r\nbecause there is a 10 hour gap in data, whereas this query succeeds (and returns the average for the 11 hour periods)\r\n\r\n`SELECT mean(value) FROM my_data_series GROUP BY time(11h)`\r\n\r\nPerhaps it should return `NaN` or simply no point for that time period?"}}