{"action":"created","issue":{"url":"https://api.github.com/repos/elastic/kibana/issues/3694","labels_url":"https://api.github.com/repos/elastic/kibana/issues/3694/labels{/name}","comments_url":"https://api.github.com/repos/elastic/kibana/issues/3694/comments","events_url":"https://api.github.com/repos/elastic/kibana/issues/3694/events","html_url":"https://github.com/elastic/kibana/issues/3694","id":71432864,"number":3694,"title":"Date histogram plots extra point on DST","user":{"login":"vikrim1","id":1069596,"avatar_url":"https://avatars.githubusercontent.com/u/1069596?v=3","gravatar_id":"","url":"https://api.github.com/users/vikrim1","html_url":"https://github.com/vikrim1","followers_url":"https://api.github.com/users/vikrim1/followers","following_url":"https://api.github.com/users/vikrim1/following{/other_user}","gists_url":"https://api.github.com/users/vikrim1/gists{/gist_id}","starred_url":"https://api.github.com/users/vikrim1/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/vikrim1/subscriptions","organizations_url":"https://api.github.com/users/vikrim1/orgs","repos_url":"https://api.github.com/users/vikrim1/repos","events_url":"https://api.github.com/users/vikrim1/events{/privacy}","received_events_url":"https://api.github.com/users/vikrim1/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/elastic/kibana/labels/needs%20details","name":"needs details","color":"cc317c"}],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":2,"created_at":"2015-04-27T23:50:24Z","updated_at":"2015-04-28T18:05:25Z","closed_at":null,"body":"Hi, I think I'm seeing a bug with the date histogram. In the gif below, the sharp drop on March 8 isn't represented in the data returned from the server (screenshot below gif). \r\n\r\n![kibana-areachartdatehistogrambug](https://cloud.githubusercontent.com/assets/1069596/7376582/9a0a8904-ed95-11e4-990b-9852904c4ee1.gif)\r\n\r\n![screen shot 2015-04-28 at 11 00 51 am](https://cloud.githubusercontent.com/assets/1069596/7376641/f0b66642-ed95-11e4-847e-00288c7593d1.png)\r\n\r\nRequest:\r\n```\r\n{\r\n  \"query\": {\r\n    \"filtered\": {\r\n      \"query\": {\r\n        \"query_string\": {\r\n          \"query\": \"*\",\r\n          \"analyze_wildcard\": true\r\n        }\r\n      },\r\n      \"filter\": {\r\n        \"bool\": {\r\n          \"must\": [\r\n            {\r\n              \"query\": {\r\n                \"query_string\": {\r\n                  \"query\": \"*\",\r\n                  \"analyze_wildcard\": true\r\n                }\r\n              }\r\n            },\r\n            {\r\n              \"range\": {\r\n                \"idxinquiry.performanceDateTime\": {\r\n                  \"gte\": 1398707699271,\r\n                  \"lte\": 1430243699271\r\n                }\r\n              }\r\n            }\r\n          ],\r\n          \"must_not\": []\r\n        }\r\n      }\r\n    }\r\n  },\r\n  \"size\": 0,\r\n  \"aggs\": {\r\n    \"2\": {\r\n      \"date_histogram\": {\r\n        \"field\": \"idxinquiry.eventDateTime\",\r\n        \"interval\": \"1w\",\r\n        \"pre_zone\": \"-07:00\",\r\n        \"pre_zone_adjust_large_interval\": true,\r\n        \"min_doc_count\": 1,\r\n        \"extended_bounds\": {\r\n          \"min\": 1398707699270,\r\n          \"max\": 1430243699270\r\n        }\r\n      }\r\n    }\r\n  }\r\n}\r\n```\r\n\r\nResponse:\r\n```\r\n{\r\n  \"took\": 9,\r\n  \"timed_out\": false,\r\n  \"_shards\": {\r\n    \"total\": 1,\r\n    \"successful\": 1,\r\n    \"failed\": 0\r\n  },\r\n  \"hits\": {\r\n    \"total\": 5,\r\n    \"max_score\": 0,\r\n    \"hits\": []\r\n  },\r\n  \"aggregations\": {\r\n    \"2\": {\r\n      \"buckets\": [\r\n        {\r\n          \"key_as_string\": \"2015-02-23T07:00:00.000Z\",\r\n          \"key\": 1424674800000,\r\n          \"doc_count\": 1\r\n        },\r\n        {\r\n          \"key_as_string\": \"2015-03-02T07:00:00.000Z\",\r\n          \"key\": 1425279600000,\r\n          \"doc_count\": 2\r\n        },\r\n        {\r\n          \"key_as_string\": \"2015-03-09T07:00:00.000Z\",\r\n          \"key\": 1425884400000,\r\n          \"doc_count\": 1\r\n        },\r\n        {\r\n          \"key_as_string\": \"2015-03-16T07:00:00.000Z\",\r\n          \"key\": 1426489200000,\r\n          \"doc_count\": 1\r\n        }\r\n      ]\r\n    }\r\n  }\r\n}\r\n```\r\n\r\nMy guess is that this is somehow related to Daylight Savings Time on March 8. Prior to March 8 the data returned from the server is anchored to 23:00. Starting March 9 (after DST), the data points start being anchored to 00:00. It seems like the visualization is looking for a March 8, 23:00 data point, doesn't find one, and plots it at a value of 0. \r\n\r\nThanks!"},"comment":{"url":"https://api.github.com/repos/elastic/kibana/issues/comments/97156761","html_url":"https://github.com/elastic/kibana/issues/3694#issuecomment-97156761","issue_url":"https://api.github.com/repos/elastic/kibana/issues/3694","id":97156761,"user":{"login":"vikrim1","id":1069596,"avatar_url":"https://avatars.githubusercontent.com/u/1069596?v=3","gravatar_id":"","url":"https://api.github.com/users/vikrim1","html_url":"https://github.com/vikrim1","followers_url":"https://api.github.com/users/vikrim1/followers","following_url":"https://api.github.com/users/vikrim1/following{/other_user}","gists_url":"https://api.github.com/users/vikrim1/gists{/gist_id}","starred_url":"https://api.github.com/users/vikrim1/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/vikrim1/subscriptions","organizations_url":"https://api.github.com/users/vikrim1/orgs","repos_url":"https://api.github.com/users/vikrim1/repos","events_url":"https://api.github.com/users/vikrim1/events{/privacy}","received_events_url":"https://api.github.com/users/vikrim1/received_events","type":"User","site_admin":false},"created_at":"2015-04-28T18:05:25Z","updated_at":"2015-04-28T18:05:25Z","body":"Hey Rashid, thanks for the reply. I updated the original description."}}