Hi , I need to get all clients under a partnerId & since there would be many clients I need to group the clients by clientId,latest reportDate and run some aggregations . Index data is like below - [ { partnerId: "PID1234", clientId: "c1234", reportDate: "2022-02-01" }, { partnerId: "…

Mark_Harwood (Mark Harwood) April 16, 2022, 11:10am 3

It’s a fairly common requirement to do analysis only on the last known state of an entity.
See here for solutions.

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 group docs by latest doc and run aggregation on the group in elastic search?