# KIbana time filter

**URL:** <https://discuss.elastic.co/t/kibana-time-filter/102082>\
**Category:** Kibana\
**Created:** [September 28, 2017, 9:01am UTC](https://discuss.elastic.co/t/kibana-time-filter/102082 "2017-09-28T09:01:27Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Ahmed\_Kdh](https://avatars.discourse-cdn.com/v4/letter/a/cdc98d/32.png) [@Ahmed\_Kdh](https://discuss.elastic.co/u/Ahmed_Kdh)\
**Post date:** [September 28, 2017, 9:01am UTC](https://discuss.elastic.co/t/kibana-time-filter/102082/1 "2017-09-28T09:01:28Z")

</div>

Hi,

I got an object (item) with a start\_date and end\_date, I need to make the count day by day of the number of the items opened (where the current date in x-axis is present between start\_date and end\_date) and display the count of the items opened in historical graph.

did you have a solution ?

Thank you

Best Regards

---

<div class="post-metadata">

**Author:** ![cjcenizal](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/cjcenizal/32/11216_2.png) [@cjcenizal](https://discuss.elastic.co/u/cjcenizal)\
**Post date:** [October 2, 2017, 9:02pm UTC](https://discuss.elastic.co/t/kibana-time-filter/102082/2 "2017-10-02T21:02:39Z")

</div>

Hi Ahmed, if I understand correctly, you're saying that you have documents which contain these timestamp fields:

```auto
{
  start_date: ...,
  end_date: ...,
}

```

And you're trying to create a chart where the x-axis is time. And I think you want to show the number of the documents on the y-axis? Is this correct?

If so, then you can create a visualization using our Visualize app, set the time picker range to be the one you want, and add an X-Axis Bucket with a "Date Histogram" aggregation. When you hit the "Play" icon button, you should see the type of visualization you want. Does this help?

Thanks,  
CJ

---

<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:** [October 30, 2017, 9:02pm UTC](https://discuss.elastic.co/t/kibana-time-filter/102082/3 "2017-10-30T21:02:47Z")

</div>

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