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,"docs":[]

  },

  "facet_counts":{

    "facet_queries":{},

    "facet_fields":{},

    "facet_dates":{},

    "facet_ranges":{},

    "facet_intervals":{},

    "facet_heatmaps":{}},

  "facets":{

    "count":0}}

 

 
> 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
manufacturers, it can last.
>

> Maybe you can try json faceting. Something like (url style):

>

> …&json.facet={sumByManu:{terms:{field:manufacturer,facet:{sum:”sum(price)”}}}}

>

> HTH,

> Emir

> --

> Monitoring - Log Management - Alerting - Anomaly Detection

> Solr & Elasticsearch Consulting Support Training - http://sematext.com/

>

>

>

>> On 12 Nov 2017, at 19:09, [EMAIL PROTECTED] wrote:

>>

>>

>>

>>

>> I have documents in solr that look like this:

>> {

>> "id": "acme-1",

>> "manufacturer": "acme",

>> "product_name": "Foo",

>> "price": 3.4

>> }

>>

>> There are about

>> 150,000 manufacturers, each of which have between 20,000 and 1,000,000 products.

>> I'd like to return the sum of all prices that are in the range [100, 200], faceted by manufacturer. In other words, for each manufacturer, sum the prices of all products for that manufacturer,

>> and return the sum and the manufacturer name. For example:

>> [

>> {

>> "manufacturer": "acme",

>> "sum": 150.5

>> },

>> {

>> "manufacturer": "Johnson,

>> Inc.",

>> "sum": 167.0

>> },

>> ...

>> ]

>>

>> I tried this:

>> q=*:*&rows=0&stats=true&stats.field={!tag=piv1 sum=true}price&facet=true&facet.pivot={!stats=piv1}manufacturer

>> which "works" on a test

>> subset of 1,000 manufacturers. However, there are two problems:

>> 1) This query returns all the manufacturers, so I have to iterate over the entire response object to extract the ones I want.

>> 2) The query on the whole data set takes more than 600 seconds to return, which doesn't fit

>> our target response time

>>

>> How can I perform this query?

>> We're using solr version 5.5.5.

>>

>>

>>

>> Thanks,

>> Chris

>>

>

>
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB