I'd like to use aggregation outputs as an input to filtering for documents in one query. For example, I'd like to get sales documents in the last 24 hours where sale amount is greater than the average of sale amounts in the last 3 months before the current month (e.g. Feb-Apr if we're in May). The …

How to get documents in Elasticsearch based on aggregation output values?

warkolm (Mark Walkom) May 23, 2019, 10:29pm 2

You can't at the moment sorry!
You will need to run the agg to get the average, then run a separate query to get the docs that match the values.

Topic		Replies	Views
Joining aggregation results to the original documents Elasticsearch	5	422	October 4, 2021
How to get documents based aggregated condition Elasticsearch	4	939	July 5, 2017
How to put the aggregation value as query condition Elasticsearch	3	2040	July 6, 2017
Average doc_count per hour? Elasticsearch	3	1561	July 6, 2017
Holding aggregation results in parameters Elasticsearch	3	371	July 6, 2017