I wanna do a search that returns registers that only have one ocurrency (group by) and this value should be 0. In exemple above it will be register 3 {category:2,value:0}.
You cant really search for "group by"/aggregations ... you'll have to create a data table visualization.
You can then order ascending by die occurrences, but you cant filter on it.
This is actually an elasticsearch limitation - you cant reduce a result set based on aggregated values.
Elasticsearch 2 should support such operations with pipeline aggregations , but not sure when Kibana will introduce support for such functions.
Apache, Apache Lucene, Apache Hadoop, Hadoop, HDFS and the yellow elephant
logo are trademarks of the
Apache Software Foundation
in the United States and/or other countries.