{"action":"created","issue":{"url":"https://api.github.com/repos/airbnb/caravel/issues/821","repository_url":"https://api.github.com/repos/airbnb/caravel","labels_url":"https://api.github.com/repos/airbnb/caravel/issues/821/labels{/name}","comments_url":"https://api.github.com/repos/airbnb/caravel/issues/821/comments","events_url":"https://api.github.com/repos/airbnb/caravel/issues/821/events","html_url":"https://github.com/airbnb/caravel/issues/821","id":167560055,"number":821,"title":"Why table view without group by cannot be used in dashboard?","user":{"login":"Thomasmisfit","id":8220811,"avatar_url":"https://avatars.githubusercontent.com/u/8220811?v=3","gravatar_id":"","url":"https://api.github.com/users/Thomasmisfit","html_url":"https://github.com/Thomasmisfit","followers_url":"https://api.github.com/users/Thomasmisfit/followers","following_url":"https://api.github.com/users/Thomasmisfit/following{/other_user}","gists_url":"https://api.github.com/users/Thomasmisfit/gists{/gist_id}","starred_url":"https://api.github.com/users/Thomasmisfit/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Thomasmisfit/subscriptions","organizations_url":"https://api.github.com/users/Thomasmisfit/orgs","repos_url":"https://api.github.com/users/Thomasmisfit/repos","events_url":"https://api.github.com/users/Thomasmisfit/events{/privacy}","received_events_url":"https://api.github.com/users/Thomasmisfit/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":7,"created_at":"2016-07-26T09:20:48Z","updated_at":"2016-10-30T01:03:11Z","closed_at":"2016-07-28T18:52:00Z","body":"Hi guys,\r\n\r\nI met an issue, I want to use Table View to show the table column, I succeed to create slice like this:\r\n![image](https://cloud.githubusercontent.com/assets/8220811/17132618/1d7d8d6a-5355-11e6-8fc4-3f47fc98d675.png)\r\n\r\n But when I use it into the dashboard, I get this error:\r\n![image](https://cloud.githubusercontent.com/assets/8220811/17132573/f318af00-5354-11e6-8605-6b744c63b33a.png)\r\n\r\nI found this error will happened no matter what table I use. Is it a bug?\r\n\r\nPS: I just followed the doc to install the caravel : http://airbnb.io/caravel/installation.html#caravel-installation-and-initialization"},"comment":{"url":"https://api.github.com/repos/airbnb/caravel/issues/comments/257125317","html_url":"https://github.com/airbnb/caravel/issues/821#issuecomment-257125317","issue_url":"https://api.github.com/repos/airbnb/caravel/issues/821","id":257125317,"user":{"login":"spspaul","id":5750851,"avatar_url":"https://avatars.githubusercontent.com/u/5750851?v=3","gravatar_id":"","url":"https://api.github.com/users/spspaul","html_url":"https://github.com/spspaul","followers_url":"https://api.github.com/users/spspaul/followers","following_url":"https://api.github.com/users/spspaul/following{/other_user}","gists_url":"https://api.github.com/users/spspaul/gists{/gist_id}","starred_url":"https://api.github.com/users/spspaul/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/spspaul/subscriptions","organizations_url":"https://api.github.com/users/spspaul/orgs","repos_url":"https://api.github.com/users/spspaul/repos","events_url":"https://api.github.com/users/spspaul/events{/privacy}","received_events_url":"https://api.github.com/users/spspaul/received_events","type":"User","site_admin":false},"created_at":"2016-10-30T01:03:11Z","updated_at":"2016-10-30T01:03:11Z","body":"@kylozw ,\r\n\r\nFWIW, ```Ordering``` does not take all columns, just ones of certain types.\r\nWhat I do in order to:\r\n* satisfy Caravel's need to have at least one value for ```Ordering```\r\n* get things sorted the way I want when using ```NOT GROUPED BY```\r\n\r\nI define a view in the database where the first column is defined like so:\r\n```\r\nCREATE OR REPLACE VIEW blar AS\r\nSELECT RANK() OVER (ORDER BY col1, col2, etc) AS order_id,\r\n```\r\nI use then use ```blar``` as Source/Table.\r\nIn Caravel/Slice definition, I specify ```order_id``` for ```Ordering```.\r\n\r\nGood luck."}}
{"actor":{"display_login":"spspaul"}}