Table visualization not showing accurate amounts

Hi,
I have configured a table visualization that should display the actual values of a time series.
To achieve that I configured the metrics as per the screenshot below:

The problem is that the information displayed by the visualization is slightly different then the information returned by the ES query.

In the example below, I'd expect a Total Amount of 634.399.066,55 which is the value present on the latest document on the index and also returned by the query but it's showing 634.399.040,00 instead (which I don't know where it is coming from).
Any ideas on how to get the exact value of the latest document displayed in a table visualization?

Thanks.

Not sure if this is causing your issue because it deals more with counts, but I'd check out the below.

https://www.elastic.co/guide/en/elasticsearch/reference/current/search-aggregations-metrics-cardinality-aggregation.html

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