{"action":"created","issue":{"url":"https://api.github.com/repos/google/google-visualization-api-issues/issues/385","labels_url":"https://api.github.com/repos/google/google-visualization-api-issues/issues/385/labels{/name}","comments_url":"https://api.github.com/repos/google/google-visualization-api-issues/issues/385/comments","events_url":"https://api.github.com/repos/google/google-visualization-api-issues/issues/385/events","html_url":"https://github.com/google/google-visualization-api-issues/issues/385","id":74510304,"number":385,"title":"Piechart cannot show formatted numeric label / query language cannot convert number to string","user":{"login":"orwant","id":9052763,"avatar_url":"https://avatars.githubusercontent.com/u/9052763?v=3","gravatar_id":"","url":"https://api.github.com/users/orwant","html_url":"https://github.com/orwant","followers_url":"https://api.github.com/users/orwant/followers","following_url":"https://api.github.com/users/orwant/following{/other_user}","gists_url":"https://api.github.com/users/orwant/gists{/gist_id}","starred_url":"https://api.github.com/users/orwant/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/orwant/subscriptions","organizations_url":"https://api.github.com/users/orwant/orgs","repos_url":"https://api.github.com/users/orwant/repos","events_url":"https://api.github.com/users/orwant/events{/privacy}","received_events_url":"https://api.github.com/users/orwant/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/google/google-visualization-api-issues/labels/Priority-Medium","name":"Priority-Medium","color":"ededed"},{"url":"https://api.github.com/repos/google/google-visualization-api-issues/labels/Type-Defect","name":"Type-Defect","color":"ededed"}],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2015-05-08T22:05:31Z","updated_at":"2015-05-08T22:05:33Z","closed_at":null,"body":"Original [issue 388](https://code.google.com/p/google-visualization-api-issues/issues/detail?id=388) created by orwant on 2010-08-20T17:10:04.000Z:\n\n(this seems to me to be a bug, however it could be a feature request...)\r\n\r\nI'm creating a pie chart showing items by their size. Size is a numeric field. Using the query API I cannot convert size into a String and as a result PieChart produces an empty legend. I have also tried specifying a FORMAT size as 'x' (and also using no_values) to see if it will allow 'x123' as a label but it will not.\r\n\r\nAs I see it the fix is either:\r\n1. PieChart should accept a numeric value as a label (I don't see the rationale for not permitting this, especially if the number is formatted); or\r\n2. the query language should permit getting a string representation of a datatype\r\n\r\n\r\n<b>What component is this issue related to (PieChart, LineChart, DataTable,</b>\n<b>Query, etc)?</b>\nQuery language / PieChart\r\n\r\n\r\n<b>Are you using the test environment (version 1.1)?</b>\n<b>(If you are not sure, answer NO)</b>\nno\r\n\r\n<b>What operating system and browser are you using?</b>\nChrome 6, Linux\r\n\r\n\r\n<b>*********************************************************</b>\n<b>For developers viewing this issue: please click the 'star' icon to be</b>\n<b>notified of future changes, and to let us know how many of you are</b>\n<b>interested in seeing it resolved.</b>\n<b>*********************************************************</b>\n"},"comment":{"url":"https://api.github.com/repos/google/google-visualization-api-issues/issues/comments/100379966","html_url":"https://github.com/google/google-visualization-api-issues/issues/385#issuecomment-100379966","issue_url":"https://api.github.com/repos/google/google-visualization-api-issues/issues/385","id":100379966,"user":{"login":"orwant","id":9052763,"avatar_url":"https://avatars.githubusercontent.com/u/9052763?v=3","gravatar_id":"","url":"https://api.github.com/users/orwant","html_url":"https://github.com/orwant","followers_url":"https://api.github.com/users/orwant/followers","following_url":"https://api.github.com/users/orwant/following{/other_user}","gists_url":"https://api.github.com/users/orwant/gists{/gist_id}","starred_url":"https://api.github.com/users/orwant/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/orwant/subscriptions","organizations_url":"https://api.github.com/users/orwant/orgs","repos_url":"https://api.github.com/users/orwant/repos","events_url":"https://api.github.com/users/orwant/events{/privacy}","received_events_url":"https://api.github.com/users/orwant/received_events","type":"User","site_admin":false},"created_at":"2015-05-08T22:05:33Z","updated_at":"2015-05-08T22:05:33Z","body":"Comment [#1](https://code.google.com/p/google-visualization-api-issues/issues/detail?id=388#c1) originally posted by orwant on 2010-08-22T07:48:53.000Z:\n\nYou can change a numeric column into a string column with a calculated column in a DataView:\r\n\r\nhttp://code.google.com/apis/visualization/documentation/reference.html#DataView"}}