# Getting different count on different timefields

**URL:** <https://discuss.elastic.co/t/getting-different-count-on-different-timefields/95849>\
**Category:** Kibana\
**Created:** [August 4, 2017, 9:41am UTC](https://discuss.elastic.co/t/getting-different-count-on-different-timefields/95849 "2017-08-04T09:41:43Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![sLuvpreet33](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/sluvpreet33/32/50626_2.png) [@sLuvpreet33](https://discuss.elastic.co/u/sLuvpreet33)\
**Post date:** [August 4, 2017, 9:41am UTC](https://discuss.elastic.co/t/getting-different-count-on-different-timefields/95849/1 "2017-08-04T09:41:43Z")

</div>

I have data about bookings. The data has been pulled from different tables from postgresql. And I have pushed them all under the same index and type.

Now I have 6 timefields in a document.

- booking\_time
- booking\_update\_time
- booking\_end\_time
- booking\_rating\_time
- user\_date\_joined
- user\_last\_activity

Here is the plotting of the following timelion expression,

```
.es(index='vogo-database-3', timefield='user_date_joined'), .es(index='vogo-database-3', timefield='booking_time')

```

 ![image(4)](https://us1.discourse-cdn.com/elastic/original/3X/0/0/007c7b2e1226654f476c0d13015eb6730f5b41e0.jpg)

The plotting is different when using different timefield.

My question is why is this happening ?

Every document is having a booking\_time and user\_date\_joined. The booking\_time is never the same for 2 bookings, but user\_date\_joined can be repeated if same user makes booking over and over again. But Then again, shouldn't the plotting be the same if every document has both fields ? IF no , why no then?

---

<div class="post-metadata">

**Author:** ![Marius\_Dragomir](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/marius_dragomir/32/42087_2.png) [@Marius\_Dragomir](https://discuss.elastic.co/u/Marius_Dragomir)\
**Post date:** [August 8, 2017, 5:43pm UTC](https://discuss.elastic.co/t/getting-different-count-on-different-timefields/95849/2 "2017-08-08T17:43:57Z")

</div>

That's a count of events for that specific bucket/time frame. In my mind it makes sense to have more bookings instead of user joins, because users with join dates outside the time interval could have bookings made in this interval.

---

<div class="post-metadata">

**Author:** ![sLuvpreet33](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/sluvpreet33/32/50626_2.png) [@sLuvpreet33](https://discuss.elastic.co/u/sLuvpreet33)\
**Post date:** [August 8, 2017, 6:07pm UTC](https://discuss.elastic.co/t/getting-different-count-on-different-timefields/95849/3 "2017-08-08T18:07:52Z")

</div>

Yes indeed that is true. I figured it out myself later.

---

<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 5, 2017, 6:07pm UTC](https://discuss.elastic.co/t/getting-different-count-on-different-timefields/95849/4 "2017-09-05T18:07:53Z")

</div>

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