rashidkpc/Kibana — Issue #16: Feature request: Charting numeric statistical facet
Author: azulcactus
Created: 2012-02-24 19:29:20+00:00
State: open

I'm capturing application logs in my logstash which contain execution time. The statistical facet provides min, max, average and more values when using a numeric field in elasticsearch. It would be nice to add a new option in addition to trend and score for numerical fields which would somehow chart this data.

In this case it may not be a time chart but just a simple table with the statistical values, or it could take an increment period so you could ask for a statistical graph of averages broken down in 10 minute increments.

Here is the example elasticsearch query if I have a custom field defined of "time" (note: this field must be defined as a numeric type in the elasticsearch index).

POST http://server:9200/_all/_search {"query" : { "text" : {"@message" : "the_search_filter"} }, "facets" : {"time_facet" : { "statistical" : {"field" : "time"} }}}

Results:
{ "took" : 2511, "facets" : { "time_facet" : { "_type" : "statistical", "count" : 2419946, "total" : 1531886.968960829, "min" : 0.0, "max" : 19348.49609375, "mean" : 0.6330252695559443, "sum_of_squares" : 8.470505106146345E8, "variance" : 349.62796172029414, "std_deviation" : 18.698341148890567 } } }