I am having search engine data (Searches and Clicks), there are two tables(as table field in Elasticsearch) searches and clicks. I have a mapping between them (Same id in corresponding data), now I want to generate the various interactive dashboards using Kibana, some examples are
- Pie chart using range filter for clicked positions. (1-5,5-10 etc.)
- Data table containing Top queries for selected position buckets from both table.
- Data table for Top queries and their clicked urls with URL count.
All these graphs should be interactive, i.e. if I click on position bucket then search table data should be displayed as well. (Note there are no position field in search table, we have only same id mapping between these records.)
So my question is can we use Kibana for such use case?? Currently we are using tableau which supports sql joins, so we are able to achieve this functionality.