# Line chart and data table in kibana show different numbers
**URL:** https://discuss.elastic.co/t/line-chart-and-data-table-in-kibana-show-different-numbers/155417
**Category:** Kibana
**Created:** [November 5, 2018, 2:58pm UTC](https://discuss.elastic.co/t/line-chart-and-data-table-in-kibana-show-different-numbers/155417 "2018-11-05T14:58:41Z")
**Posts on this page:** 15
**Page:** 1
### Author:  [@ilanas](https://discuss.elastic.co/u/ilanas)
#### Post date: [November 5, 2018, 2:58pm UTC](https://discuss.elastic.co/t/line-chart-and-data-table-in-kibana-show-different-numbers/155417/1 "2018-11-05T14:58:41Z")
This post is the same as 'Kibana: Data Table and Line Chart have different numbers'. I have the same issue and i don't know how solve this issue. I'm using kibana 6.2.2.
Thanks
---
### Author:  [@Nathan\_Reese](https://discuss.elastic.co/u/Nathan_Reese)
#### Post date: [November 5, 2018, 3:04pm UTC](https://discuss.elastic.co/t/line-chart-and-data-table-in-kibana-show-different-numbers/155417/2 "2018-11-05T15:04:58Z")
Could you please include the URL to the post that you are referring too?
---
### Author:  [@ilanas](https://discuss.elastic.co/u/ilanas)
#### Post date: [November 5, 2018, 3:06pm UTC](https://discuss.elastic.co/t/line-chart-and-data-table-in-kibana-show-different-numbers/155417/3 "2018-11-05T15:06:02Z")
> [@ilanas](#):
>
> 'Kibana: Data Table and Line Chart have different numbers
> [@Kibana: Data Table and Line Chart have different numbers](https://discuss.elastic.co/t/kibana-data-table-and-line-chart-have-different-numbers/129462):
>
> 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
---
### Author:  [@ilanas](https://discuss.elastic.co/u/ilanas)
#### Post date: [November 5, 2018, 3:49pm UTC](https://discuss.elastic.co/t/line-chart-and-data-table-in-kibana-show-different-numbers/155417/4 "2018-11-05T15:49:27Z")
can anybody help me? please
---
### Author:  [@ilanas](https://discuss.elastic.co/u/ilanas)
#### Post date: [November 6, 2018, 10:20am UTC](https://discuss.elastic.co/t/line-chart-and-data-table-in-kibana-show-different-numbers/155417/5 "2018-11-06T10:20:43Z")
I have tried to do the same with a bar chart and it gives me the same error. All graphics get me the wrong data. Except the table. some help?
---
### Author:  [@ilanas](https://discuss.elastic.co/u/ilanas)
#### Post date: [November 6, 2018, 11:50am UTC](https://discuss.elastic.co/t/line-chart-and-data-table-in-kibana-show-different-numbers/155417/6 "2018-11-06T11:50:29Z")
I have discovered something curious in case you can help me. The first image shows the discover so you can have an idea of what each record has. The second is what I seek to do and what gives an error (Sum the amounts wrong). The third option makes the sum well but the line graph is ugly
---
### Author:  [@ilanas](https://discuss.elastic.co/u/ilanas)
#### Post date: [November 6, 2018, 11:56am UTC](https://discuss.elastic.co/t/line-chart-and-data-table-in-kibana-show-different-numbers/155417/7 "2018-11-06T11:56:41Z")
if cursonombre is anterior -2 then importe have the same value of anterior-2 and anterior, actual and anterior -1 are 0
---
### Author:  [@ilanas](https://discuss.elastic.co/u/ilanas)
#### Post date: [November 6, 2018, 2:58pm UTC](https://discuss.elastic.co/t/line-chart-and-data-table-in-kibana-show-different-numbers/155417/8 "2018-11-06T14:58:29Z")
do you understand my question? I don't know why appens this...
---
### Author:  [@Nathan\_Reese](https://discuss.elastic.co/u/Nathan_Reese)
#### Post date: [November 6, 2018, 4:02pm UTC](https://discuss.elastic.co/t/line-chart-and-data-table-in-kibana-show-different-numbers/155417/9 "2018-11-06T16:02:29Z")
Can you try reproducing your problem with one of the sample data sets so I can try and reproduce on my end?
Sample data sets were introduced in Kibana 6.4
---
### Author:  [@ilanas](https://discuss.elastic.co/u/ilanas)
#### Post date: [November 6, 2018, 4:04pm UTC](https://discuss.elastic.co/t/line-chart-and-data-table-in-kibana-show-different-numbers/155417/10 "2018-11-06T16:04:27Z")
i have 6.2.2 in kibana. How can i migrate to 6.4?
---
### Author:  [@Nathan\_Reese](https://discuss.elastic.co/u/Nathan_Reese)
#### Post date: [November 6, 2018, 4:05pm UTC](https://discuss.elastic.co/t/line-chart-and-data-table-in-kibana-show-different-numbers/155417/11 "2018-11-06T16:05:43Z")
What is the cardinality of DEPARTAMENTO? Try moving that aggregation above the x-axis aggregation so each x-axis bucket is working with the same DEPARTAMENTO values
---
### Author:  [@Nathan\_Reese](https://discuss.elastic.co/u/Nathan_Reese)
#### Post date: [November 6, 2018, 4:09pm UTC](https://discuss.elastic.co/t/line-chart-and-data-table-in-kibana-show-different-numbers/155417/12 "2018-11-06T16:09:00Z")
> [@ilanas](#):
>
> i have 6.2.2 in kibana. How can i migrate to 6.4?
You do not have to upgrade but rather, just phrase your question/problem in the context of a sample data set so we are looking at the same thing.
I am not sure what the problem is and it is hard to see without the data set, what you are expecting, how the values are different, and so on.
If you could just stand up a new 6.4 stack and recreate the problem and use that example that would really help
---
### Author:  [@ilanas](https://discuss.elastic.co/u/ilanas)
#### Post date: [November 6, 2018, 4:10pm UTC](https://discuss.elastic.co/t/line-chart-and-data-table-in-kibana-show-different-numbers/155417/13 "2018-11-06T16:10:56Z")
i put departamento above x-axis and nothing. What refers with cardinality?
---
### Author:  [@ilanas](https://discuss.elastic.co/u/ilanas)
#### Post date: [November 6, 2018, 4:12pm UTC](https://discuss.elastic.co/t/line-chart-and-data-table-in-kibana-show-different-numbers/155417/14 "2018-11-06T16:12:48Z")
Just i solved!!! i change the sql query and i don't know because but now the chart are well!!
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [December 4, 2018, 4:21pm UTC](https://discuss.elastic.co/t/line-chart-and-data-table-in-kibana-show-different-numbers/155417/15 "2018-12-04T16:21:38Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.