# Count improper in Visualize Tab

**URL:** <https://discuss.elastic.co/t/count-improper-in-visualize-tab/137921>\
**Category:** Kibana\
**Created:** [June 29, 2018, 9:07am UTC](https://discuss.elastic.co/t/count-improper-in-visualize-tab/137921 "2018-06-29T09:07:35Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![suchetacateina](https://avatars.discourse-cdn.com/v4/letter/s/e47774/32.png) [@suchetacateina](https://discuss.elastic.co/u/suchetacateina)\
**Post date:** [June 29, 2018, 9:07am UTC](https://discuss.elastic.co/t/count-improper-in-visualize-tab/137921/1 "2018-06-29T09:07:35Z")

</div>

Hi ,

I want to create Vertical bar graphs in Kibana. However, the total count showing up in kibana does not match the MySql database count when checked separately.

I don't understand what data does it show when i hit an Interface\_Name="Karza".  
I want to show the total count of Entire Karza Interface. How to do that such that it matches the count from the database.

 ![kibana_karza](https://us1.discourse-cdn.com/elastic/original/3X/8/5/85d068d9081a616bb091e6cca3e956ba00f426b9.png)

---

<div class="post-metadata">

**Author:** ![thomasneirynck](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/thomasneirynck/32/23313_2.png) [@thomasneirynck](https://discuss.elastic.co/u/thomasneirynck)\
**Post date:** [June 29, 2018, 3:27pm UTC](https://discuss.elastic.co/t/count-improper-in-visualize-tab/137921/2 "2018-06-29T15:27:37Z")

</div>

hi @suchetacateina,

the time range in your screenshot shows "last 15 minutes". Is it possible there are older documents in your index? if so, adjust the time-range so it encompasses the entire range of your data.

---

<div class="post-metadata">

**Author:** ![suchetacateina](https://avatars.discourse-cdn.com/v4/letter/s/e47774/32.png) [@suchetacateina](https://discuss.elastic.co/u/suchetacateina)\
**Post date:** [July 5, 2018, 11:36am UTC](https://discuss.elastic.co/t/count-improper-in-visualize-tab/137921/3 "2018-07-05T11:36:30Z")

</div>

Hi Thomas,  
Its an entirely new index. And i have kept the time range as - Last 5 years. Still it is flawed. When i cross-check it with my sql database, the numbers don't match at all. Infact, when i filter it with-respect-to  
[1] Terms or [2] Significant Terms or [3] Filters none of it is exact display of count.

Please help.

---

<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 2, 2018, 11:36am UTC](https://discuss.elastic.co/t/count-improper-in-visualize-tab/137921/4 "2018-08-02T11:36:39Z")

</div>

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