{"action":"created","issue":{"url":"https://api.github.com/repos/elastic/kibana/issues/5265","labels_url":"https://api.github.com/repos/elastic/kibana/issues/5265/labels{/name}","comments_url":"https://api.github.com/repos/elastic/kibana/issues/5265/comments","events_url":"https://api.github.com/repos/elastic/kibana/issues/5265/events","html_url":"https://github.com/elastic/kibana/issues/5265","id":114583961,"number":5265,"title":"Computing average when using Data table issue","user":{"login":"bladypirat","id":2232599,"avatar_url":"https://avatars.githubusercontent.com/u/2232599?v=3","gravatar_id":"","url":"https://api.github.com/users/bladypirat","html_url":"https://github.com/bladypirat","followers_url":"https://api.github.com/users/bladypirat/followers","following_url":"https://api.github.com/users/bladypirat/following{/other_user}","gists_url":"https://api.github.com/users/bladypirat/gists{/gist_id}","starred_url":"https://api.github.com/users/bladypirat/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/bladypirat/subscriptions","organizations_url":"https://api.github.com/users/bladypirat/orgs","repos_url":"https://api.github.com/users/bladypirat/repos","events_url":"https://api.github.com/users/bladypirat/events{/privacy}","received_events_url":"https://api.github.com/users/bladypirat/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2015-11-02T12:24:36Z","updated_at":"2015-11-04T21:07:00Z","closed_at":null,"body":"Hi, \r\nI've noticed problem with counting average in Data table visualization. \r\nSeems like Kibana uses max value instead of computing average in Data table. Works fine, when extra filter is applied which results in only one row in data table.\r\nNoticed in Kibana 4.1.2 and 4.2.0\r\n\r\nData table configuration is as follows:\r\nMetrics is an average aggregation on numeric field (in my case response_time, which is float)\r\nBuckets: split rows: aggregation - terms on string field (in my case request_url, not analyzed), order by metric: average response time, order descending, size 10\r\n\r\n"},"comment":{"url":"https://api.github.com/repos/elastic/kibana/issues/comments/153865548","html_url":"https://github.com/elastic/kibana/issues/5265#issuecomment-153865548","issue_url":"https://api.github.com/repos/elastic/kibana/issues/5265","id":153865548,"user":{"login":"rashidkpc","id":1250387,"avatar_url":"https://avatars.githubusercontent.com/u/1250387?v=3","gravatar_id":"","url":"https://api.github.com/users/rashidkpc","html_url":"https://github.com/rashidkpc","followers_url":"https://api.github.com/users/rashidkpc/followers","following_url":"https://api.github.com/users/rashidkpc/following{/other_user}","gists_url":"https://api.github.com/users/rashidkpc/gists{/gist_id}","starred_url":"https://api.github.com/users/rashidkpc/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/rashidkpc/subscriptions","organizations_url":"https://api.github.com/users/rashidkpc/orgs","repos_url":"https://api.github.com/users/rashidkpc/repos","events_url":"https://api.github.com/users/rashidkpc/events{/privacy}","received_events_url":"https://api.github.com/users/rashidkpc/received_events","type":"User","site_admin":false},"created_at":"2015-11-04T21:07:00Z","updated_at":"2015-11-04T21:07:00Z","body":"This does not seem to occur for me, there definitely a difference in values between the max agg and the avg agg."}}