Metric - average count per bucket (one value for all buckets)

Hi everybody,

My elasticsearch index contains field called "sr_id" - an ID of a user. Lots of records for each sr_id.
I need to create a "Metric" visualization to show how many records are related to a user on average. e.g.
If there are:
10 records with sr_id: A
5 records with sr_id:B
1 record with sr_id:C

i need to display: Average records per user: 5

Please, does anybody have experience with metrics like these?
Any help appreciated


Currently, there is no way to do that in Kibana. That requires pipeline aggregations, and it has been talked about a lot, but is probably not something that will be coming any time soon.