# Merge dates

**URL:** <https://discuss.elastic.co/t/merge-dates/106650>\
**Category:** Kibana\
**Created:** [November 7, 2017, 8:59am UTC](https://discuss.elastic.co/t/merge-dates/106650 "2017-11-07T08:59:32Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![mat.bst](https://avatars.discourse-cdn.com/v4/letter/m/9e8a1a/32.png) [@mat.bst](https://discuss.elastic.co/u/mat.bst)\
**Post date:** [November 7, 2017, 8:59am UTC](https://discuss.elastic.co/t/merge-dates/106650/1 "2017-11-07T08:59:32Z")

</div>

Hello,

I have a program who all 3 hours add data in elasticsearch. Each entry represent a connected user for the date T.

I would like make a chart who tell me how much users are connected for each date T. Make this chart is very easy but I have a little problem. Sometimes, I have different dates for the same "dataset".

eg: for the dataset of this morning i have two differents hours so I have two columns instead of one in my chart.

How can i merge these differents date ?

Thanks in advance,

regards

---

<div class="post-metadata">

**Author:** ![lukas](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/lukas/32/6812_2.png) [@lukas](https://discuss.elastic.co/u/lukas)\
**Post date:** [November 7, 2017, 5:14pm UTC](https://discuss.elastic.co/t/merge-dates/106650/2 "2017-11-07T17:14:12Z")

</div>

Could you provide a sample of the documents you have in Elasticsearch, as well as what the expected result looks like? Thanks!

---

<div class="post-metadata">

**Author:** ![Badger](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/badger/32/25190_2.png) [@Badger](https://discuss.elastic.co/u/Badger)\
**Post date:** [November 7, 2017, 5:25pm UTC](https://discuss.elastic.co/t/merge-dates/106650/3 "2017-11-07T17:25:52Z")

</div>

If I understood the question correctly, and you are using a Date Histogram for the X-Axis, you can force the Interval to be Daily rather than Auto in the panel on the left.

---

<div class="post-metadata">

**Author:** ![mat.bst](https://avatars.discourse-cdn.com/v4/letter/m/9e8a1a/32.png) [@mat.bst](https://discuss.elastic.co/u/mat.bst)\
**Post date:** [November 8, 2017, 1:32pm UTC](https://discuss.elastic.co/t/merge-dates/106650/4 "2017-11-08T13:32:36Z")

</div>

Everything is alright, i solve my problem to change my data generator, I generate the same date.  
So i can make my chart like I want !

Thanks for answering me !

---

<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:** [December 6, 2017, 1:32pm UTC](https://discuss.elastic.co/t/merge-dates/106650/5 "2017-12-06T13:32:53Z")

</div>

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