Get counts of new users per day

Elastic Stack Elasticsearch
1

I'm working with the twitter river data. Trying to figure out how to
construct a query that would let me generate a count of all new users
within a given time period, where in this case, new means "user has not had
a post captured before the start of this query window".
So basically, I want to get a facet result of user.screen_name where a name
will be dropped from the facet entirely if an instance of it occurs outside
a specified time range.
I've got no idea where to start. Anyone have any pointers?

--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/f1166ce3-f529-4412-b721-37f3e1cfcc79%40googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

1 Like
2

You can't really do that, not without doing some pre-calculations like
creating a user document for every user that has a tweet in the system or
similar.

--

Itamar Syn-Hershko
http://code972.com | @synhershko https://twitter.com/synhershko
Freelance Developer & Consultant
Author of RavenDB in Action http://manning.com/synhershko/

On Fri, Jan 24, 2014 at 2:09 AM, Josh Harrison hijakk@gmail.com wrote:

I'm working with the twitter river data. Trying to figure out how to
construct a query that would let me generate a count of all new users
within a given time period, where in this case, new means "user has not had
a post captured before the start of this query window".
So basically, I want to get a facet result of user.screen_name where a
name will be dropped from the facet entirely if an instance of it occurs
outside a specified time range.
I've got no idea where to start. Anyone have any pointers?

--
You received this message because you are subscribed to the Google Groups
"elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to elasticsearch+unsubscribe@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/elasticsearch/f1166ce3-f529-4412-b721-37f3e1cfcc79%40googlegroups.com
.
For more options, visit https://groups.google.com/groups/opt_out.

--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/CAHTr4ZvkqwkRbYLCS%3DHv7%3DuV%2BW08iFLDENWu%2BSuGZYjePtv7EA%40mail.gmail.com.
For more options, visit https://groups.google.com/groups/opt_out.

3

I got almost there, I guess.. so close yet so far..


(source was http://stackoverflow.com/questions/34700689/how-to-build-date-histogram-query-which-counts-new-properties)

Bear in mind that this particular query is not very performant