# Discover Results Do Not Match Visualization Results

**URL:** <https://discuss.elastic.co/t/discover-results-do-not-match-visualization-results/339845>\
**Category:** Kibana\
**Tags:** visualisation\
**Created:** [August 1, 2023, 6:54pm UTC](https://discuss.elastic.co/t/discover-results-do-not-match-visualization-results/339845 "2023-08-01T18:54:20Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![codewriterguy](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/codewriterguy/32/113440_2.png) [@codewriterguy](https://discuss.elastic.co/u/codewriterguy)\
**Post date:** [August 1, 2023, 6:54pm UTC](https://discuss.elastic.co/t/discover-results-do-not-match-visualization-results/339845/1 "2023-08-01T18:54:20Z")

</div>

Hi,

Querying in Discover gives some number of results:

 ![Screenshot 2023-08-01 at 1.52.02 PM](https://us1.discourse-cdn.com/elastic/original/3X/0/4/04920bb3d32e09151236587853eb2a19b959ec65.png)

The same query in a visualization isn't giving any results:

 ![Screenshot 2023-08-01 at 1.53.07 PM](https://us1.discourse-cdn.com/elastic/original/3X/c/5/c50b9bd83040a17b155ed774618318970c4cabac.png)

Do both of these use the index pattern, and shouldn't both get the same query results for the same time frame and the same index? Anything I can check that would cause disparity?

---

<div class="post-metadata">

**Author:** ![nickpeihl](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/nickpeihl/32/112622_2.png) [@nickpeihl](https://discuss.elastic.co/u/nickpeihl)\
**Post date:** [August 2, 2023, 1:29pm UTC](https://discuss.elastic.co/t/discover-results-do-not-match-visualization-results/339845/2 "2023-08-02T13:29:58Z")

</div>

Hi Patrick. There should be an "Inspect" button on the top of the page in both applications. You can use this to see the Elasticsearch queries and results. Perhaps you can find the cause of the disparity by comparing the query/result of both applications.

---

<div class="post-metadata">

**Author:** ![codewriterguy](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/codewriterguy/32/113440_2.png) [@codewriterguy](https://discuss.elastic.co/u/codewriterguy)\
**Post date:** [August 4, 2023, 6:23pm UTC](https://discuss.elastic.co/t/discover-results-do-not-match-visualization-results/339845/3 "2023-08-04T18:23:06Z")

</div>

Thank you @nickpeihl! Didn't know about the Inspect button, this is helpful! Turns out there was not, in fact, a discrepancy 🤦‍♂️ and I just didn't understand what I was looking at.

I was looking at a Lens, when I thought what I had was an aggregation-based viz for a data table.

Interestingly, I didn't see the Inspect button on the Lens creator, but I did see it elsewhere and it's a useful tool.

---

<div class="post-metadata">

**Author:** ![nickpeihl](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/nickpeihl/32/112622_2.png) [@nickpeihl](https://discuss.elastic.co/u/nickpeihl)\
**Post date:** [August 4, 2023, 8:13pm UTC](https://discuss.elastic.co/t/discover-results-do-not-match-visualization-results/339845/4 "2023-08-04T20:13:51Z")

</div>

Hi Patrick. Looks like the Inspector was added to the Lens editor in 7.16. Perhaps you have an older version of Kibana? [[Lens] Inspect flyout should be available in editor mode. by alexwizp · Pull Request #109656 · elastic/kibana · GitHub](https://github.com/elastic/kibana/pull/109656)

---

<div class="post-metadata">

**Author:** ![codewriterguy](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/codewriterguy/32/113440_2.png) [@codewriterguy](https://discuss.elastic.co/u/codewriterguy)\
**Post date:** [August 11, 2023, 2:40pm UTC](https://discuss.elastic.co/t/discover-results-do-not-match-visualization-results/339845/5 "2023-08-11T14:40:33Z")

</div>

Oh yes! We have 7.8.0

---

<div class="post-metadata">

**Author:** ![stephenb](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/stephenb/32/40856_2.png) [@stephenb](https://discuss.elastic.co/u/stephenb)\
**Post date:** [August 11, 2023, 2:47pm UTC](https://discuss.elastic.co/t/discover-results-do-not-match-visualization-results/339845/6 "2023-08-11T14:47:43Z")

</div>

@codewriterguy

Looks to me you You have no rows (obvious) but I don't see rows configured

Can you show the entire configuration?

What if you just use Count?

7.8 is so old hard for me to recall what it looked like back then... a Row Setting is required in the table in newer versions.

And / Or Try a vertical Bar chart with Date Histogram for x axis and count for Y start from there...

Then perhaps go back to the table.

---

<div class="post-metadata">

**Author:** ![codewriterguy](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/codewriterguy/32/113440_2.png) [@codewriterguy](https://discuss.elastic.co/u/codewriterguy)\
**Post date:** [August 11, 2023, 9:55pm UTC](https://discuss.elastic.co/t/discover-results-do-not-match-visualization-results/339845/7 "2023-08-11T21:55:38Z")

</div>

This is correct. Marking as solution. The count does show records coming back, and I didn't add any rows. Thank you for the help all

 ![Screenshot 2023-08-11 at 3.55.11 PM](https://us1.discourse-cdn.com/elastic/original/3X/e/8/e87713de7cf00061610b34700f8a1c7e9a24bb38.png)

---

<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:** [September 8, 2023, 9:56pm UTC](https://discuss.elastic.co/t/discover-results-do-not-match-visualization-results/339845/8 "2023-09-08T21:56:11Z")

</div>

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