Re: Time Stats

[Raimon Bosch <ra...@gmail.com>]

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 <ra...@gmail.com>

>
> 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 <ra...@gmail.com>
>
>>
>> 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.
>>
>
>

Re: Time Stats

[Raimon Bosch <ra...@gmail.com>]

second mean is 48.05%...

2012/3/9 Raimon Bosch <ra...@gmail.com>

> 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 <ra...@gmail.com>
>
>>
>> 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 <ra...@gmail.com>
>>
>>>
>>> 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.
>>>
>>
>>
>