I'm trying to count active users for the service. We consider a user active if he did more than X actions in a span of a particular time period. Count will do fine, the list of user ids is not necessary.
I couldn't find the suitable query in Elasticsearch, not just Graphana. Terms aggregation can't do that because it only return top 10 buckets. Composite and cardinality aggregation don't allow minimum document count.
Value count and top hits don't have the necessary data and/or filters. Regular and extended stats work only with numeric fields.
What am I missing?
Asked
Active
Viewed 173 times
0
chester89
- 8,328
- 17
- 68
- 113
-
The `terms` aggregation can return more than 10 buckets if desired – Val Aug 07 '18 at 09:29
-
@val I need the count, not the data itself. can I do that with terms? – chester89 Aug 07 '18 at 09:50
-
@Val didn't think so – chester89 Aug 12 '18 at 20:38
1 Answers
0
There's an answer from a person who contributes to Elasticsearch. Basically he says there's no built-in query to do this
P.S. It's my understanding that Elasticsearch is not the solution to this type of queries. Redis and/or Druid might be a better fit
chester89
- 8,328
- 17
- 68
- 113