{"action":"created","issue":{"url":"https://api.github.com/repos/apache/incubator-superset/issues/4267","repository_url":"https://api.github.com/repos/apache/incubator-superset","labels_url":"https://api.github.com/repos/apache/incubator-superset/issues/4267/labels{/name}","comments_url":"https://api.github.com/repos/apache/incubator-superset/issues/4267/comments","events_url":"https://api.github.com/repos/apache/incubator-superset/issues/4267/events","html_url":"https://github.com/apache/incubator-superset/issues/4267","id":290770486,"node_id":"MDU6SXNzdWUyOTA3NzA0ODY=","number":4267,"title":"Weekly time grain: ticks and markers not aligned","user":{"login":"nbonnotte","id":9929982,"node_id":"MDQ6VXNlcjk5Mjk5ODI=","avatar_url":"https://avatars3.githubusercontent.com/u/9929982?v=4","gravatar_id":"","url":"https://api.github.com/users/nbonnotte","html_url":"https://github.com/nbonnotte","followers_url":"https://api.github.com/users/nbonnotte/followers","following_url":"https://api.github.com/users/nbonnotte/following{/other_user}","gists_url":"https://api.github.com/users/nbonnotte/gists{/gist_id}","starred_url":"https://api.github.com/users/nbonnotte/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/nbonnotte/subscriptions","organizations_url":"https://api.github.com/users/nbonnotte/orgs","repos_url":"https://api.github.com/users/nbonnotte/repos","events_url":"https://api.github.com/users/nbonnotte/events{/privacy}","received_events_url":"https://api.github.com/users/nbonnotte/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":2,"created_at":"2018-01-23T09:44:45Z","updated_at":"2018-08-07T04:26:17Z","closed_at":null,"author_association":"CONTRIBUTOR","body":"Make sure these boxes are checked before submitting your issue - thank you!\r\n\r\n- [x] I have checked the superset logs for python stacktraces and included it here as text if any\r\n- [x] I have reproduced the issue with at least the latest released version of superset\r\n- [x] I have checked the issue tracker for the same issue and I haven't found one similar\r\n\r\n### Superset version\r\n\r\n0.22.1\r\n\r\n### Expected results\r\n\r\nOn a line chart or percent-change chart, with a PostgreSQL backend and a weekly time grain, I would expect the x-axis ticks to match the markers, which are set on Mondays \r\n\r\n### Actual results\r\n\r\nMarkers are aligned on Mondays. Because that's what PostgreSQL sends, I guess, since `DATE_TRUNC` follows the ISO standard, and `DATE_TRUNC('week', '2018-01-23')` returns Monday 24.\r\n\r\nX-ticks are aligned on Sundays. This is wrong.\r\n\r\n### Steps to reproduce\r\n\r\nDo a line chart with a weekly time grain on a PostgreSQL backend\r\n"},"comment":{"url":"https://api.github.com/repos/apache/incubator-superset/issues/comments/410929305","html_url":"https://github.com/apache/incubator-superset/issues/4267#issuecomment-410929305","issue_url":"https://api.github.com/repos/apache/incubator-superset/issues/4267","id":410929305,"node_id":"MDEyOklzc3VlQ29tbWVudDQxMDkyOTMwNQ==","user":{"login":"StephTruong","id":8407082,"node_id":"MDQ6VXNlcjg0MDcwODI=","avatar_url":"https://avatars0.githubusercontent.com/u/8407082?v=4","gravatar_id":"","url":"https://api.github.com/users/StephTruong","html_url":"https://github.com/StephTruong","followers_url":"https://api.github.com/users/StephTruong/followers","following_url":"https://api.github.com/users/StephTruong/following{/other_user}","gists_url":"https://api.github.com/users/StephTruong/gists{/gist_id}","starred_url":"https://api.github.com/users/StephTruong/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/StephTruong/subscriptions","organizations_url":"https://api.github.com/users/StephTruong/orgs","repos_url":"https://api.github.com/users/StephTruong/repos","events_url":"https://api.github.com/users/StephTruong/events{/privacy}","received_events_url":"https://api.github.com/users/StephTruong/received_events","type":"User","site_admin":false},"created_at":"2018-08-07T04:26:17Z","updated_at":"2018-08-07T04:26:17Z","author_association":"NONE","body":"I have this issue but with a MySQL database. When I am selecting the time grain to be week_start_monday on a time series graph, the markers show Mondays but the xticks show Sundays."}}
{"actor":{"display_login":"StephTruong"}}