i want to create a basic data table in a Kibana Dashboard with employees.
I tried using the Table Lens but there is always a requirement for a metric like count, sum,.. which i do not need, as i only want to display my documents in a table.
I know you can hide the column, but i think because of this functionality the columns of the table are created in a nested way.
The table i want to create should have 16 columns and as i tried to add the 10th column the visualization broke, which is already described here: https://discuss.elastic.co/t/cannot-add-10-or-more-rows-to-visualize-library-in-table-view-in-kibana/299350
The answer suggests to use a discoverer saved search, so i tried that, but it turns out that with a visualisation based on a saved search it is possible to click on the documents to view the data and this is not the information a CEO should or wants to see.
I then found out, that there are two other options to create table visualizations in dashboards, which are TSVB and aggregation based data tables, but the first one only allows one column with different aggregations (as far as i can tell) and the second one is purely aggregations.
Then i found out it is possible to create a plain table with canvas, which is exactly what i want. I can just drop in my fields and it works perfectly. But i can not find a way to embed this table in a dashboard, only the other way around.
Of course the next idea then was to use canvas, but it seems like there is currently no real way of sharing and embeding an interactive canvas on a website, only a static one.
I found a workaround here: https://discuss.elastic.co/t/share-canvas-embed-on-website/273006
But this mentions that it would be possible to hit escape to end fullscreen and again see things you are not supposed to see.
So with all the great ways to visualize data in Kibana, is there really no way to add a plain big table to a dashboard?