# Kibana visual shows wrong value

**URL:** <https://discuss.elastic.co/t/kibana-visual-shows-wrong-value/231550>\
**Category:** Kibana\
**Created:** [May 7, 2020, 1:32pm UTC](https://discuss.elastic.co/t/kibana-visual-shows-wrong-value/231550 "2020-05-07T13:32:10Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Souvik\_Das](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/souvik_das/32/107606_2.png) [@Souvik\_Das](https://discuss.elastic.co/u/Souvik_Das)\
**Post date:** [May 7, 2020, 1:32pm UTC](https://discuss.elastic.co/t/kibana-visual-shows-wrong-value/231550/1 "2020-05-07T13:32:10Z")

</div>

Hi,  
I've made a stacked bar chart as shown below.  
 ![suspected duplicates](https://us1.discourse-cdn.com/elastic/original/3X/6/e/6e7c0165c8f8f183258f8d14109cffb3f18a80a4.png)  
When I hovered on the particular stack it has shown the count is 8. But when I clicked on the same stack, it has shown the count is 10. See below the reference image.  
 ![suspected duplicates2](https://us1.discourse-cdn.com/elastic/original/3X/6/6/66c949fa30eca8cb66169e34c80e2c4478eb4253.png)  
I took 1-day data for the visualisation.  
Actually the second image shows the correct data i.e. 10. But in the first image its showing wrong value i.e. 8.  
Why does this thing happen? Why it shows 8 instead of 10?  
Please help!

---

<div class="post-metadata">

**Author:** ![jsanz](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jsanz/32/53734_2.png) [@jsanz](https://discuss.elastic.co/u/jsanz)\
**Post date:** [May 8, 2020, 2:57pm UTC](https://discuss.elastic.co/t/kibana-visual-shows-wrong-value/231550/2 "2020-05-08T14:57:46Z")

</div>

Can you take a look into the queries kibana is doing in each case? You need to open the `Inspect` link in the visualization top bar and check both tabs for the `Request` and `Response`. You can actually copy the request into the Kibana Dev Console adding a `GET /your_index/_search` to execute the query on your own.

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/0/0/00038da79a824f73ff3e7fc191a4261315ac45ad.png)

I'm thinking you may be hitting [something similar to this scenario](https://discuss.elastic.co/t/kibana-visualization-time-range-filter-gave-incorrect-result/126662/2?) where time zone settings could affect the results, but for sure checking the queries and results will give a pointer on why Kibana is giving different results.

Hope it helps!!

---

<div class="post-metadata">

**Author:** ![Souvik\_Das](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/souvik_das/32/107606_2.png) [@Souvik\_Das](https://discuss.elastic.co/u/Souvik_Das)\
**Post date:** [May 11, 2020, 5:43am UTC](https://discuss.elastic.co/t/kibana-visual-shows-wrong-value/231550/3 "2020-05-11T05:43:48Z")

</div>

Hi Jorge,  
Thanks for your response. My Kibana's timezone is in UTC and my server timezone is also in UTC. Please find the reference image below.

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/0/0/009cdad1de7ca8f97fba3da305f63dbebcc9cbb0.png)  
I've read the link you provided. I feel, for them, this is the issue. One more thing need to clarify is, their x-axis has timestamp where my x axis has terms. If it helps to detect the issue.  
Please help!

---

<div class="post-metadata">

**Author:** ![jsanz](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jsanz/32/53734_2.png) [@jsanz](https://discuss.elastic.co/u/jsanz)\
**Post date:** [May 11, 2020, 9:11am UTC](https://discuss.elastic.co/t/kibana-visual-shows-wrong-value/231550/4 "2020-05-11T09:11:11Z")

</div>

> One more thing need to clarify is, their x-axis has timestamp where my x axis has terms. If it helps to detect the issue.  
> Please help!

This is a different issue, could you please open a new forum discussion about that topic with full details? I'm afraid I won't be of much help and closing this an opening a new post will bring this to other colleagues attention.

---

<div class="post-metadata">

**Author:** ![Souvik\_Das](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/souvik_das/32/107606_2.png) [@Souvik\_Das](https://discuss.elastic.co/u/Souvik_Das)\
**Post date:** [May 11, 2020, 10:15am UTC](https://discuss.elastic.co/t/kibana-visual-shows-wrong-value/231550/5 "2020-05-11T10:15:06Z")

</div>

Thanks, Jorge for your response. I've posted the same including those points. Below is the link of that post.

> [@Kibana graph shows wrong value](https://discuss.elastic.co/t/kibana-graph-shows-wrong-value/231978):
>
> Hello, I've made a stacked bar chart as shown below. [a] When I hovered on the particular stack it has shown the count is 8. But when I clicked on the same stack, it has shown the count is 10. See below the reference image. [b] For your reference, I took 1-day data for the visualisation. Kibana's timezone is in UTC and my server's timezone is also in UTC [image] X-axis of the graph represents terms and y-axis represents counts. Actually the second image shows the correct data i.e. 10. …

Hope to get a solution soon.. 🙂

---

<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 8, 2020, 10:15am UTC](https://discuss.elastic.co/t/kibana-visual-shows-wrong-value/231550/6 "2020-06-08T10:15:06Z")

</div>

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