# Table visualization not showing accurate amounts

**URL:** <https://discuss.elastic.co/t/table-visualization-not-showing-accurate-amounts/242962>\
**Category:** Kibana\
**Created:** [July 28, 2020, 6:08pm UTC](https://discuss.elastic.co/t/table-visualization-not-showing-accurate-amounts/242962 "2020-07-28T18:08:38Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![jvictorbr](https://avatars.discourse-cdn.com/v4/letter/j/77aa72/32.png) [@jvictorbr](https://discuss.elastic.co/u/jvictorbr)\
**Post date:** [July 28, 2020, 6:08pm UTC](https://discuss.elastic.co/t/table-visualization-not-showing-accurate-amounts/242962/1 "2020-07-28T18:08:38Z")

</div>

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:

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/2/b/2b63250311c6ad63219b0a7e4fe139467c3a2530.png)

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?

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/3/5/35fb92cdbb718e4b3aff755836d9ea37489e93f0.png)

Thanks.

---

<div class="post-metadata">

**Author:** ![aaron-nimocks](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/aaron-nimocks/32/73965_2.png) [@aaron-nimocks](https://discuss.elastic.co/u/aaron-nimocks)\
**Post date:** [July 28, 2020, 7:42pm UTC](https://discuss.elastic.co/t/table-visualization-not-showing-accurate-amounts/242962/2 "2020-07-28T19:42:41Z")

</div>

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

> **[Cardinality aggregation | Elasticsearch Reference](https://www.elastic.co/docs/reference/aggregations/search-aggregations-metrics-cardinality-aggregation)**
>
> A single-value metrics aggregation that calculates an approximate count of distinct values. Assume you are indexing store sales and would like to count...

---

<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:** [August 25, 2020, 7:42pm UTC](https://discuss.elastic.co/t/table-visualization-not-showing-accurate-amounts/242962/3 "2020-08-25T19:42:43Z")

</div>

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