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

Elastic Stack Kibana
1

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

3

hronecviktor,

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.