# How to fiilter data based on a specific hour in Kibana

**URL:** <https://discuss.elastic.co/t/how-to-fiilter-data-based-on-a-specific-hour-in-kibana/74687>\
**Category:** Kibana\
**Created:** [February 10, 2017, 4:45pm UTC](https://discuss.elastic.co/t/how-to-fiilter-data-based-on-a-specific-hour-in-kibana/74687 "2017-02-10T16:45:26Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![mokka](https://avatars.discourse-cdn.com/v4/letter/m/8797f3/32.png) [@mokka](https://discuss.elastic.co/u/mokka)\
**Post date:** [February 10, 2017, 4:45pm UTC](https://discuss.elastic.co/t/how-to-fiilter-data-based-on-a-specific-hour-in-kibana/74687/1 "2017-02-10T16:45:26Z")

</div>

Hi All,

We are trying to gather daily data at a certain time and ignore all other time, for example:

We want data for hour 20:00:  
February 5th 2017, 20:00:00.000  
February 6th 2017, 20:00:00.000  
February 7th 2017, 20:00:00.000  
February 8th 2017, 20:00:00.000  
February 9th 2017, 20:00:00.000

Is there a way to do this in Kibana?

Thank you,  
Leah

---

<div class="post-metadata">

**Author:** ![BigFunger](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/bigfunger/32/7323_2.png) [@BigFunger](https://discuss.elastic.co/u/BigFunger)\
**Post date:** [February 10, 2017, 7:39pm UTC](https://discuss.elastic.co/t/how-to-fiilter-data-based-on-a-specific-hour-in-kibana/74687/2 "2017-02-10T19:39:05Z")

</div>

What is the nature of what you are actually trying to accomplish?

Are you always only concerned with hour 20, or does that need to accommodate any time window?

How would you specify the time window?

Are you trying to build visualizations with the filtered results?

---

<div class="post-metadata">

**Author:** ![mokka](https://avatars.discourse-cdn.com/v4/letter/m/8797f3/32.png) [@mokka](https://discuss.elastic.co/u/mokka)\
**Post date:** [February 10, 2017, 8:21pm UTC](https://discuss.elastic.co/t/how-to-fiilter-data-based-on-a-specific-hour-in-kibana/74687/3 "2017-02-10T20:21:53Z")

</div>

Hi Jim,

I am trying to create a line chart visual where the X-Axis has the dateTime  
and Y-Axis has count. The dateTime will be sampled every 24 hours, so even  
if there is data in between the 24 hours we only want to take a count at a  
certain time every day. I only used hour 20 as an example.

I appreciate your reply.

Thank you,  
Leah

---

<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 10, 2017, 8:21pm UTC](https://discuss.elastic.co/t/how-to-fiilter-data-based-on-a-specific-hour-in-kibana/74687/4 "2017-03-10T20:21:54Z")

</div>

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