# Kibana - show average of a numerical field **URL:** \ **Category:** Elasticsearch\ **Created:** [January 21, 2014, 8:58pm UTC](https://discuss.elastic.co/t/kibana-show-average-of-a-numerical-field/15348 "2014-01-21T20:58:32Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![Andrew\_Vine](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/andrew_vine/32/1778_2.png) [@Andrew\_Vine](https://discuss.elastic.co/u/Andrew_Vine)\ **Post date:** [January 21, 2014, 8:58pm UTC](https://discuss.elastic.co/t/kibana-show-average-of-a-numerical-field/15348/1 "2014-01-21T20:58:32Z")
Hi All! I hope this is the place to ask questions about Kibana. I am new to Kibana and so far I have enjoyed playing around with it. Could someone help me out with the following.. If I have a numeric value in a doc eg.. the age of a person. Is there some way in Kibana that I could show the average age for the results of my query? I know that elastic search has various stats functions available in facets/aggregations but I am not sure how to tie that into Kibana.. Any help would be appreciated! Regards Andrew -- You received this message because you are subscribed to the Google Groups "elasticsearch" group. To unsubscribe from this group and stop receiving emails from it, send an email to [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com). To view this discussion on the web visit [https://groups.google.com/d/msgid/elasticsearch/53319899-89cb-498b-9904-86047d4e5337%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/53319899-89cb-498b-9904-86047d4e5337%40googlegroups.com). For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out). ---
**Author:** ![Andrew\_Vine](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/andrew_vine/32/1778_2.png) [@Andrew\_Vine](https://discuss.elastic.co/u/Andrew_Vine)\ **Post date:** [January 22, 2014, 2:23pm UTC](https://discuss.elastic.co/t/kibana-show-average-of-a-numerical-field/15348/2 "2014-01-22T14:23:05Z")
Can anyone help me out here? On Tuesday, 21 January 2014 22:58:32 UTC+2, Andrew Vine wrote: > Hi All! > > I hope this is the place to ask questions about Kibana. > > I am new to Kibana and so far I have enjoyed playing around with it. > > Could someone help me out with the following.. > > If I have a numeric value in a doc eg.. the age of a person. > Is there some way in Kibana that I could show the average age for the > results of my query? > > I know that Elasticsearch has various stats functions available in > facets/aggregations but I am not sure how to tie that into Kibana.. > > Any help would be appreciated! > > Regards > Andrew -- You received this message because you are subscribed to the Google Groups "elasticsearch" group. To unsubscribe from this group and stop receiving emails from it, send an email to [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com). To view this discussion on the web visit [https://groups.google.com/d/msgid/elasticsearch/00c3b909-383b-4fbf-b018-a09b6b43e17d%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/00c3b909-383b-4fbf-b018-a09b6b43e17d%40googlegroups.com). For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out). ---
**Author:** ![Binh\_Ly](https://avatars.discourse-cdn.com/v4/letter/b/ce7236/32.png) [@Binh\_Ly](https://discuss.elastic.co/u/Binh_Ly)\ **Post date:** [January 22, 2014, 2:35pm UTC](https://discuss.elastic.co/t/kibana-show-average-of-a-numerical-field/15348/3 "2014-01-22T14:35:42Z")
Andrew, If you download the lates Kibana 3 as of today, you should be able to add a Stats panel to your dashboard which you can use to execute the Statistical facet on your ES data. On Wednesday, January 22, 2014 9:23:05 AM UTC-5, Andrew Vine wrote: > Can anyone help me out here? > > On Tuesday, 21 January 2014 22:58:32 UTC+2, Andrew Vine wrote: > > > Hi All! > > > > I hope this is the place to ask questions about Kibana. > > > > I am new to Kibana and so far I have enjoyed playing around with it. > > > > Could someone help me out with the following.. > > > > If I have a numeric value in a doc eg.. the age of a person. > > Is there some way in Kibana that I could show the average age for the > > results of my query? > > > > I know that Elasticsearch has various stats functions available in > > facets/aggregations but I am not sure how to tie that into Kibana.. > > > > Any help would be appreciated! > > > > Regards > > Andrew -- You received this message because you are subscribed to the Google Groups "elasticsearch" group. To unsubscribe from this group and stop receiving emails from it, send an email to [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com). To view this discussion on the web visit [https://groups.google.com/d/msgid/elasticsearch/8a2a9db9-99af-4ae7-9d8d-bde9ded92025%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/8a2a9db9-99af-4ae7-9d8d-bde9ded92025%40googlegroups.com). For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out). ---
**Author:** ![Andrew\_Vine](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/andrew_vine/32/1778_2.png) [@Andrew\_Vine](https://discuss.elastic.co/u/Andrew_Vine)\ **Post date:** [January 22, 2014, 2:44pm UTC](https://discuss.elastic.co/t/kibana-show-average-of-a-numerical-field/15348/4 "2014-01-22T14:44:42Z")
Thanks will try it out! On Wednesday, 22 January 2014 16:35:42 UTC+2, Binh Ly wrote: > Andrew, > > If you download the lates Kibana 3 as of today, you should be able to add > a Stats panel to your dashboard which you can use to execute the > Statistical facet on your ES data. > > On Wednesday, January 22, 2014 9:23:05 AM UTC-5, Andrew Vine wrote: > > > Can anyone help me out here? > > > > On Tuesday, 21 January 2014 22:58:32 UTC+2, Andrew Vine wrote: > > > > > Hi All! > > > > > > I hope this is the place to ask questions about Kibana. > > > > > > I am new to Kibana and so far I have enjoyed playing around with it. > > > > > > Could someone help me out with the following.. > > > > > > If I have a numeric value in a doc eg.. the age of a person. > > > Is there some way in Kibana that I could show the average age for the > > > results of my query? > > > > > > I know that Elasticsearch has various stats functions available in > > > facets/aggregations but I am not sure how to tie that into Kibana.. > > > > > > Any help would be appreciated! > > > > > > Regards > > > Andrew -- You received this message because you are subscribed to the Google Groups "elasticsearch" group. To unsubscribe from this group and stop receiving emails from it, send an email to [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com). To view this discussion on the web visit [https://groups.google.com/d/msgid/elasticsearch/5706c58b-990a-4d11-b00a-a012c106b05c%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/5706c58b-990a-4d11-b00a-a012c106b05c%40googlegroups.com). For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out). ---
**Author:** ![philg](https://avatars.discourse-cdn.com/v4/letter/p/a88e57/32.png) [@philg](https://discuss.elastic.co/u/philg)\ **Post date:** [January 24, 2014, 1:31pm UTC](https://discuss.elastic.co/t/kibana-show-average-of-a-numerical-field/15348/5 "2014-01-24T13:31:52Z")
hello Andrew did you succeed with the stats panel? i am testing it without success ☹ i have a duration field in records stored in ES ( type int) and i want to display the mean value .... but no success to display it .... philippe best regards ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [July 6, 2017, 1:54am UTC](https://discuss.elastic.co/t/kibana-show-average-of-a-numerical-field/15348/6 "2017-07-06T01:54:58Z")