# Data consistency issue in Visualize

**URL:** <https://discuss.elastic.co/t/data-consistency-issue-in-visualize/105722>\
**Category:** Kibana\
**Created:** [October 30, 2017, 6:59am UTC](https://discuss.elastic.co/t/data-consistency-issue-in-visualize/105722 "2017-10-30T06:59:37Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![jeremyasm](https://avatars.discourse-cdn.com/v4/letter/j/958977/32.png) [@jeremyasm](https://discuss.elastic.co/u/jeremyasm)\
**Post date:** [October 30, 2017, 6:59am UTC](https://discuss.elastic.co/t/data-consistency-issue-in-visualize/105722/1 "2017-10-30T06:59:37Z")

</div>

**Kibana version:** 5.6.2

**Elasticsearch version:** 5.6.2

**Server OS version:** Red Hat 4.8.5-11

**Browser version:**

1. Google Chrome 61.0.3163.100
2. Firefox 52.4.0

**Browser OS version:** Windows 7 64-bit

**Description of the problem including expected versus actual behavior:**

A vertical bar chart is created in Visualize, let's take TEST Company for example.  
In the bar chart, when I move mouse to hover on the bar representing TEST Company, the count is 4.  
 ![image](https://us1.discourse-cdn.com/elastic/original/3X/2/1/213f43a7d5e72fa1a29995d762cfc6d5f65f74ee.png)

But when I click on the bar item, the filter client\_name.keyword: "TEST Company" is set, the count becomes 6.  
 ![image](https://us1.discourse-cdn.com/elastic/original/3X/9/d/9defb111cd4d1a6139974dceb3af2831e2f33ecf.png)

I also checked this in other types of charts like pie:

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/8/8/880ec2a9969e752171236c7c804284be0d84f504.png)  
 ![image](https://us1.discourse-cdn.com/elastic/original/3X/5/e/5efb3765e5e7c2d01455349e25bdf9f5b3c13bc7.png)

I checked data in Discovery:

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/1/d/1d87f37470f64fdb4c62404eaa1a2976477df914.png)

Notes: It does not happen for all the items, but does happen quite often.

---

<div class="post-metadata">

**Author:** ![jbudz](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jbudz/32/45922_2.png) [@jbudz](https://discuss.elastic.co/u/jbudz)\
**Post date:** [October 30, 2017, 8:32pm UTC](https://discuss.elastic.co/t/data-consistency-issue-in-visualize/105722/2 "2017-10-30T20:32:35Z")

</div>

Document counts in terms aggregations are approximations, [https://www.elastic.co/guide/en/elasticsearch/reference/current/search-aggregations-bucket-terms-aggregation.html#search-aggregations-bucket-terms-aggregation-approximate-counts](https://www.elastic.co/guide/en/elasticsearch/reference/current/search-aggregations-bucket-terms-aggregation.html#search-aggregations-bucket-terms-aggregation-approximate-counts) has a more detailed explanation.

---

<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:** [November 27, 2017, 8:32pm UTC](https://discuss.elastic.co/t/data-consistency-issue-in-visualize/105722/3 "2017-11-27T20:32:35Z")

</div>

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