# Kibana stats panel **URL:** \ **Category:** Elasticsearch\ **Created:** [March 28, 2014, 2:17pm UTC](https://discuss.elastic.co/t/kibana-stats-panel/16680 "2014-03-28T14:17:57Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![Jeff\_Klug](https://avatars.discourse-cdn.com/v4/letter/j/22d042/32.png) [@Jeff\_Klug](https://discuss.elastic.co/u/Jeff_Klug)\ **Post date:** [March 28, 2014, 2:17pm UTC](https://discuss.elastic.co/t/kibana-stats-panel/16680/1 "2014-03-28T14:17:57Z")
The stats panel doesn't seem to work for me at all. I want it to calculate the mean of a numeric field, but it just prints out 0. No errors. Anybody got this working? JK -- 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/28062345-6dbf-42f5-94af-bb67daabc687%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/28062345-6dbf-42f5-94af-bb67daabc687%40googlegroups.com). For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout). ---
**Author:** ![Binh\_Ly\_2](https://avatars.discourse-cdn.com/v4/letter/b/d07c76/32.png) [@Binh\_Ly\_2](https://discuss.elastic.co/u/Binh_Ly_2)\ **Post date:** [March 28, 2014, 2:49pm UTC](https://discuss.elastic.co/t/kibana-stats-panel/16680/2 "2014-03-28T14:49:40Z")
By any chance, is it possible that in the mapping, the field is not numeric (like maybe a string)? -- 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/715bedf8-043d-4a4e-8f49-7e03cdef1398%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/715bedf8-043d-4a4e-8f49-7e03cdef1398%40googlegroups.com). For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout). ---
**Author:** ![Jeff\_Klug](https://avatars.discourse-cdn.com/v4/letter/j/22d042/32.png) [@Jeff\_Klug](https://discuss.elastic.co/u/Jeff_Klug)\ **Post date:** [March 28, 2014, 3:18pm UTC](https://discuss.elastic.co/t/kibana-stats-panel/16680/3 "2014-03-28T15:18:53Z")
using logstash grok, match pulls the field as %{BASE16FLOAT:avgt} json pulled by kibana: { "\_index": "logstash-2014.03.27", "\_type": "jobended", "\_id": "mn8h50n8SF693JLDZdBx8A", "\_source": { ... "avgt": "1.75", ... } } trying to get stats to find mean of avgt JK On Fri, Mar 28, 2014 at 10:49 AM, Binh Ly [binhly\_es@yahoo.com](mailto:binhly_es@yahoo.com) wrote: > By any chance, is it possible that in the mapping, the field is not > numeric (like maybe a string)? > > -- > You received this message because you are subscribed to a topic in the > Google Groups "elasticsearch" group. > To unsubscribe from this topic, visit > [https://groups.google.com/d/topic/elasticsearch/gOG7T5-Hcag/unsubscribe](https://groups.google.com/d/topic/elasticsearch/gOG7T5-Hcag/unsubscribe). > To unsubscribe from this group and all its topics, 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/715bedf8-043d-4a4e-8f49-7e03cdef1398%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/715bedf8-043d-4a4e-8f49-7e03cdef1398%40googlegroups.com)[https://groups.google.com/d/msgid/elasticsearch/715bedf8-043d-4a4e-8f49-7e03cdef1398%40googlegroups.com?utm\_medium=email&utm\_source=footer](https://groups.google.com/d/msgid/elasticsearch/715bedf8-043d-4a4e-8f49-7e03cdef1398%40googlegroups.com?utm_medium=email&utm_source=footer) > . > > For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout). -- 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/CAJ33\_N-BvB\_dcB%2BT%2B9bGw2jxZ4LxBPyzpfk%3DjZ1wLXy%3D2QL7XA%40mail.gmail.com](https://groups.google.com/d/msgid/elasticsearch/CAJ33_N-BvB_dcB%2BT%2B9bGw2jxZ4LxBPyzpfk%3DjZ1wLXy%3D2QL7XA%40mail.gmail.com). For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout). ---
**Author:** ![Binh\_Ly\_2](https://avatars.discourse-cdn.com/v4/letter/b/d07c76/32.png) [@Binh\_Ly\_2](https://discuss.elastic.co/u/Binh_Ly_2)\ **Post date:** [March 28, 2014, 4:11pm UTC](https://discuss.elastic.co/t/kibana-stats-panel/16680/4 "2014-03-28T16:11:28Z")
Yup, you probably need to convert the type of that field: [http://logstash.net/docs/1.4.0/filters/mutate#convert](http://logstash.net/docs/1.4.0/filters/mutate#convert) mutate convert it to float and try it again. -- 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/e49fa51a-0263-4f29-846b-f72bd634e03e%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/e49fa51a-0263-4f29-846b-f72bd634e03e%40googlegroups.com). For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout). ---
**Author:** ![Jeff\_Klug](https://avatars.discourse-cdn.com/v4/letter/j/22d042/32.png) [@Jeff\_Klug](https://discuss.elastic.co/u/Jeff_Klug)\ **Post date:** [March 28, 2014, 4:46pm UTC](https://discuss.elastic.co/t/kibana-stats-panel/16680/5 "2014-03-28T16:46:46Z")
yup. mutated and working now. Thanks! On Fri, Mar 28, 2014 at 12:11 PM, Binh Ly [binhly\_es@yahoo.com](mailto:binhly_es@yahoo.com) wrote: > Yup, you probably need to convert the type of that field: > > [Mutate filter plugin | Logstash Reference [8.11] | Elastic](http://logstash.net/docs/1.4.0/filters/mutate#convert) > > mutate convert it to float and try it again. > > -- > You received this message because you are subscribed to a topic in the > Google Groups "elasticsearch" group. > To unsubscribe from this topic, visit > [https://groups.google.com/d/topic/elasticsearch/gOG7T5-Hcag/unsubscribe](https://groups.google.com/d/topic/elasticsearch/gOG7T5-Hcag/unsubscribe). > To unsubscribe from this group and all its topics, 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/e49fa51a-0263-4f29-846b-f72bd634e03e%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/e49fa51a-0263-4f29-846b-f72bd634e03e%40googlegroups.com)[https://groups.google.com/d/msgid/elasticsearch/e49fa51a-0263-4f29-846b-f72bd634e03e%40googlegroups.com?utm\_medium=email&utm\_source=footer](https://groups.google.com/d/msgid/elasticsearch/e49fa51a-0263-4f29-846b-f72bd634e03e%40googlegroups.com?utm_medium=email&utm_source=footer) > . > > For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout). -- 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/CAJ33\_N\_Bf74kJQnrF0QaRMVgEpddA4is4EqrMTWiDnR3RoMk\_g%40mail.gmail.com](https://groups.google.com/d/msgid/elasticsearch/CAJ33_N_Bf74kJQnrF0QaRMVgEpddA4is4EqrMTWiDnR3RoMk_g%40mail.gmail.com). For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout). ---
**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:39am UTC](https://discuss.elastic.co/t/kibana-stats-panel/16680/6 "2017-07-06T01:39:50Z")