{"action":"created","issue":{"url":"https://api.github.com/repos/influxdb/influxdb/issues/5042","labels_url":"https://api.github.com/repos/influxdb/influxdb/issues/5042/labels{/name}","comments_url":"https://api.github.com/repos/influxdb/influxdb/issues/5042/comments","events_url":"https://api.github.com/repos/influxdb/influxdb/issues/5042/events","html_url":"https://github.com/influxdb/influxdb/issues/5042","id":121015270,"number":5042,"title":"fill(none) does not apply to count()","user":{"login":"hoomanv","id":5165024,"avatar_url":"https://avatars.githubusercontent.com/u/5165024?v=3","gravatar_id":"","url":"https://api.github.com/users/hoomanv","html_url":"https://github.com/hoomanv","followers_url":"https://api.github.com/users/hoomanv/followers","following_url":"https://api.github.com/users/hoomanv/following{/other_user}","gists_url":"https://api.github.com/users/hoomanv/gists{/gist_id}","starred_url":"https://api.github.com/users/hoomanv/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/hoomanv/subscriptions","organizations_url":"https://api.github.com/users/hoomanv/orgs","repos_url":"https://api.github.com/users/hoomanv/repos","events_url":"https://api.github.com/users/hoomanv/events{/privacy}","received_events_url":"https://api.github.com/users/hoomanv/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":10,"created_at":"2015-12-08T14:16:26Z","updated_at":"2015-12-09T19:10:59Z","closed_at":null,"body":"I have this query\r\n```\r\nselect count(value) from event where time > now() - 1d and time < now() group by time(1m) fill(none)\r\n```\r\nAnd the result has 1440 records even for those empty intervals\r\nIf I change the query to\r\n```\r\nselect count(value),max(value) from event where time > now() - 1d and time < now() group by time(1m) fill(none)\r\n```\r\nIt will leave empty intervals out\r\n\r\nSo basically count() alone is not taken into account by fill(none).\r\nBut I believe it should have."},"comment":{"url":"https://api.github.com/repos/influxdb/influxdb/issues/comments/163360577","html_url":"https://github.com/influxdb/influxdb/issues/5042#issuecomment-163360577","issue_url":"https://api.github.com/repos/influxdb/influxdb/issues/5042","id":163360577,"user":{"login":"pauldix","id":4331,"avatar_url":"https://avatars.githubusercontent.com/u/4331?v=3","gravatar_id":"","url":"https://api.github.com/users/pauldix","html_url":"https://github.com/pauldix","followers_url":"https://api.github.com/users/pauldix/followers","following_url":"https://api.github.com/users/pauldix/following{/other_user}","gists_url":"https://api.github.com/users/pauldix/gists{/gist_id}","starred_url":"https://api.github.com/users/pauldix/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/pauldix/subscriptions","organizations_url":"https://api.github.com/users/pauldix/orgs","repos_url":"https://api.github.com/users/pauldix/repos","events_url":"https://api.github.com/users/pauldix/events{/privacy}","received_events_url":"https://api.github.com/users/pauldix/received_events","type":"User","site_admin":false},"created_at":"2015-12-09T19:10:59Z","updated_at":"2015-12-09T19:10:59Z","body":"agree"}}