# Visualizing with Kibana

**URL:** https://discuss.elastic.co/t/visualizing-with-kibana/73383
**Category:** Kibana
**Created:** [January 31, 2017, 3:02pm UTC](https://discuss.elastic.co/t/visualizing-with-kibana/73383 "2017-01-31T15:02:00Z")
**Posts on this page:** 5
**Page:** 1

<div class="post-metadata">

### Author: ![pajesz](https://avatars.discourse-cdn.com/v4/letter/p/919ad9/32.png) [@pajesz](https://discuss.elastic.co/u/pajesz)
#### Post date: [January 31, 2017, 3:02pm UTC](https://discuss.elastic.co/t/visualizing-with-kibana/73383/1 "2017-01-31T15:02:00Z")

</div>

Hello,

I know how to make different charts using Kibana like the one below.

 ![](https://us1.discourse-cdn.com/elastic/original/2X/2/21348bd4abd132417a126a1148404a07d4317e3f.png)

I was wondering if there's such functionality in kibana that for example if I click on one column, it shows all the data that belongs to that column.  
Another great thing would be if I could get a visual result for console queries not just in JSON like format.

Is there anything that offers such functionality?

Thanks in advance,  
Best regards

---

<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: [January 31, 2017, 3:43pm UTC](https://discuss.elastic.co/t/visualizing-with-kibana/73383/2 "2017-01-31T15:43:18Z")

</div>

hi @pajesz

For your first question, all visualizations in Kibana work with aggregations, not individual records, but what you can do is the following:

- create a table-visualization that shows individual records. You can do that if you have a field that can serve as an Id for that document, and then do a term-aggregation on that field.
- add both your bar chart and your table to a Dashboard.
- when you click a column, it will add a filter to the filter bar, filtering out the results in the table.

As for your 2nd question:

- Open the "spy-panel" in your visualization (use the little grey arrow at the bottom to expand it). There are a few tabs, one for the raw JSON request and response, but also one with the results in a table.

Thx,

---

<div class="post-metadata">

### Author: ![pajesz](https://avatars.discourse-cdn.com/v4/letter/p/919ad9/32.png) [@pajesz](https://discuss.elastic.co/u/pajesz)
#### Post date: [February 1, 2017, 2:20pm UTC](https://discuss.elastic.co/t/visualizing-with-kibana/73383/3 "2017-02-01T14:20:46Z")

</div>

hello,

Thanks a lot, the first one did help, but I can't find the "spy-panel". I mean I found something like you said in the discover menu, but I want the Dev Tools console query results in a table. Could you help with that (screenshot)?

thanks

---

<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: [February 1, 2017, 3:10pm UTC](https://discuss.elastic.co/t/visualizing-with-kibana/73383/4 "2017-02-01T15:10:44Z")

</div>

hi @pajesz

yup, it's that little arrow at the bottom left of the visualization

e.g.: it's right at the bottom edge of the screenshots here.

 ![](https://us1.discourse-cdn.com/elastic/original/2X/4/46cafd153cce56121fb8ae6bff314bef3301589b.png)

 ![](https://us1.discourse-cdn.com/elastic/original/2X/d/d0a1444a1adadf63b7e84c3f3c8055d442fd28bd.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: [March 1, 2017, 3:10pm UTC](https://discuss.elastic.co/t/visualizing-with-kibana/73383/5 "2017-03-01T15:10:53Z")

</div>

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