We have an existing MySQL based application which has data over several years. We have created meaningful SQL queries (i.e. join/flatten the data) and indexed that data into elasticsearch. And we want to offer this data for free-form or structured search to our users.
I chose to use Kibana (v7.4.2 currently) data tables to display the search results. See attached screenshots - the 3 visible tables are aggregations of the data on 3 different parameters which are meaningful for us - there are more visualizations below these 3 tables.
One challenge I face is the scrollbars that appears and disappear based on the search results. It gives a feeling of an unprofessional GUI. If I choose a large height for the visualization on the dashboard - I end up with too much whitespace lots of times. Too little height and there is a scrollbar most of the times. I haven't found a good balance since our data has single line text as well several lines text.
Do you have any suggestions or ideas to build a search UI using Kibana? A dynamically adapting data-table would be nice but Kibana's dashboard is fundamentally built around fixed areas for each widget.