# Kibana: Data Table and Line Chart have different numbers

**URL:** https://discuss.elastic.co/t/kibana-data-table-and-line-chart-have-different-numbers/129462
**Category:** Kibana
**Created:** [April 25, 2018, 10:47am UTC](https://discuss.elastic.co/t/kibana-data-table-and-line-chart-have-different-numbers/129462 "2018-04-25T10:47:45Z")
**Posts on this page:** 11
**Page:** 1

<div class="post-metadata">

### Author: ![mohd.faraaz](https://avatars.discourse-cdn.com/v4/letter/m/eb9ed0/32.png) [@mohd.faraaz](https://discuss.elastic.co/u/mohd.faraaz)
#### Post date: [April 25, 2018, 10:47am UTC](https://discuss.elastic.co/t/kibana-data-table-and-line-chart-have-different-numbers/129462/1 "2018-04-25T10:47:46Z")

</div>

Hi,

Reading from the same index, if we plot a line chart or create data table across same dimension, we get different results.  
The numbers in data table are always less than what is shown in line chart.

Any fixes?

Thanks in advance  
Cheers, Mohammad Faraaz

---

<div class="post-metadata">

### Author: ![Joe\_Fleming](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/joe_fleming/32/3561_2.png) [@Joe\_Fleming](https://discuss.elastic.co/u/Joe_Fleming)
#### Post date: [April 25, 2018, 5:45pm UTC](https://discuss.elastic.co/t/kibana-data-table-and-line-chart-have-different-numbers/129462/2 "2018-04-25T17:45:40Z")

</div>

There's not enough information here to be able to answer that. How are you building the aggregations for each of the visualizations? Are you applying filters to either of them? Are they the same filters? Some screenshots from Kibana of the two visualizations loaded in Visualize would be helpful, if you can can provide them.

---

<div class="post-metadata">

### Author: ![mohd.faraaz](https://avatars.discourse-cdn.com/v4/letter/m/eb9ed0/32.png) [@mohd.faraaz](https://discuss.elastic.co/u/mohd.faraaz)
#### Post date: [April 27, 2018, 9:44am UTC](https://discuss.elastic.co/t/kibana-data-table-and-line-chart-have-different-numbers/129462/3 "2018-04-27T09:44:58Z")

</div>

Hey Joe,  
We are building aggregations for both data table and visualization from the same index and apply same filters to each of them. Then they are placed in the dashboard.  
The aggregated count of observations are different in data table and visualization.

Looking for your help.

Cheers, Faraaz

---

<div class="post-metadata">

### Author: ![mohd.faraaz](https://avatars.discourse-cdn.com/v4/letter/m/eb9ed0/32.png) [@mohd.faraaz](https://discuss.elastic.co/u/mohd.faraaz)
#### Post date: [April 30, 2018, 10:51am UTC](https://discuss.elastic.co/t/kibana-data-table-and-line-chart-have-different-numbers/129462/4 "2018-04-30T10:51:25Z")

</div>

Gentle Reminder

---

<div class="post-metadata">

### Author: ![mohd.faraaz](https://avatars.discourse-cdn.com/v4/letter/m/eb9ed0/32.png) [@mohd.faraaz](https://discuss.elastic.co/u/mohd.faraaz)
#### Post date: [May 3, 2018, 5:29am UTC](https://discuss.elastic.co/t/kibana-data-table-and-line-chart-have-different-numbers/129462/5 "2018-05-03T05:29:27Z")

</div>

Hi,  
In case more information is required, please let me know.

Regards  
Faraaz

---

<div class="post-metadata">

### Author: ![Joe\_Fleming](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/joe_fleming/32/3561_2.png) [@Joe\_Fleming](https://discuss.elastic.co/u/Joe_Fleming)
#### Post date: [May 10, 2018, 7:43pm UTC](https://discuss.elastic.co/t/kibana-data-table-and-line-chart-have-different-numbers/129462/6 "2018-05-10T19:43:21Z")

</div>

I tried this locally, and I found that the table vis wasn't showing the correct count, seemingly because it was not preserving the filter. It looks like that's been fixed in newer versions of Kibana though. I can't find the associated pull request so I don't know what version it was fixed in.

 ![00](https://us1.discourse-cdn.com/elastic/original/3X/4/b/4b1087ceacf2d5cf319849fe3ad8031c34afd32e.png)

What version are you running? And can you try upgrading to the latest version?

---

<div class="post-metadata">

### Author: ![mohd.faraaz](https://avatars.discourse-cdn.com/v4/letter/m/eb9ed0/32.png) [@mohd.faraaz](https://discuss.elastic.co/u/mohd.faraaz)
#### Post date: [May 11, 2018, 6:31am UTC](https://discuss.elastic.co/t/kibana-data-table-and-line-chart-have-different-numbers/129462/7 "2018-05-11T06:31:53Z")

</div>

Hi Joe,  
Thanks for simulating this exercise.

We are using Elastic Search 5.0.1 and Kibana 5.0.1 version in our case.

Cheers, Faraaz

---

<div class="post-metadata">

### Author: ![Joe\_Fleming](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/joe_fleming/32/3561_2.png) [@Joe\_Fleming](https://discuss.elastic.co/u/Joe_Fleming)
#### Post date: [May 14, 2018, 6:10pm UTC](https://discuss.elastic.co/t/kibana-data-table-and-line-chart-have-different-numbers/129462/8 "2018-05-14T18:10:02Z")

</div>

Hrm, 5.0.1 doesn't seem the have the bug I was seeing.

 ![28](https://us1.discourse-cdn.com/elastic/original/3X/6/9/69b819d48164a0905d7b5c7bfeba4d3688ae55b2.png)

You say "The numbers in data table are always less than what is shown in line chart," how far off are the numbers you are seeing?

---

<div class="post-metadata">

### Author: ![mohd.faraaz](https://avatars.discourse-cdn.com/v4/letter/m/eb9ed0/32.png) [@mohd.faraaz](https://discuss.elastic.co/u/mohd.faraaz)
#### Post date: [May 22, 2018, 5:19am UTC](https://discuss.elastic.co/t/kibana-data-table-and-line-chart-have-different-numbers/129462/9 "2018-05-22T05:19:59Z")

</div>

Hi Joe,

The tabular data is ~18% lesser than what is represented in visualizations.

Regards  
Faraaz

---

<div class="post-metadata">

### Author: ![Joe\_Fleming](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/joe_fleming/32/3561_2.png) [@Joe\_Fleming](https://discuss.elastic.co/u/Joe_Fleming)
#### Post date: [May 22, 2018, 4:47pm UTC](https://discuss.elastic.co/t/kibana-data-table-and-line-chart-have-different-numbers/129462/10 "2018-05-22T16:47:19Z")

</div>

I was thinking it's possible that the time buckets were different, which is why the numbers would be off, but that shouldn't really happen, and would probably only be noticeable if you had very high document counts.

A screenshot of the table and the visualization would be really helpful here. It's hard to figure out what might be going on here without looking at it.

---

<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: [June 19, 2018, 4:47pm UTC](https://discuss.elastic.co/t/kibana-data-table-and-line-chart-have-different-numbers/129462/11 "2018-06-19T16:47:26Z")

</div>

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