{"action":"created","issue":{"url":"https://api.github.com/repos/wireservice/agate/issues/555","repository_url":"https://api.github.com/repos/wireservice/agate","labels_url":"https://api.github.com/repos/wireservice/agate/issues/555/labels{/name}","comments_url":"https://api.github.com/repos/wireservice/agate/issues/555/comments","events_url":"https://api.github.com/repos/wireservice/agate/issues/555/events","html_url":"https://github.com/wireservice/agate/issues/555","id":138592953,"number":555,"title":"Would column headers generated by the pivot be better and more descriptive if they included the computation type?","user":{"login":"palewire","id":9993,"avatar_url":"https://avatars.githubusercontent.com/u/9993?v=3","gravatar_id":"","url":"https://api.github.com/users/palewire","html_url":"https://github.com/palewire","followers_url":"https://api.github.com/users/palewire/followers","following_url":"https://api.github.com/users/palewire/following{/other_user}","gists_url":"https://api.github.com/users/palewire/gists{/gist_id}","starred_url":"https://api.github.com/users/palewire/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/palewire/subscriptions","organizations_url":"https://api.github.com/users/palewire/orgs","repos_url":"https://api.github.com/users/palewire/repos","events_url":"https://api.github.com/users/palewire/events{/privacy}","received_events_url":"https://api.github.com/users/palewire/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":7,"created_at":"2016-03-04T21:36:20Z","updated_at":"2016-03-04T22:00:43Z","closed_at":"2016-03-04T22:00:43Z","body":"Here is the example output now, which doesn't specifically tell you want it did\r\n\r\n```\r\n+---------+--------+--------+\r\n| race    | male   | female |\r\n+=========+========+========+\r\n| white   | 0      | 1      |\r\n+---------+--------+--------+\r\n| asian   | 1      | 1      |\r\n+---------+--------+--------+\r\n| black   | 0      | 2      |\r\n+---------+--------+--------+\r\n| latino  | 1      | 0      |\r\n+---------+--------+--------+\r\n```\r\n\r\nMaybe it could nicer if it did something like this instead?\r\n\r\n```\r\n+---------+--------------+--------------+\r\n| race    | male_count   | female_count |\r\n+=========+==============+==============+\r\n| white   | 0            | 1            |\r\n+---------+--------------+--------------+\r\n| asian   | 1            | 1            |\r\n+---------+--------------+--------------+\r\n| black   | 0            | 2            |\r\n+---------+--------------+--------------+\r\n| latino  | 1            | 0            |\r\n+---------+--------------+--------------+\r\n```\r\n"},"comment":{"url":"https://api.github.com/repos/wireservice/agate/issues/comments/192488104","html_url":"https://github.com/wireservice/agate/issues/555#issuecomment-192488104","issue_url":"https://api.github.com/repos/wireservice/agate/issues/555","id":192488104,"user":{"login":"onyxfish","id":33046,"avatar_url":"https://avatars.githubusercontent.com/u/33046?v=3","gravatar_id":"","url":"https://api.github.com/users/onyxfish","html_url":"https://github.com/onyxfish","followers_url":"https://api.github.com/users/onyxfish/followers","following_url":"https://api.github.com/users/onyxfish/following{/other_user}","gists_url":"https://api.github.com/users/onyxfish/gists{/gist_id}","starred_url":"https://api.github.com/users/onyxfish/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/onyxfish/subscriptions","organizations_url":"https://api.github.com/users/onyxfish/orgs","repos_url":"https://api.github.com/users/onyxfish/repos","events_url":"https://api.github.com/users/onyxfish/events{/privacy}","received_events_url":"https://api.github.com/users/onyxfish/received_events","type":"User","site_admin":false},"created_at":"2016-03-04T22:00:43Z","updated_at":"2016-03-04T22:00:43Z","body":"An earlier version of agate had a provenance feature that connected every derived table/column to its parents. That got cut largely because every table needed to hold a reference to previous versions, which meant memory never got released for intermediate tables, which simply destroyed performance.\r\n\r\nI can imagine some way of serializing the process of what created a column, but honestly, I'd have to see a very compelling use case to consider adding all that instrumentation purely for display purposes."}}