# Interval timestamp visualization vertical histogram **URL:** \ **Category:** Kibana\ **Created:** [July 19, 2019, 1:44pm UTC](https://discuss.elastic.co/t/interval-timestamp-visualization-vertical-histogram/191404 "2019-07-19T13:44:30Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![theo1991](https://avatars.discourse-cdn.com/v4/letter/t/4da419/32.png) [@theo1991](https://discuss.elastic.co/u/theo1991)\ **Post date:** [July 19, 2019, 1:44pm UTC](https://discuss.elastic.co/t/interval-timestamp-visualization-vertical-histogram/191404/1 "2019-07-19T13:44:31Z")
Hello, I have an event\_count field which is NUMBER:int, and I want to see it for a period of 1 week for example. But I want to use an interval of eight hours which is easy at this point with the interval field, but not from midnight to midnight, from 5 AM to 5 AM. How can I do that ? Thank you ---
**Author:** ![Bargs](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/bargs/32/5429_2.png) [@Bargs](https://discuss.elastic.co/u/Bargs)\ **Post date:** [July 19, 2019, 8:33pm UTC](https://discuss.elastic.co/t/interval-timestamp-visualization-vertical-histogram/191404/2 "2019-07-19T20:33:26Z")
I might be misunderstanding your question, but I think you could just set the beginning of the time interval in the date picker (top right corner) to midnight of the day you want to start on. ---
**Author:** ![theo1991](https://avatars.discourse-cdn.com/v4/letter/t/4da419/32.png) [@theo1991](https://discuss.elastic.co/u/theo1991)\ **Post date:** [July 22, 2019, 7:29am UTC](https://discuss.elastic.co/t/interval-timestamp-visualization-vertical-histogram/191404/3 "2019-07-22T07:29:00Z")
Thanks for your answer. I tried this : ![image](https://us1.discourse-cdn.com/elastic/original/3X/6/c/6c0c26b0c13b26a562793f5ed9b7b1c0dd588dcc.png) ![image](https://us1.discourse-cdn.com/elastic/original/3X/b/6/b6a26e6cda76960dc704bf3372ab7eb8f89ba4ed.png) ![image](https://us1.discourse-cdn.com/elastic/original/3X/e/4/e48cbb5fb884cf14381e32f1cd5cd47d3b646458.png) But as you can see, it prints an interval of twelve hours : ![image](https://us1.discourse-cdn.com/elastic/original/3X/1/0/10d6f479ae8539490fab3cc1058be986649b37f8.png) ![image](https://us1.discourse-cdn.com/elastic/original/3X/d/4/d40dbf0e197d2390ca75b6d7a42df0ac32dfddd7.png) I want to start from the first june at 5 AM with an interval of 8 hours (the first at 5AM, then at 1PM, then 9PM, then the second 5AM etc ...) ---
**Author:** ![Bargs](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/bargs/32/5429_2.png) [@Bargs](https://discuss.elastic.co/u/Bargs)\ **Post date:** [July 22, 2019, 10:55pm UTC](https://discuss.elastic.co/t/interval-timestamp-visualization-vertical-histogram/191404/4 "2019-07-22T22:55:58Z")
Ah I see, you're running into the auto scaling Kibana does if it thinks an interval will create too many bars in a date histogram. You can control this with the "Maximum bars" setting in Advance Settings. ---
**Author:** ![theo1991](https://avatars.discourse-cdn.com/v4/letter/t/4da419/32.png) [@theo1991](https://discuss.elastic.co/u/theo1991)\ **Post date:** [July 23, 2019, 8:07am UTC](https://discuss.elastic.co/t/interval-timestamp-visualization-vertical-histogram/191404/5 "2019-07-23T08:07:54Z")
I get rid of it, but same problem, it doesn't print the desired interval I want from 5 AM to 5 AM with 3 intervals (5AM to 1PM, 1PM to 9PM, 9PM to 5 AM) But it prints from midnight to midnight with 0AM to 8AM, 8AM to 4PM, 4PM to midnight ![image](https://us1.discourse-cdn.com/elastic/original/3X/d/1/d16e235a50444f6d2d930816a5642465e00a6f04.png) ![image](https://us1.discourse-cdn.com/elastic/original/3X/1/8/1804c5be27151b9f542c8558dd924ecd4fcf7d35.png) ![Screenshot%20from%202019-07-23%2010-06-30](https://us1.discourse-cdn.com/elastic/original/3X/3/8/38619eb4d470ef8fe3c21d3f2b972bf704de8ce6.png) ![Screenshot%20from%202019-07-23%2010-06-46](https://us1.discourse-cdn.com/elastic/original/3X/c/6/c65fe66077a91a442c7ae3e6b0e61b5b77febb42.png) ---
**Author:** ![Bargs](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/bargs/32/5429_2.png) [@Bargs](https://discuss.elastic.co/u/Bargs)\ **Post date:** [July 23, 2019, 2:54pm UTC](https://discuss.elastic.co/t/interval-timestamp-visualization-vertical-histogram/191404/6 "2019-07-23T14:54:34Z")
It looks like the elasticsearch date histogram agg always starts at midnight by default. We can change that with the [offset](https://www.elastic.co/guide/en/elasticsearch/reference/7.3/search-aggregations-bucket-datehistogram-aggregation.html#_offset) parameter though. You can configure it for your chart using the advanced JSON input in the vis editor. ![03%20AM](https://us1.discourse-cdn.com/elastic/original/3X/c/b/cbd475c71de6ef6b3a9a140b82fbc2b31a2c6e48.png) ---
**Author:** ![theo1991](https://avatars.discourse-cdn.com/v4/letter/t/4da419/32.png) [@theo1991](https://discuss.elastic.co/u/theo1991)\ **Post date:** [July 23, 2019, 2:57pm UTC](https://discuss.elastic.co/t/interval-timestamp-visualization-vertical-histogram/191404/7 "2019-07-23T14:57:03Z")
Wonderful ! Thank you Bargs !! ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [August 20, 2019, 2:57pm UTC](https://discuss.elastic.co/t/interval-timestamp-visualization-vertical-histogram/191404/8 "2019-08-20T14:57:06Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.