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.