# Kibana bar chart - how to show only hours in the X-axis, not the entire date

**URL:** <https://discuss.elastic.co/t/kibana-bar-chart-how-to-show-only-hours-in-the-x-axis-not-the-entire-date/145810>\
**Category:** Kibana\
**Created:** [August 23, 2018, 9:37pm UTC](https://discuss.elastic.co/t/kibana-bar-chart-how-to-show-only-hours-in-the-x-axis-not-the-entire-date/145810 "2018-08-23T21:37:02Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Malli](https://avatars.discourse-cdn.com/v4/letter/m/a3d4f5/32.png) [@Malli](https://discuss.elastic.co/u/Malli)\
**Post date:** [August 23, 2018, 9:37pm UTC](https://discuss.elastic.co/t/kibana-bar-chart-how-to-show-only-hours-in-the-x-axis-not-the-entire-date/145810/1 "2018-08-23T21:37:02Z")

</div>

I am creating a visualization with bar charts and using date histogram on the x-axis. i am selecting the hourly interval. when the data populates the X-axis shows the entire date, not just hours, what i want.

How can i do that?

Kibana Version: 6.3

Any help help would be appreciated.

---

<div class="post-metadata">

**Author:** ![warkolm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/warkolm/32/39224_2.png) [@warkolm](https://discuss.elastic.co/u/warkolm)\
**Post date:** [August 23, 2018, 9:41pm UTC](https://discuss.elastic.co/t/kibana-bar-chart-how-to-show-only-hours-in-the-x-axis-not-the-entire-date/145810/2 "2018-08-23T21:41:21Z")

</div>

So you want things bucketed by the hours 0-23?

---

<div class="post-metadata">

**Author:** ![Malli](https://avatars.discourse-cdn.com/v4/letter/m/a3d4f5/32.png) [@Malli](https://discuss.elastic.co/u/Malli)\
**Post date:** [August 23, 2018, 9:46pm UTC](https://discuss.elastic.co/t/kibana-bar-chart-how-to-show-only-hours-in-the-x-axis-not-the-entire-date/145810/3 "2018-08-23T21:46:54Z")

</div>

Yes, the data is cumming as expected but the x-axis markers are showing the entire date, i want to show only the the hour. If it is displaying the entire date(2018-08-20 07:00), since it is log string and showing only 3-4 values on the x-axis.  
Appreciate your quick response.

---

<div class="post-metadata">

**Author:** ![warkolm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/warkolm/32/39224_2.png) [@warkolm](https://discuss.elastic.co/u/warkolm)\
**Post date:** [August 24, 2018, 8:22pm UTC](https://discuss.elastic.co/t/kibana-bar-chart-how-to-show-only-hours-in-the-x-axis-not-the-entire-date/145810/4 "2018-08-24T20:22:45Z")

</div>

You either need to create a scripted field to extract the hour from the date, or extract that during ingestion to allow you to create the visualistion.

---

<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:** [September 21, 2018, 8:22pm UTC](https://discuss.elastic.co/t/kibana-bar-chart-how-to-show-only-hours-in-the-x-axis-not-the-entire-date/145810/5 "2018-09-21T20:22:52Z")

</div>

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