The answer is so easy. Just need to create an index with each visit. In this way I could use faceted date search to create time statistics.
"flats for rent new york" at 1/12/2011 => bounce_rate=48.6% "flats for rent new york" at 1/1/2012 => bounce_rate=49.7% "flats for rent new york" at 1/2/2012 => bounce_rate=46.4% date:[1/12/2011 - 1/1/2012] "flats for rent new york" at 1/12/2011 => bounce_rate=48.6% "flats for rent new york" at 1/1/2012 => bounce_rate=49.7% mean=49.15% date:[1/1/2012 - 1/2/2012] "flats for rent new york" at 1/1/2012 => bounce_rate=49.7% "flats for rent new york" at 1/2/2012 => bounce_rate=46.4% mean=49.05% With my initial approach I would save some disk and memory space. I'm still wondering if it is possible. 2012/2/27 Raimon Bosch <[email protected]> > > Anyone up to provide an answer? > > The idea is have a kind of CustomInteger compound by an array of > timestamps. The value shown in this field would be based in the date range > that you're sending. > > Biggest problem will be that this field would be in all the documents on > your solr index so you need to calculate this number in real-time. > > > 2012/2/26 Raimon Bosch <[email protected]> > >> >> Hi, >> >> Today I was playing with StatsComponent just to extract some statistics >> from my index. I'm using a solr index to store user searches. Basically >> what I did is to aggregate data from accesslog into my solr index. So now I >> can see average bounce rate for a group of user searches and see which ones >> are performing better in google. >> >> Now I would like to see the evolution of this stats throught time. For >> that I would need to have a field with a different values throught time i.e. >> >> "flats for rent new york" at 1/12/2011 => bounce_rate=48.6% >> "flats for rent new york" at 1/1/2012 => bounce_rate=49.7% >> "flats for rent new york" at 1/2/2012 => bounce_rate=46.4% >> >> There is any solr type field that could fit to solve this? >> >> Thanks in advance, >> Raimon Bosch. >> > >
