How can I represent the most recurring document in a Kibana table?

Elastic Stack Kibana
1

We are using an aggregated based kibana table that displays a bunch of users who had poor calls and where the majority of those poor calls took place, etc...(the user is set as the bucket).

For each user, we would like to display the "top" location, call type and connection type used for those poor calls.

I initially thought that we could use the "top hit" aggregation to display the most recurring document for each of those fields but I think it's only displaying the most recent document for each of those fields.

Is there a way to achieve what we want to do?

InkedScreenshot_94
InkedScreenshot_942541×1088 175 KB

2

I believe you are looking for an additional bucket in your scenario.
If you add a second bucket where you split the row on the location you'll get something like this:

user count location location type etc
john 5 Chigago alpha x
john 3 NY alpha x
mary 3 LA alpha x

Where john has a total of 5+3=8 counts and was the most observer in the chicago location.

Is this what you are looking for?

3

This brings me closer to what I was trying to achieve, thanks!