I am wondering if there is a way to use aggregated values inside a query.
Say our data contains items and their price:
"id" : string
"name" : string
"price" : float
I want to do a query that returns the top items that have a price far from
the average price of items with the same name.
ID | Name | Price
1 | Chair | 5.99
2 | Chair | 5.99
3 | Chair | 59.99
4 | Desk | 61.00
5 | Desk | 60.00
6 | Desk | 59.99
The top response would be ID 3, since 59.99 is way higher than the average
price for a chair.
I believe I need to write a custom score script, but I am not sure how I
can get a reference to the average of items with the same name.
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to firstname.lastname@example.org.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/8069763d-9ce2-4dfc-afc5-6293c2171828%40googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.