Visualisation: How to perform order by over each group

[ashish_94 (Ashish Manchanda)]

Elastic search stores docs where each doc has "api_url", "client","req_ms" column.
I want to plot a visualization where I would like to aggregate(group by) docs by "client" column, then for each client group, order documents by "req_ms" column and plot graph of each client versus top 10 slowest "api_url".

[Aaron_Caldwell]

Hello Ashish,

it sounds like you might want to use a sub-aggregation, available towards the bottom of the menu when you're creating your visualization.

https://www.elastic.co/guide/en/elasticsearch/reference/current/search-aggregations-bucket.html

Thanks!
Aaron