[jira] [Created] (SOLR-9395) Add ceil/floor bounding to stats calculations

["Doug Turnbull (JIRA)" <ji...@apache.org>]

Doug Turnbull created SOLR-9395:
-----------------------------------

             Summary: Add ceil/floor bounding to stats calculations
                 Key: SOLR-9395
                 URL: https://issues.apache.org/jira/browse/SOLR-9395
             Project: Solr
          Issue Type: Improvement
      Security Level: Public (Default Security Level. Issues are Public)
    Affects Versions: master (7.0)
            Reporter: Doug Turnbull
             Fix For: master (7.0)


In the pull request to be attached we add optional ceil and floor parameters to a field being computed via the stats component. This bounds the stats calculations to ceil to floor inclusive.

For example, let's say your searching over all the employees.

stats=true&stats.field=employee_age

But you want to focus on employees aged 18-60 for whatever reason. You can reissue this query as

stats=true&stats.field={!floor=18 ceil=60}employee_age

This limits the resulting stats calculations to 18-60 inclusive. This functionality also works on date fields (see test in PR).

Now one question might be, why not do this with a filter query? In many cases you don't necessarily want to filter these documents from the main search results. You just want to eliminate outliers from a specific stats calculation. For example, you search your employee database for "clerks." You still want to see all the clerks, even little 16 year old Timmy. But for this particular calculation you just want to focus on folks of traditional working age for whatever reason.

Some notes
- floor/ceil are only supported as local params.
- works for date and numeric values
- date math works!




--
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