{"action":"closed","issue":{"url":"https://api.github.com/repos/metabase/metabase/issues/6998","repository_url":"https://api.github.com/repos/metabase/metabase","labels_url":"https://api.github.com/repos/metabase/metabase/issues/6998/labels{/name}","comments_url":"https://api.github.com/repos/metabase/metabase/issues/6998/comments","events_url":"https://api.github.com/repos/metabase/metabase/issues/6998/events","html_url":"https://github.com/metabase/metabase/issues/6998","id":299199692,"number":6998,"title":"Count by time missing values","user":{"login":"sedough","id":2296228,"avatar_url":"https://avatars0.githubusercontent.com/u/2296228?v=4","gravatar_id":"","url":"https://api.github.com/users/sedough","html_url":"https://github.com/sedough","followers_url":"https://api.github.com/users/sedough/followers","following_url":"https://api.github.com/users/sedough/following{/other_user}","gists_url":"https://api.github.com/users/sedough/gists{/gist_id}","starred_url":"https://api.github.com/users/sedough/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/sedough/subscriptions","organizations_url":"https://api.github.com/users/sedough/orgs","repos_url":"https://api.github.com/users/sedough/repos","events_url":"https://api.github.com/users/sedough/events{/privacy}","received_events_url":"https://api.github.com/users/sedough/received_events","type":"User","site_admin":false},"labels":[{"id":234606524,"url":"https://api.github.com/repos/metabase/metabase/labels/Proposal","name":"Proposal","color":"D7EDC2","default":false},{"id":314238818,"url":"https://api.github.com/repos/metabase/metabase/labels/Query%20Builder","name":"Query Builder","color":"0DD5FC","default":false}],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2018-02-22T02:20:28Z","updated_at":"2018-04-11T16:31:28Z","closed_at":"2018-04-11T16:31:28Z","author_association":"NONE","body":"When counting rows grouped by time, time intervals with no records are missing rather than having a count of \"0\".    When plotting the results in a line chart, the \"Replace missing values with\" option has no effect -- there's no way to see intervals with no data.\r\n\r\nI understand why this is happening from a SQL perspective, and I have a workaround by writing a raw query.   However, this behavior isn't intuitive to less-technical users.\r\n\r\nMetabase version v0.28\r\nGoogle Chrome 64.0.3282.167 running on Mac\r\nPostgresql 10 database\r\nHosted on Linux/Docker using H2 database"}}
{"actor":{"display_login":"tlrobinson"}}