Is it possible to get average of amount between two values(min and max
specified) in solr JSON Facet API results?
Ex: here is the query i need to apply in Solr
SELECT STATE, AVG(AMOUNT) from Table group by STATE having AVG(AMOUNT) >
3000 AND AVG(AMOUNT) < 5000
currently i am getting avg amounts using following query in Solr. I would
like to add min and max limits to get only average values between min and
max values.
{ "e_name": { "type": "terms", "field": "STATE", "mincount": 1, "offset": 0,
"limit": 10, "sort": { "AMOUNT": "desc" }, "facet": { "AMOUNT":
"avg(AMOUNT)" } } }
--
View this message in context:
http://lucene.472066.n3.nabble.com/Solr-Json-APi-aggregation-specifiy-min-and-max-values-tp4324342.html
Sent from the Solr - User mailing list archive at Nabble.com.
