{"action":"created","issue":{"url":"https://api.github.com/repos/c4fcm/DataBasic/issues/88","labels_url":"https://api.github.com/repos/c4fcm/DataBasic/issues/88/labels{/name}","comments_url":"https://api.github.com/repos/c4fcm/DataBasic/issues/88/comments","events_url":"https://api.github.com/repos/c4fcm/DataBasic/issues/88/events","html_url":"https://github.com/c4fcm/DataBasic/issues/88","id":120413355,"number":88,"title":"WTFcsv: plot date cols as time series","user":{"login":"rahulbot","id":673178,"avatar_url":"https://avatars.githubusercontent.com/u/673178?v=3","gravatar_id":"","url":"https://api.github.com/users/rahulbot","html_url":"https://github.com/rahulbot","followers_url":"https://api.github.com/users/rahulbot/followers","following_url":"https://api.github.com/users/rahulbot/following{/other_user}","gists_url":"https://api.github.com/users/rahulbot/gists{/gist_id}","starred_url":"https://api.github.com/users/rahulbot/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/rahulbot/subscriptions","organizations_url":"https://api.github.com/users/rahulbot/orgs","repos_url":"https://api.github.com/users/rahulbot/repos","events_url":"https://api.github.com/users/rahulbot/events{/privacy}","received_events_url":"https://api.github.com/users/rahulbot/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/c4fcm/DataBasic/labels/bug","name":"bug","color":"fc2929"},{"url":"https://api.github.com/repos/c4fcm/DataBasic/labels/WTFcsv","name":"WTFcsv","color":"fbca04"}],"state":"open","locked":false,"assignee":{"login":"jayvachon","id":6832921,"avatar_url":"https://avatars.githubusercontent.com/u/6832921?v=3","gravatar_id":"","url":"https://api.github.com/users/jayvachon","html_url":"https://github.com/jayvachon","followers_url":"https://api.github.com/users/jayvachon/followers","following_url":"https://api.github.com/users/jayvachon/following{/other_user}","gists_url":"https://api.github.com/users/jayvachon/gists{/gist_id}","starred_url":"https://api.github.com/users/jayvachon/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jayvachon/subscriptions","organizations_url":"https://api.github.com/users/jayvachon/orgs","repos_url":"https://api.github.com/users/jayvachon/repos","events_url":"https://api.github.com/users/jayvachon/events{/privacy}","received_events_url":"https://api.github.com/users/jayvachon/received_events","type":"User","site_admin":false},"milestone":{"url":"https://api.github.com/repos/c4fcm/DataBasic/milestones/1","html_url":"https://github.com/c4fcm/DataBasic/milestones/v1.0","labels_url":"https://api.github.com/repos/c4fcm/DataBasic/milestones/1/labels","id":1392007,"number":1,"title":"v1.0","description":"Things we need done for our BETA workshop on 12/8","creator":{"login":"rahulbot","id":673178,"avatar_url":"https://avatars.githubusercontent.com/u/673178?v=3","gravatar_id":"","url":"https://api.github.com/users/rahulbot","html_url":"https://github.com/rahulbot","followers_url":"https://api.github.com/users/rahulbot/followers","following_url":"https://api.github.com/users/rahulbot/following{/other_user}","gists_url":"https://api.github.com/users/rahulbot/gists{/gist_id}","starred_url":"https://api.github.com/users/rahulbot/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/rahulbot/subscriptions","organizations_url":"https://api.github.com/users/rahulbot/orgs","repos_url":"https://api.github.com/users/rahulbot/repos","events_url":"https://api.github.com/users/rahulbot/events{/privacy}","received_events_url":"https://api.github.com/users/rahulbot/received_events","type":"User","site_admin":false},"open_issues":9,"closed_issues":29,"state":"open","created_at":"2015-11-03T19:09:02Z","updated_at":"2015-12-07T21:39:13Z","due_on":"2015-12-08T05:00:00Z","closed_at":null},"comments":2,"created_at":"2015-12-04T14:36:05Z","updated_at":"2015-12-07T21:42:16Z","closed_at":null,"body":"It looks like when we have identified a column as holding date information, we are still charting it like a text column.  I think we should be plotting it as a time series, bucketing like we do now for numeric columns.  My experience with highcharts suggests it will do the bucketing for us automatically.\r\n\r\nHere's an example from the UFO data that would benefit from this fix:\r\n![wtfcsv__ufo_sightings_in_massachusetts_csv](https://cloud.githubusercontent.com/assets/673178/11591990/e9b9a5b2-9a69-11e5-8aae-1d57d6c099d3.png)\r\n"},"comment":{"url":"https://api.github.com/repos/c4fcm/DataBasic/issues/comments/162673056","html_url":"https://github.com/c4fcm/DataBasic/issues/88#issuecomment-162673056","issue_url":"https://api.github.com/repos/c4fcm/DataBasic/issues/88","id":162673056,"user":{"login":"rahulbot","id":673178,"avatar_url":"https://avatars.githubusercontent.com/u/673178?v=3","gravatar_id":"","url":"https://api.github.com/users/rahulbot","html_url":"https://github.com/rahulbot","followers_url":"https://api.github.com/users/rahulbot/followers","following_url":"https://api.github.com/users/rahulbot/following{/other_user}","gists_url":"https://api.github.com/users/rahulbot/gists{/gist_id}","starred_url":"https://api.github.com/users/rahulbot/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/rahulbot/subscriptions","organizations_url":"https://api.github.com/users/rahulbot/orgs","repos_url":"https://api.github.com/users/rahulbot/repos","events_url":"https://api.github.com/users/rahulbot/events{/privacy}","received_events_url":"https://api.github.com/users/rahulbot/received_events","type":"User","site_admin":false},"created_at":"2015-12-07T21:42:16Z","updated_at":"2015-12-07T21:42:16Z","body":"Ok.  Reading (1) I bet its a stupid epoch seconds-since-1970 assumption. So you could do a hardcode that says if the date 2 chars and is < 70 then add in 19 as the century.\r\n(2) Doesn't high-charts have a way to wrap?\r\n(3) we can't do anything on the `duration` column... that text data and should be treated as such\r\nI can play with highcharts tomorrow morning to see if I can help.  Just push what you've got and I'll poke at it some."}}