How to view average Aggregation in Kibana Visualization 5.4.1


(Louie Hernandez) #1

The average metric seems to only do the average of any values in a row of a certain field. I have multiple rows with just one value in this field per row and I want to know what the average of all the row field values are.

So if I have a Column Count and two rows, one with a count of 2 and another with 4, I want to see the average 3.


(kulkarni) #2

HI Louie

you could achieve this by using the average Aggregation in Kibana Visualization:It gives you the average of the table. Tried this on 5.4.1 More information here: https://www.elastic.co/guide/en/elasticsearch/reference/current/search-aggregations-metrics-avg-aggregation.html

Thanks
Rashmi


(Louie Hernandez) #3

Thanks this was helpful!


(system) #4

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.