{"action":"created","issue":{"url":"https://api.github.com/repos/ankane/groupdate/issues/61","repository_url":"https://api.github.com/repos/ankane/groupdate","labels_url":"https://api.github.com/repos/ankane/groupdate/issues/61/labels{/name}","comments_url":"https://api.github.com/repos/ankane/groupdate/issues/61/comments","events_url":"https://api.github.com/repos/ankane/groupdate/issues/61/events","html_url":"https://github.com/ankane/groupdate/issues/61","id":42415706,"number":61,"title":"Select multiple aggregate results?","user":{"login":"thedarkside","id":2773925,"avatar_url":"https://avatars.githubusercontent.com/u/2773925?v=3","gravatar_id":"","url":"https://api.github.com/users/thedarkside","html_url":"https://github.com/thedarkside","followers_url":"https://api.github.com/users/thedarkside/followers","following_url":"https://api.github.com/users/thedarkside/following{/other_user}","gists_url":"https://api.github.com/users/thedarkside/gists{/gist_id}","starred_url":"https://api.github.com/users/thedarkside/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/thedarkside/subscriptions","organizations_url":"https://api.github.com/users/thedarkside/orgs","repos_url":"https://api.github.com/users/thedarkside/repos","events_url":"https://api.github.com/users/thedarkside/events{/privacy}","received_events_url":"https://api.github.com/users/thedarkside/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":2,"created_at":"2014-09-10T14:01:43Z","updated_at":"2016-02-13T02:28:11Z","closed_at":null,"body":"Hi,\r\n\r\nis it possible to get results like this:\r\n```ruby\r\n{ Mon, 01 Dec 2008 00:00:00 UTC +00:00=>[6,1],\r\n Thu, 01 Jan 2009 00:00:00 UTC +00:00=>[5,22],\r\n Mon, 01 Dec 2008 00:00:00 UTC +00:00=>[2,8],\r\n Thu, 01 Jan 2009 00:00:00 UTC +00:00=>[9,12]\r\n}\r\n```\r\nIgnore the date grouping, it could be by day or month or anything else.\r\n\r\nI want to select the `count` **and** the `sum` of a colum in just one query (see array result values). \r\n\r\nHow can i accomplish this?\r\n\r\nBest regards,\r\nThedarkside"},"comment":{"url":"https://api.github.com/repos/ankane/groupdate/issues/comments/183565894","html_url":"https://github.com/ankane/groupdate/issues/61#issuecomment-183565894","issue_url":"https://api.github.com/repos/ankane/groupdate/issues/61","id":183565894,"user":{"login":"codesnik","id":4512,"avatar_url":"https://avatars.githubusercontent.com/u/4512?v=3","gravatar_id":"","url":"https://api.github.com/users/codesnik","html_url":"https://github.com/codesnik","followers_url":"https://api.github.com/users/codesnik/followers","following_url":"https://api.github.com/users/codesnik/following{/other_user}","gists_url":"https://api.github.com/users/codesnik/gists{/gist_id}","starred_url":"https://api.github.com/users/codesnik/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/codesnik/subscriptions","organizations_url":"https://api.github.com/users/codesnik/orgs","repos_url":"https://api.github.com/users/codesnik/repos","events_url":"https://api.github.com/users/codesnik/events{/privacy}","received_events_url":"https://api.github.com/users/codesnik/received_events","type":"User","site_admin":false},"created_at":"2016-02-13T02:28:11Z","updated_at":"2016-02-13T02:28:11Z","body":"@thedarkside I've made a gem (https://github.com/codesnik/calculate-all) to calculate count and sum and all the other aggregate functions in one pass.  \r\nIt won't work with groupdate right now, but this is my nearest objective.\r\n"}}