{"action":"created","issue":{"url":"https://api.github.com/repos/thegooddata/webapp/issues/124","labels_url":"https://api.github.com/repos/thegooddata/webapp/issues/124/labels{/name}","comments_url":"https://api.github.com/repos/thegooddata/webapp/issues/124/comments","events_url":"https://api.github.com/repos/thegooddata/webapp/issues/124/events","html_url":"https://github.com/thegooddata/webapp/issues/124","id":58072185,"number":124,"title":"Calculation of daily totals to optimize requests","user":{"login":"marcosmenendez","id":1178350,"avatar_url":"https://avatars.githubusercontent.com/u/1178350?v=3","gravatar_id":"","url":"https://api.github.com/users/marcosmenendez","html_url":"https://github.com/marcosmenendez","followers_url":"https://api.github.com/users/marcosmenendez/followers","following_url":"https://api.github.com/users/marcosmenendez/following{/other_user}","gists_url":"https://api.github.com/users/marcosmenendez/gists{/gist_id}","starred_url":"https://api.github.com/users/marcosmenendez/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/marcosmenendez/subscriptions","organizations_url":"https://api.github.com/users/marcosmenendez/orgs","repos_url":"https://api.github.com/users/marcosmenendez/repos","events_url":"https://api.github.com/users/marcosmenendez/events{/privacy}","received_events_url":"https://api.github.com/users/marcosmenendez/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/thegooddata/webapp/labels/prio:normal","name":"prio:normal","color":"eb6420"},{"url":"https://api.github.com/repos/thegooddata/webapp/labels/status:ready%20to%20deploy","name":"status:ready to deploy","color":"ffffff"},{"url":"https://api.github.com/repos/thegooddata/webapp/labels/type:optimization","name":"type:optimization","color":"207de5"}],"state":"closed","locked":false,"assignee":{"login":"atrandafir","id":3097251,"avatar_url":"https://avatars.githubusercontent.com/u/3097251?v=3","gravatar_id":"","url":"https://api.github.com/users/atrandafir","html_url":"https://github.com/atrandafir","followers_url":"https://api.github.com/users/atrandafir/followers","following_url":"https://api.github.com/users/atrandafir/following{/other_user}","gists_url":"https://api.github.com/users/atrandafir/gists{/gist_id}","starred_url":"https://api.github.com/users/atrandafir/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/atrandafir/subscriptions","organizations_url":"https://api.github.com/users/atrandafir/orgs","repos_url":"https://api.github.com/users/atrandafir/repos","events_url":"https://api.github.com/users/atrandafir/events{/privacy}","received_events_url":"https://api.github.com/users/atrandafir/received_events","type":"User","site_admin":false},"milestone":{"url":"https://api.github.com/repos/thegooddata/webapp/milestones/16","html_url":"https://github.com/thegooddata/webapp/milestones/Release%20%2315","labels_url":"https://api.github.com/repos/thegooddata/webapp/milestones/16/labels","id":984560,"number":16,"title":"Release #15","description":"","creator":{"login":"marcosmenendez","id":1178350,"avatar_url":"https://avatars.githubusercontent.com/u/1178350?v=3","gravatar_id":"","url":"https://api.github.com/users/marcosmenendez","html_url":"https://github.com/marcosmenendez","followers_url":"https://api.github.com/users/marcosmenendez/followers","following_url":"https://api.github.com/users/marcosmenendez/following{/other_user}","gists_url":"https://api.github.com/users/marcosmenendez/gists{/gist_id}","starred_url":"https://api.github.com/users/marcosmenendez/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/marcosmenendez/subscriptions","organizations_url":"https://api.github.com/users/marcosmenendez/orgs","repos_url":"https://api.github.com/users/marcosmenendez/repos","events_url":"https://api.github.com/users/marcosmenendez/events{/privacy}","received_events_url":"https://api.github.com/users/marcosmenendez/received_events","type":"User","site_admin":false},"open_issues":4,"closed_issues":5,"state":"open","created_at":"2015-02-18T14:05:04Z","updated_at":"2015-04-05T23:28:38Z","due_on":"2015-03-01T23:00:00Z","closed_at":null},"comments":6,"created_at":"2015-02-18T14:11:57Z","updated_at":"2015-04-05T23:28:38Z","closed_at":"2015-04-05T23:28:38Z","body":"Evil data, good data and your data require to access plenty of dynamic data. Even if it is indexed or cached, it is not scalable.\r\n\r\nAn extra action would be to calculate and store daily subtotals of the different metrics, so whenever a user request a page, only the new data has to be counted and summed up to the previously calculated subtotals. These subtotals will need to be stored for the last 30 days in case of metrics that are shown for that period. There are other metrics that show a full year evolution. In that case we may need to keep the last 365 days of a user.\r\n\r\nOlder daily subtotals can be deleted.\r\n\r\nPlease discuss with @atrandafir before developing it"},"comment":{"url":"https://api.github.com/repos/thegooddata/webapp/issues/comments/89869008","html_url":"https://github.com/thegooddata/webapp/issues/124#issuecomment-89869008","issue_url":"https://api.github.com/repos/thegooddata/webapp/issues/124","id":89869008,"user":{"login":"atrandafir","id":3097251,"avatar_url":"https://avatars.githubusercontent.com/u/3097251?v=3","gravatar_id":"","url":"https://api.github.com/users/atrandafir","html_url":"https://github.com/atrandafir","followers_url":"https://api.github.com/users/atrandafir/followers","following_url":"https://api.github.com/users/atrandafir/following{/other_user}","gists_url":"https://api.github.com/users/atrandafir/gists{/gist_id}","starred_url":"https://api.github.com/users/atrandafir/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/atrandafir/subscriptions","organizations_url":"https://api.github.com/users/atrandafir/orgs","repos_url":"https://api.github.com/users/atrandafir/repos","events_url":"https://api.github.com/users/atrandafir/events{/privacy}","received_events_url":"https://api.github.com/users/atrandafir/received_events","type":"User","site_admin":false},"created_at":"2015-04-05T23:28:38Z","updated_at":"2015-04-05T23:28:38Z","body":"@bodiapz Nevermind point 3 for now, I'm testing in Production and looks like data shows correctly for risk ratios. I've removed the rejected status since this has been deployed to production too and for further improvements on this page we've got a new issue:  \r\nhttps://github.com/thegooddata/webapp/issues/148"}}