Hello, I'm using kibana 4.4.1 and in elasticsearch I store the status of PC, only when PC status is changed (open, closed, warings, etc) My data into Elasticsearch looks like: { "status_id":1 , "pc":"lpt001" , "date":"2016-10-25T17:49:00Z" } { "status_id":3 , "pc":"lpt001" , "date":"2016-10-25T1…

If I understand correctly, you want the latest entry for each PC. This can be achieved with the following query: { "query": { "match_all": { } }, "aggs" : { "pcstatus" : { "terms" : { "field" : "pc" }, "aggs": { "…

Discuss the Elastic Stack

How to aggregate data by an field?

Elastic Stack Elasticsearch

Topic		Replies	Views
How to get only newest records by name? Kibana	7	7966	July 6, 2017
Kibana data table with the aggregations only on the latest records Kibana	3	1297	February 4, 2019
Aggregation of aggregation Elasticsearch	2	208	December 5, 2023
How to get latest entry for all users Kibana	4	5119	July 6, 2017
A query to match most recent and then bucketing the results Elasticsearch	1	526	July 5, 2017

Elasticsearch is a trademark of Elasticsearch BV, registered in the U.S. and in other countries
Trademarks
Terms
Privacy
Brand
Code of Conduct

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.

How to aggregate data by an field?

Related topics