# Visualization in Kibana - Data formatting options

**URL:** <https://discuss.elastic.co/t/visualization-in-kibana-data-formatting-options/83614>\
**Category:** Kibana\
**Created:** [April 25, 2017, 7:05pm UTC](https://discuss.elastic.co/t/visualization-in-kibana-data-formatting-options/83614 "2017-04-25T19:05:05Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![jobyjohny](https://avatars.discourse-cdn.com/v4/letter/j/eada6e/32.png) [@jobyjohny](https://discuss.elastic.co/u/jobyjohny)\
**Post date:** [April 25, 2017, 7:05pm UTC](https://discuss.elastic.co/t/visualization-in-kibana-data-formatting-options/83614/1 "2017-04-25T19:05:05Z")

</div>

I have inserted sample data into elasticsearch .PFA the sample dummy data

 ![](https://us1.discourse-cdn.com/elastic/original/3X/3/5/354c45888af37efe3f8632b0fb74893baf70f234.png)

I need it to visualize that in a tabular format by including only the columns given in the elasticsearch index and columns as header.

Output should skip columns like \_id,\_type,\_index,\_score and other columns are required only once on top.

Right now I am using kibana 4.3

---

<div class="post-metadata">

**Author:** ![ppisljar](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/ppisljar/32/11588_2.png) [@ppisljar](https://discuss.elastic.co/u/ppisljar)\
**Post date:** [April 26, 2017, 6:19am UTC](https://discuss.elastic.co/t/visualization-in-kibana-data-formatting-options/83614/2 "2017-04-26T06:19:09Z")

</div>

You should create a saved search, then if you expand one row of your data, you will see all the fields and next to each field there is a "book icon" which on hover should say "toggle column in table". clicking that will only show that column in the table (unless you expand a row).

---

<div class="post-metadata">

**Author:** ![jobyjohny](https://avatars.discourse-cdn.com/v4/letter/j/eada6e/32.png) [@jobyjohny](https://discuss.elastic.co/u/jobyjohny)\
**Post date:** [April 29, 2017, 12:59pm UTC](https://discuss.elastic.co/t/visualization-in-kibana-data-formatting-options/83614/3 "2017-04-29T12:59:05Z")

</div>

Hi Peter,  
I was able to edit the search table in a better way from Settings.  
Click on Settings  
Click on Search  
Click on specific search – say ‘abc’  
Select using click and click on second icon  
Add the required one in available fields  
Go to dashboard open the required dashboard  
add that search and save it  
Output

---

<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:** [May 27, 2017, 1:11pm UTC](https://discuss.elastic.co/t/visualization-in-kibana-data-formatting-options/83614/4 "2017-05-27T13:11:20Z")

</div>

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