Scatter plot which uses data source from Enhanced table on Dashboard

Elastic Stack Kibana
1

Hi,

I have Enhanced table plugin installed and I created pivot table which is visible on Dashboard. Underneath, I would like to have scatter plot which would be using data source not from index but from this pivot table. Is it possible to do it?

I see there could be solution to export data table to CSV and then import it again to new index which I would use for scatter plot, but this is not user friendly and I need it for client to have it simple as in Excel.

Thank you.

2

You can show a scatterplot in Kibana using vega: Scatterplot in Kibana using Vega » Tim Roes

The linked example uses raw documents but as you can control the Elasticsearch query directly, it's also possible to run aggregations corresponding to the pivot table you configured and feed that into the scatter plot.