{"action":"created","issue":{"url":"https://api.github.com/repos/akvo/akvo-lumen/issues/412","repository_url":"https://api.github.com/repos/akvo/akvo-lumen","labels_url":"https://api.github.com/repos/akvo/akvo-lumen/issues/412/labels{/name}","comments_url":"https://api.github.com/repos/akvo/akvo-lumen/issues/412/comments","events_url":"https://api.github.com/repos/akvo/akvo-lumen/issues/412/events","html_url":"https://github.com/akvo/akvo-lumen/issues/412","id":184417677,"number":412,"title":"Implement first phase of derived column support","user":{"login":"mtwestra","id":478954,"avatar_url":"https://avatars.githubusercontent.com/u/478954?v=3","gravatar_id":"","url":"https://api.github.com/users/mtwestra","html_url":"https://github.com/mtwestra","followers_url":"https://api.github.com/users/mtwestra/followers","following_url":"https://api.github.com/users/mtwestra/following{/other_user}","gists_url":"https://api.github.com/users/mtwestra/gists{/gist_id}","starred_url":"https://api.github.com/users/mtwestra/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mtwestra/subscriptions","organizations_url":"https://api.github.com/users/mtwestra/orgs","repos_url":"https://api.github.com/users/mtwestra/repos","events_url":"https://api.github.com/users/mtwestra/events{/privacy}","received_events_url":"https://api.github.com/users/mtwestra/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":{"url":"https://api.github.com/repos/akvo/akvo-lumen/milestones/13","html_url":"https://github.com/akvo/akvo-lumen/milestones/1-12-2016","labels_url":"https://api.github.com/repos/akvo/akvo-lumen/milestones/13/labels","id":2084375,"number":13,"title":"1-12-2016","description":"","creator":{"login":"mtwestra","id":478954,"avatar_url":"https://avatars.githubusercontent.com/u/478954?v=3","gravatar_id":"","url":"https://api.github.com/users/mtwestra","html_url":"https://github.com/mtwestra","followers_url":"https://api.github.com/users/mtwestra/followers","following_url":"https://api.github.com/users/mtwestra/following{/other_user}","gists_url":"https://api.github.com/users/mtwestra/gists{/gist_id}","starred_url":"https://api.github.com/users/mtwestra/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mtwestra/subscriptions","organizations_url":"https://api.github.com/users/mtwestra/orgs","repos_url":"https://api.github.com/users/mtwestra/repos","events_url":"https://api.github.com/users/mtwestra/events{/privacy}","received_events_url":"https://api.github.com/users/mtwestra/received_events","type":"User","site_admin":false},"open_issues":6,"closed_issues":0,"state":"open","created_at":"2016-10-21T08:32:17Z","updated_at":"2016-11-14T09:49:00Z","due_on":"2016-12-01T00:00:00Z","closed_at":null},"comments":1,"created_at":"2016-10-21T07:31:52Z","updated_at":"2016-11-14T10:38:13Z","closed_at":null,"body":"To implement the derived column functionality, we will start with making the functionality available with minimum UI. The reason is that this will already unlock the functionality for demos and first implementations by Akvo staff, while we can work on a better UI experience for other users.\r\n\r\nThe first phase of the derived column support will therefore contain:\r\n#### UI\r\n- a transform where the following items can be specified:\r\n  - name of new column\r\n  - javascript of transform function\r\n- check validity of javascript\r\n#### Backend\r\n- The ability to:\r\n  - check validity of javascript\r\n  - create the new column\r\n  - compute the new values\r\n  - guard against timeouts\r\n\r\nQuestions:\r\n* how to refer to columns? Usually, the column names are very long. Should we give the user the ability to give a short name to a column to which she can refer? \r\n* how to give semantic correctness feedback\r\n* how to assist the user in formula building"},"comment":{"url":"https://api.github.com/repos/akvo/akvo-lumen/issues/comments/260302391","html_url":"https://github.com/akvo/akvo-lumen/issues/412#issuecomment-260302391","issue_url":"https://api.github.com/repos/akvo/akvo-lumen/issues/412","id":260302391,"user":{"login":"mtwestra","id":478954,"avatar_url":"https://avatars.githubusercontent.com/u/478954?v=3","gravatar_id":"","url":"https://api.github.com/users/mtwestra","html_url":"https://github.com/mtwestra","followers_url":"https://api.github.com/users/mtwestra/followers","following_url":"https://api.github.com/users/mtwestra/following{/other_user}","gists_url":"https://api.github.com/users/mtwestra/gists{/gist_id}","starred_url":"https://api.github.com/users/mtwestra/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mtwestra/subscriptions","organizations_url":"https://api.github.com/users/mtwestra/orgs","repos_url":"https://api.github.com/users/mtwestra/repos","events_url":"https://api.github.com/users/mtwestra/events{/privacy}","received_events_url":"https://api.github.com/users/mtwestra/received_events","type":"User","site_admin":false},"created_at":"2016-11-14T10:38:13Z","updated_at":"2016-11-14T10:38:13Z","body":"Some useful examples:\r\n* http://kb.tableau.com/articles/knowledgebase/understanding-logical-calculations\r\n* http://tableaubook.com/v9/workbooks/Formula%20Language%20Reference.PDF\r\n*  https://support.office.com/en-us/article/Use-the-Expression-Builder-56214db9-8b54-44f3-bc19-2a55427b5d4c\r\n\r\nInterestingly, both of these use the notation [NAME] to refer to columns"}}
{"actor":{"display_login":"mtwestra"}}