[jira] [Created] (SOLR-8350) Filters on Aggregate Data Subfacets

["Pablo Anzorena (JIRA)" <ji...@apache.org>]

Pablo Anzorena created SOLR-8350:
------------------------------------

             Summary: Filters on Aggregate Data Subfacets
                 Key: SOLR-8350
                 URL: https://issues.apache.org/jira/browse/SOLR-8350
             Project: Solr
          Issue Type: Improvement
            Reporter: Pablo Anzorena
            Priority: Minor


Hey, I got an idea that I'm pretty sure it is not supported.

Let's assume the schema in solr has at least the following fields:
transaction_id,
product_id,
company,
price

Let's imagine we are Amazon, and we want to analyze the top 10 companies that have sold more than US$ 100,000,000. 
Nowadays, the filters are only applied to each solr record and not over aggregated data, so there is no way to achieve this (at least natively) from solr.
It is more like a BI Tool capability.

It would be nice to have this feature in the subfacets module, for example:
companies: {
  type: terms,
  field: company,
  limit: 10,
  offset: 0,
  sort: "price desc",
  facet: { price: "sum(price)"},
  aggfilter:"price > 100,000,000"
  }
}

And it would be even better to support logic expressions in the "aggfilter" field. For example:
companies: {
  type: terms,
  field: company,
  limit: 10,
  offset: 0,
  sort: "price desc",
  facet: { price: "sum(price)"},
  aggfilter:"price > 100,000,000 OR other_measure < 100"
  }
}




--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@lucene.apache.org
For additional commands, e-mail: dev-help@lucene.apache.org