Kibana visualization for grouping and filter

Question

I have my data in Elasticsearch like below

I'm trying to create a pie chart in kibana which shows the percentage of people who visited both UK and India and % of people who visited only India and % percentage of people who visited only UK.
But I'm not able to find a way to group by person name and do filter on the country visited in the pie chart in kibana. Any way to do this?

Answer 1

I believe you are looking for filterAggregation : Filter Aggregation Effectively it enables aggregation on different filters.

Add this as a second aggregation(split slice) after the Persons Aggregation.

If you are just interested in count and Not counts per person, just leverage Filter Aggregation with respective filters which will give you the percentages per filter.