When sorting by (an integer) price field I need prices under 1
standard deviation from the mean of the current result set to be
pushed to the end of the list.

For example with these values:

0, 20, 40, 100, 2000, 2000, 2000, 2000, 2000, 3000, 3000, 3000, 3000,
3000, 4000, 5000, 5000, 9000

Mean ~ 2675, StdDev ~ 2211, Cutoff = 2675-2211 = 464

So all prices under 464 will be pushed to the end of the list and the
resulting order would be:

ascending: 2000, 2000, 2000, 2000, 2000, 3000, 3000, 3000, 3000, 3000,
4000, 5000, 5000, 9000, 0, 20, 40, 100
descending: 9000, 5000, 5000, 4000, 3000, 3000, 3000, 3000, 3000,
2000, 2000, 2000, 2000, 2000, 0, 20, 40, 100

Is this possible with in a single solr query?

Reply via email to