# Incorrect result in Kibana TSVB chart

**URL:** <https://discuss.elastic.co/t/incorrect-result-in-kibana-tsvb-chart/257006>\
**Category:** Kibana\
**Created:** [November 29, 2020, 8:56pm UTC](https://discuss.elastic.co/t/incorrect-result-in-kibana-tsvb-chart/257006 "2020-11-29T20:56:08Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Agenobarb](https://avatars.discourse-cdn.com/v4/letter/a/b5a626/32.png) [@Agenobarb](https://discuss.elastic.co/u/Agenobarb)\
**Post date:** [November 29, 2020, 8:56pm UTC](https://discuss.elastic.co/t/incorrect-result-in-kibana-tsvb-chart/257006/1 "2020-11-29T20:56:08Z")

</div>

Please look at the field 'timestamp' in the screenshot from Discover:

 ![Screenshot 2020-11-29 at 21.42.25](https://us1.discourse-cdn.com/elastic/original/3X/9/6/962e5cbf43b7b09b40a98756e28b2795fa535a90.png)

I am unable to understand why when I use metric max on this field - max(timestamp) I am getting a timestamp that is not within the range of timestamps I am seeing in Discover. I am certain that Discover shows the right data and nothing is missing.  
Perhaps also worth to mention that date type of this 'timestamp' is number.

 ![TSVB](https://us1.discourse-cdn.com/elastic/original/3X/e/5/e58b13887c36506cd1971bc4bf822872dd794e16.png)

---

<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:** [November 30, 2020, 10:32am UTC](https://discuss.elastic.co/t/incorrect-result-in-kibana-tsvb-chart/257006/2 "2020-11-30T10:32:20Z")

</div>

Hello,

In the Panel Options tab in TSVB you should check that "Drop Last Bucket" is set to "No". By default it's set to Yes so it might drop the values from your discover interval.

---

<div class="post-metadata">

**Author:** ![Agenobarb](https://avatars.discourse-cdn.com/v4/letter/a/b5a626/32.png) [@Agenobarb](https://discuss.elastic.co/u/Agenobarb)\
**Post date:** [December 1, 2020, 3:43pm UTC](https://discuss.elastic.co/t/incorrect-result-in-kibana-tsvb-chart/257006/3 "2020-12-01T15:43:21Z")

</div>

Thank you for suggestion. I selected 'Drap Last Bucket' but it has not had any impact.  
Another illustation of this problem is from Workbeanch where I use SQL:  
select timestamp from ab-realtime  
where v\_sess\_id = 843820799  
order by timestamp;

Results (sorted from min to max):

timestamp  
1606834494.833  
1606834490.953  
1606834494.92  
1606834495.003  
1606834490.99  
1606834490.969  
1606834496.796  
1606834505.708  
1606834499.688  
1606834508.831

Now trying to select the min value:

select min(timestamp) from ab-realtime  
where v\_sess\_id = 843820799;

Results:  
MIN(timestamp)  
**1606834432**

Again the min value not even within the range of timestamps.

---

<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 29, 2020, 3:43pm UTC](https://discuss.elastic.co/t/incorrect-result-in-kibana-tsvb-chart/257006/4 "2020-12-29T15:43:32Z")

</div>

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