You are viewing a plain text version of this content. The canonical link for it is here.
Posted to solr-user@lucene.apache.org by Raimon Bosch <ra...@gmail.com> on 2012/02/26 12:08:37 UTC
Time Stats
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
Posted by 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.
>>>
>>
>>
>
Re: Time Stats
Posted by 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
Posted by 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.
>