{"action":"opened","issue":{"url":"https://api.github.com/repos/metabase/metabase/issues/4010","repository_url":"https://api.github.com/repos/metabase/metabase","labels_url":"https://api.github.com/repos/metabase/metabase/issues/4010/labels{/name}","comments_url":"https://api.github.com/repos/metabase/metabase/issues/4010/comments","events_url":"https://api.github.com/repos/metabase/metabase/issues/4010/events","html_url":"https://github.com/metabase/metabase/issues/4010","id":198028890,"number":4010,"title":"Bar chart : breakout on a NULLable field","user":{"login":"hugocar","id":19691106,"avatar_url":"https://avatars.githubusercontent.com/u/19691106?v=3","gravatar_id":"","url":"https://api.github.com/users/hugocar","html_url":"https://github.com/hugocar","followers_url":"https://api.github.com/users/hugocar/followers","following_url":"https://api.github.com/users/hugocar/following{/other_user}","gists_url":"https://api.github.com/users/hugocar/gists{/gist_id}","starred_url":"https://api.github.com/users/hugocar/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/hugocar/subscriptions","organizations_url":"https://api.github.com/users/hugocar/orgs","repos_url":"https://api.github.com/users/hugocar/repos","events_url":"https://api.github.com/users/hugocar/events{/privacy}","received_events_url":"https://api.github.com/users/hugocar/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2016-12-29T16:01:44Z","updated_at":"2016-12-29T16:01:44Z","closed_at":null,"body":"Possible bug : \r\nWhen using a breakout column on Bar Chart, there are surprising behaviors with the value NULL. \r\n\r\n### Usual behavior\r\n<img width=\"1234\" alt=\"capture d ecran 2016-12-29 a 4 20 03 pm\" src=\"https://cloud.githubusercontent.com/assets/19691106/21546937/0f4de614-cde3-11e6-84de-5be4f52a0dd5.png\">\r\n\r\n### Behavior with NULL being the first breakout value\r\n<img width=\"1237\" alt=\"capture d ecran 2016-12-29 a 4 20 31 pm\" src=\"https://cloud.githubusercontent.com/assets/19691106/21546963/3e6ea0c8-cde3-11e6-98a8-84116c5eac60.png\">\r\n\r\nA warning caption is visible : \r\n<img width=\"1249\" alt=\"capture d ecran 2016-12-29 a 4 20 40 pm\" src=\"https://cloud.githubusercontent.com/assets/19691106/21546948/20625cfa-cde3-11e6-8da8-589d53f48e5e.png\">\r\n\r\n### Behavior with NULL being one of the breakout values but not the first\r\n<img width=\"1242\" alt=\"capture d ecran 2016-12-29 a 4 30 59 pm\" src=\"https://cloud.githubusercontent.com/assets/19691106/21547472/8d6d50f4-cde6-11e6-91aa-1fb440e1046c.png\">\r\n\r\nThis shows that the chart depend on lines order in the data set\r\n<img width=\"1233\" alt=\"capture d ecran 2016-12-29 a 4 41 57 pm\" src=\"https://cloud.githubusercontent.com/assets/19691106/21547349/c4fef2a8-cde5-11e6-9409-3927f4f8d6ef.png\">\r\n\r\n\r\n\r\n\r\n\r\n### Expected behavior ?\r\nShouldn't the NULL value be treated as any other ?\r\n<img width=\"1239\" alt=\"capture d ecran 2016-12-29 a 4 51 41 pm\" src=\"https://cloud.githubusercontent.com/assets/19691106/21547610/79ceff88-cde7-11e6-880a-06220844ad8d.png\">\r\n\r\n\r\n\r\n> ### Steps to reproduce : \r\n> \r\n> Breakout out a series on a nullable field or use : \r\n> \r\n> ```\r\n> SELECT \"x\" as x_axis,\"breakout0\" as \"breakout\", 1 as value\r\n> UNION\r\n> SELECT \"x\" as x_axis,NULL as \"breakout\", 1 as value\r\n> UNION \r\n> SELECT \"x\" as x_axis,\"breakout2\" as \"breakout\", 1 as value\r\n> UNION \r\n> SELECT \"y\" as x_axis,\"breakout1\" as \"breakout\", 2 as value\r\n> UNION \r\n> SELECT \"y\" as x_axis,\"breakout2\" as \"breakout\", 2 as value\r\n> ```\r\n\r\n> ### Bugs\r\n> If you're filing an issue about a bug please include as much information\r\n> as you can including the following.\r\n> - Database : MySQL\r\n> - Metabase version: 0.21.1\r\n> - Metabase hosting environment: Linux\r\n> - Metabase internal database: MySQL\r\n>"}}
{"actor":{"display_login":"hugocar"}}