I want to create a data table from kibana that shows aggregate result based on some categorical columns for e.g. aggregation based on zone, country, the city then show aggregation of numerical data for e.g. average age of a particular group like the average age of people of Asia, India, Delhi , then next group etc, when I click on any particular row of that data table it should export all the values of that particular group to a CSV for e.g. if clicked on that row of group Asia, India, Delhi, it should export the data of all people belongs to that group to a CSV
I am not sure you can pull that off in a single click.
To export just 1 row of data I think you would need to click
add filter to each column until you only yield one result, then export to CSV.