{"action":"opened","issue":{"url":"https://api.github.com/repos/cBioPortal/datahub/issues/218","repository_url":"https://api.github.com/repos/cBioPortal/datahub","labels_url":"https://api.github.com/repos/cBioPortal/datahub/issues/218/labels{/name}","comments_url":"https://api.github.com/repos/cBioPortal/datahub/issues/218/comments","events_url":"https://api.github.com/repos/cBioPortal/datahub/issues/218/events","html_url":"https://github.com/cBioPortal/datahub/issues/218","id":327005293,"number":218,"title":"Percentages converted to dates in nbl_target_2018","user":{"login":"sandertan","id":9624990,"avatar_url":"https://avatars2.githubusercontent.com/u/9624990?v=4","gravatar_id":"","url":"https://api.github.com/users/sandertan","html_url":"https://github.com/sandertan","followers_url":"https://api.github.com/users/sandertan/followers","following_url":"https://api.github.com/users/sandertan/following{/other_user}","gists_url":"https://api.github.com/users/sandertan/gists{/gist_id}","starred_url":"https://api.github.com/users/sandertan/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/sandertan/subscriptions","organizations_url":"https://api.github.com/users/sandertan/orgs","repos_url":"https://api.github.com/users/sandertan/repos","events_url":"https://api.github.com/users/sandertan/events{/privacy}","received_events_url":"https://api.github.com/users/sandertan/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":{"login":"yichaoS","id":5973438,"avatar_url":"https://avatars1.githubusercontent.com/u/5973438?v=4","gravatar_id":"","url":"https://api.github.com/users/yichaoS","html_url":"https://github.com/yichaoS","followers_url":"https://api.github.com/users/yichaoS/followers","following_url":"https://api.github.com/users/yichaoS/following{/other_user}","gists_url":"https://api.github.com/users/yichaoS/gists{/gist_id}","starred_url":"https://api.github.com/users/yichaoS/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/yichaoS/subscriptions","organizations_url":"https://api.github.com/users/yichaoS/orgs","repos_url":"https://api.github.com/users/yichaoS/repos","events_url":"https://api.github.com/users/yichaoS/events{/privacy}","received_events_url":"https://api.github.com/users/yichaoS/received_events","type":"User","site_admin":false},"assignees":[{"login":"yichaoS","id":5973438,"avatar_url":"https://avatars1.githubusercontent.com/u/5973438?v=4","gravatar_id":"","url":"https://api.github.com/users/yichaoS","html_url":"https://github.com/yichaoS","followers_url":"https://api.github.com/users/yichaoS/followers","following_url":"https://api.github.com/users/yichaoS/following{/other_user}","gists_url":"https://api.github.com/users/yichaoS/gists{/gist_id}","starred_url":"https://api.github.com/users/yichaoS/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/yichaoS/subscriptions","organizations_url":"https://api.github.com/users/yichaoS/orgs","repos_url":"https://api.github.com/users/yichaoS/repos","events_url":"https://api.github.com/users/yichaoS/events{/privacy}","received_events_url":"https://api.github.com/users/yichaoS/received_events","type":"User","site_admin":false},{"login":"ritikakundra","id":12007862,"avatar_url":"https://avatars1.githubusercontent.com/u/12007862?v=4","gravatar_id":"","url":"https://api.github.com/users/ritikakundra","html_url":"https://github.com/ritikakundra","followers_url":"https://api.github.com/users/ritikakundra/followers","following_url":"https://api.github.com/users/ritikakundra/following{/other_user}","gists_url":"https://api.github.com/users/ritikakundra/gists{/gist_id}","starred_url":"https://api.github.com/users/ritikakundra/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ritikakundra/subscriptions","organizations_url":"https://api.github.com/users/ritikakundra/orgs","repos_url":"https://api.github.com/users/ritikakundra/repos","events_url":"https://api.github.com/users/ritikakundra/events{/privacy}","received_events_url":"https://api.github.com/users/ritikakundra/received_events","type":"User","site_admin":false}],"milestone":null,"comments":0,"created_at":"2018-05-28T12:11:03Z","updated_at":"2018-05-28T12:11:03Z","closed_at":null,"author_association":"MEMBER","body":"A colleague of mine, @wardweistra, found out that some percentage ranges are converted to dates in the `nbl_target_2018` study. Perhaps this is auto-converted by Excel. Can this be fixed in cbioportal.org and DataHub? Please check the other columns as well; for this example, I only tested 2 attributes.\r\n\r\nhttp://www.cbioportal.org/study?id=nbl_target_2018_pub#summary\r\nhttps://github.com/cBioPortal/datahub/tree/rc/public/nbl_target_2018_pub\r\n\r\nAlso, for data that is a range, perhaps it would be better to take the average, to make it a `NUMBER` datatype in cBioPortal, so that numerical data visualizations are enabled in Study View and Plots tab.\r\n\r\n<img width=\"1291\" alt=\"screen shot 2018-05-28 at 13 45 41\" src=\"https://user-images.githubusercontent.com/9624990/40613318-61ed44ce-627e-11e8-8627-fa83bd12f919.png\">"}}
{"actor":{"display_login":"sandertan"}}