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?