# Can I create a table visualisation of my data without any aggregations in Kibana 6.5?

**URL:** <https://discuss.elastic.co/t/can-i-create-a-table-visualisation-of-my-data-without-any-aggregations-in-kibana-6-5/192417>\
**Category:** Kibana\
**Created:** [July 26, 2019, 11:10am UTC](https://discuss.elastic.co/t/can-i-create-a-table-visualisation-of-my-data-without-any-aggregations-in-kibana-6-5/192417 "2019-07-26T11:10:47Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![reillye](https://avatars.discourse-cdn.com/v4/letter/r/c6cbf5/32.png) [@reillye](https://discuss.elastic.co/u/reillye)\
**Post date:** [July 26, 2019, 11:10am UTC](https://discuss.elastic.co/t/can-i-create-a-table-visualisation-of-my-data-without-any-aggregations-in-kibana-6-5/192417/1 "2019-07-26T11:10:48Z")

</div>

I want to create a visualisation of one of my indexes that is simply a table view of the data, with each column corresponding to a field in the index. So if the index has documents like so:

```
{
    "name" : "Eoin",
    "address" : "123 fake street",
    "age" : 26
},
{
    "name" : "Tom",
    "address" : "789 fakest street",
    "age" : 21
}

```

I just want to create a visualisation that will display the data in a table as follows:

```
name | address | age
Eoin | 123 fake street | 26
Tom | 789 fakest street | 21

```

However I'm not able to create this with the current data table in `kibana 6.5.4` because it forces you apply a metric such as count, avg etc. I saw a previous suggestion saying to save a custom search on discover and import that into a dashboard, but that simply copies how the data is displayed in discover into a dashboard, which is not what I want. I need it in a table structure like the one above.

Can this be done using Kibana? I would have thought this would be one of the most basic visualisations it would provide, but apparently not.

---

<div class="post-metadata">

**Author:** ![Hoan\_Le](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/hoan_le/32/50270_2.png) [@Hoan\_Le](https://discuss.elastic.co/u/Hoan_Le)\
**Post date:** [July 26, 2019, 11:20am UTC](https://discuss.elastic.co/t/can-i-create-a-table-visualisation-of-my-data-without-any-aggregations-in-kibana-6-5/192417/2 "2019-07-26T11:20:42Z")

</div>

You can use Discover and select fields name, address and age from available fields and finally save as "Save search". "Save search" is a type of table visualization that you can add to dashboard

---

<div class="post-metadata">

**Author:** ![reillye](https://avatars.discourse-cdn.com/v4/letter/r/c6cbf5/32.png) [@reillye](https://discuss.elastic.co/u/reillye)\
**Post date:** [July 31, 2019, 12:04pm UTC](https://discuss.elastic.co/t/can-i-create-a-table-visualisation-of-my-data-without-any-aggregations-in-kibana-6-5/192417/3 "2019-07-31T12:04:20Z")

</div>

Got this to work using your suggestion after awhile. Thanks!

---

<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:** [August 28, 2019, 12:04pm UTC](https://discuss.elastic.co/t/can-i-create-a-table-visualisation-of-my-data-without-any-aggregations-in-kibana-6-5/192417/4 "2019-08-28T12:04:25Z")

</div>

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