That's awesome. Thanks Ahmet!
On Wed, Aug 11, 2010 at 1:50 AM, Ahmet Arslan <iori...@yahoo.com> wrote: > > > --- On Wed, 8/11/10, Moazzam Khan <moazz...@gmail.com> wrote: > >> From: Moazzam Khan <moazz...@gmail.com> >> Subject: Re: Need help with facets >> To: solr-user@lucene.apache.org >> Date: Wednesday, August 11, 2010, 1:32 AM >> Thanks Ahmet that worked! >> >> Here's another issues I have : >> >> Like I said before, I have these fields in Solr documents >> >> FirstName >> LastName >> RecruitedDate >> VolumeDate (just added this in this email) >> VolumeDone (just added this in this email) >> >> >> Now I have to get sum of all VolumeDone (integer field) for >> this month >> by everyone, then take 25% of that number and get all >> people whose >> volume was more than that. Is there a way to do this? :D > > You need to execute two queries for that. Stats Component can give you sum. > q=VolumeDate:[NOW-1MONTH TO NOW]&stats=true&stats.field=VolumeDone > > http://wiki.apache.org/solr/StatsComponent > > Then second query > q=VolumeDate:[NOW-1MONTH TO NOW]&fq=VolumeDone:[sumComesAbove TO *] > > But you need to use tint type instead of int for VolumeDone, to range queries > work correctly. > > > >
