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)” } } }