{"action":"closed","issue":{"url":"https://api.github.com/repos/metabase/metabase/issues/3688","repository_url":"https://api.github.com/repos/metabase/metabase","labels_url":"https://api.github.com/repos/metabase/metabase/issues/3688/labels{/name}","comments_url":"https://api.github.com/repos/metabase/metabase/issues/3688/comments","events_url":"https://api.github.com/repos/metabase/metabase/issues/3688/events","html_url":"https://github.com/metabase/metabase/issues/3688","id":185722094,"number":3688,"title":"When summing by month, the NULL group's sum is added to a random month","user":{"login":"underyx","id":1060436,"avatar_url":"https://avatars.githubusercontent.com/u/1060436?v=3","gravatar_id":"","url":"https://api.github.com/users/underyx","html_url":"https://github.com/underyx","followers_url":"https://api.github.com/users/underyx/followers","following_url":"https://api.github.com/users/underyx/following{/other_user}","gists_url":"https://api.github.com/users/underyx/gists{/gist_id}","starred_url":"https://api.github.com/users/underyx/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/underyx/subscriptions","organizations_url":"https://api.github.com/users/underyx/orgs","repos_url":"https://api.github.com/users/underyx/repos","events_url":"https://api.github.com/users/underyx/events{/privacy}","received_events_url":"https://api.github.com/users/underyx/received_events","type":"User","site_admin":false},"labels":[{"id":172924550,"url":"https://api.github.com/repos/metabase/metabase/labels/Bug","name":"Bug","color":"CC333F","default":false},{"id":276604400,"url":"https://api.github.com/repos/metabase/metabase/labels/Priority/P1","name":"Priority/P1","color":"e11d21","default":false}],"state":"closed","locked":false,"assignee":{"login":"tlrobinson","id":18193,"avatar_url":"https://avatars.githubusercontent.com/u/18193?v=3","gravatar_id":"","url":"https://api.github.com/users/tlrobinson","html_url":"https://github.com/tlrobinson","followers_url":"https://api.github.com/users/tlrobinson/followers","following_url":"https://api.github.com/users/tlrobinson/following{/other_user}","gists_url":"https://api.github.com/users/tlrobinson/gists{/gist_id}","starred_url":"https://api.github.com/users/tlrobinson/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/tlrobinson/subscriptions","organizations_url":"https://api.github.com/users/tlrobinson/orgs","repos_url":"https://api.github.com/users/tlrobinson/repos","events_url":"https://api.github.com/users/tlrobinson/events{/privacy}","received_events_url":"https://api.github.com/users/tlrobinson/received_events","type":"User","site_admin":false},"assignees":[{"login":"tlrobinson","id":18193,"avatar_url":"https://avatars.githubusercontent.com/u/18193?v=3","gravatar_id":"","url":"https://api.github.com/users/tlrobinson","html_url":"https://github.com/tlrobinson","followers_url":"https://api.github.com/users/tlrobinson/followers","following_url":"https://api.github.com/users/tlrobinson/following{/other_user}","gists_url":"https://api.github.com/users/tlrobinson/gists{/gist_id}","starred_url":"https://api.github.com/users/tlrobinson/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/tlrobinson/subscriptions","organizations_url":"https://api.github.com/users/tlrobinson/orgs","repos_url":"https://api.github.com/users/tlrobinson/repos","events_url":"https://api.github.com/users/tlrobinson/events{/privacy}","received_events_url":"https://api.github.com/users/tlrobinson/received_events","type":"User","site_admin":false}],"milestone":{"url":"https://api.github.com/repos/metabase/metabase/milestones/25","html_url":"https://github.com/metabase/metabase/milestones/0.21.0","labels_url":"https://api.github.com/repos/metabase/metabase/milestones/25/labels","id":2008124,"number":25,"title":"0.21.0","description":"Code complete: Nov 17th\r\nRelease date: Nov 19th","creator":{"login":"salsakran","id":107439,"avatar_url":"https://avatars.githubusercontent.com/u/107439?v=3","gravatar_id":"","url":"https://api.github.com/users/salsakran","html_url":"https://github.com/salsakran","followers_url":"https://api.github.com/users/salsakran/followers","following_url":"https://api.github.com/users/salsakran/following{/other_user}","gists_url":"https://api.github.com/users/salsakran/gists{/gist_id}","starred_url":"https://api.github.com/users/salsakran/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/salsakran/subscriptions","organizations_url":"https://api.github.com/users/salsakran/orgs","repos_url":"https://api.github.com/users/salsakran/repos","events_url":"https://api.github.com/users/salsakran/events{/privacy}","received_events_url":"https://api.github.com/users/salsakran/received_events","type":"User","site_admin":false},"open_issues":14,"closed_issues":53,"state":"open","created_at":"2016-09-15T23:59:31Z","updated_at":"2016-11-29T01:14:24Z","due_on":"2016-11-19T00:00:00Z","closed_at":null},"comments":4,"created_at":"2016-10-27T16:43:33Z","updated_at":"2016-11-29T01:14:24Z","closed_at":"2016-11-29T01:14:24Z","body":"### Bugs\n\nIf you're filing an issue about a bug please include as much information\nas you can including the following.\n- Chrome 53\n- macOS 10.12.1\n- Data is in PostgreSQL 9.6\n- Metabase 0.20.3\n- Hosted via Docker\n- Metabase internal database is PostgreSQL 9.5\n\nDon't have time to create a full repro, but my query is _Count of Rows by related table -> timestamp: month_ and the CSV export looks like this:\n\n``` csv\ntimestamp,count\n2014-03-01T00:00:00.000+01:00,0\n2014-04-01T00:00:00.000+02:00,1\n2014-05-01T00:00:00.000+02:00,3\n2014-06-01T00:00:00.000+02:00,7\n2014-07-01T00:00:00.000+02:00,10\n2014-08-01T00:00:00.000+02:00,9\n2014-09-01T00:00:00.000+02:00,10\n2014-10-01T00:00:00.000+02:00,12\n2014-11-01T00:00:00.000+01:00,17\n2014-12-01T00:00:00.000+01:00,17\n2015-01-01T00:00:00.000+01:00,27\n2015-02-01T00:00:00.000+01:00,28\n2015-03-01T00:00:00.000+01:00,50\n2015-04-01T00:00:00.000+02:00,57\n2015-05-01T00:00:00.000+02:00,74\n2015-06-01T00:00:00.000+02:00,89\n2015-07-01T00:00:00.000+02:00,91\n2015-08-01T00:00:00.000+02:00,129\n2015-09-01T00:00:00.000+02:00,157\n2015-10-01T00:00:00.000+02:00,189\n2015-11-01T00:00:00.000+01:00,150\n2015-12-01T00:00:00.000+01:00,164\n2016-01-01T00:00:00.000+01:00,265\n2016-02-01T00:00:00.000+01:00,266\n2016-03-01T00:00:00.000+01:00,294\n2016-04-01T00:00:00.000+02:00,296\n2016-05-01T00:00:00.000+02:00,332\n2016-06-01T00:00:00.000+02:00,429\n2016-07-01T00:00:00.000+02:00,417\n2016-08-01T00:00:00.000+02:00,465\n2016-09-01T00:00:00.000+02:00,461\n2016-10-01T00:00:00.000+02:00,399\n,358\n```\n\nAnd the line chart looks like this:\n![](https://i.underyx.me/2016-10-27T18-39-39.smb0b.png)\n\nThe 2015-11 peak says the value is 508 when hovering over it. The keen-eyed will notice that this is `2015-11 sum + NULL group sum` (`150 + 358`).\n\nInterestingly, the correct value is displayed in the pie chart and table modes.\n"}}
{"actor":{"display_login":"tlrobinson"}}