Incorrect result in Kibana TSVB chart

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

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.

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.

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.

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