# Change X-Axis timestamp interval

**URL:** <https://discuss.elastic.co/t/change-x-axis-timestamp-interval/74898>\
**Category:** Kibana\
**Created:** [February 13, 2017, 3:25pm UTC](https://discuss.elastic.co/t/change-x-axis-timestamp-interval/74898 "2017-02-13T15:25:35Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Beuhlet\_Reseau](https://avatars.discourse-cdn.com/v4/letter/b/e95f7d/32.png) [@Beuhlet\_Reseau](https://discuss.elastic.co/u/Beuhlet_Reseau)\
**Post date:** [February 13, 2017, 3:25pm UTC](https://discuss.elastic.co/t/change-x-axis-timestamp-interval/74898/1 "2017-02-13T15:25:35Z")

</div>

Hello,

I am confused about the interval in graph creation in Kibana.

My rotation of logs is every hour on 24 hours. But in Kibana Visualize, my X-axis aggregation based to timestamp of logs is configured every hour **BUT** Kibana aggregate on 3 hours (see screenshot under)

![](https://us1.discourse-cdn.com/elastic/original/2X/a/a1e340fd12d8cfc14c212dcfd541df4ed21cc11c.png)

This distorts the results, Because kibana aggregates them in 3h

---

<div class="post-metadata">

**Author:** ![tsullivan](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/tsullivan/32/31077_2.png) [@tsullivan](https://discuss.elastic.co/u/tsullivan)\
**Post date:** [February 13, 2017, 10:22pm UTC](https://discuss.elastic.co/t/change-x-axis-timestamp-interval/74898/2 "2017-02-13T22:22:49Z")

</div>

That interval controls the bucket size of the date histogram. It's not distorting the results, it's just controlling how the data that goes into each sum is broken up.

The problem is that a 1-hour interval creates too many buckets for the visualization to render clearly. The automatic down-scaling is there because that interval size could overload your browser, or just be too fine-grained to get any meaning from it.

You probably need to select a smaller range from the timepicker to get the 1-hour bucket size. Instead of doing "last month", try "last week." If you need a "last month" visualization, you might want to use a daily interval instead of an hourly interval. Note that these numbers are just guesses I've come up with, since I don't know what your timepicker is actually set to.

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [March 13, 2017, 10:23pm UTC](https://discuss.elastic.co/t/change-x-axis-timestamp-interval/74898/3 "2017-03-13T22:23:00Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.
