Re: Limiting by range of sum across documents

2017-11-15 Thread chris
Emir, It certainly seems like I'll need to use streaming expressions. Thanks for your help! Chris > Hi Chris, > I misunderstood your requirement. I am not aware of some facet result > filtering feature. What you could do is sort facet results by sum and load > page by page but that does not

Re: Limiting by range of sum across documents

2017-11-14 Thread Emir Arnautović
Hi Chris, I misunderstood your requirement. I am not aware of some facet result filtering feature. What you could do is sort facet results by sum and load page by page but that does not sound like a good solution. Did you try using streaming expressions - I don’t have much experience with this f

Re: Limiting by range of sum across documents

2017-11-14 Thread Erick Erickson
Maybe pivot facets and stats? See: https://lucene.apache.org/solr/guide/6_6/faceting.html On Tue, Nov 14, 2017 at 7:51 AM, wrote: > > > > I'm not looking for products where the price is in the range [100, 200]. > I'm looking for manufacturers for which the sum of the prices of all of their > pr

Re: Limiting by range of sum across documents

2017-11-14 Thread chris
I'm not looking for products where the price is in the range [100, 200]. I'm looking for manufacturers for which the sum of the prices of all of their products is in the range [100, 200]. � > Hi Chris, > > I assumed that you apply some sort of fq=price:[100 TO 200] to focus on > wanted pro

Re: Limiting by range of sum across documents

2017-11-13 Thread Emir Arnautović
Hi Chris, I assumed that you apply some sort of fq=price:[100 TO 200] to focus on wanted products. Can you share full json faceting request - numFound:0 suggest that something is completely wrong. Thanks, Emir -- Monitoring - Log Management - Alerting - Anomaly Detection Solr & Elasticsearch C

Re: Limiting by range of sum across documents

2017-11-13 Thread chris
� Hi Emir, I can't apply filters to the original query because I don't know in advance which filters will meet the criterion I'm looking for.� Unless I'm missing something obvious.�� � I tried the JSON facet you suggested but received "response":{"numFound":0,"start":0,"maxScore":0.0,

Re: Limiting by range of sum across documents

2017-11-13 Thread Emir Arnautović
Hi Chris, You mention it returns all manufacturers? Even after you apply filters (don’t see filter in your example)? You can control how many facets are returned with facet.limit and you can use face.pivot.mincount to determine how many facets are returned. If you calculate sum on all manufactur