Aggregating doc_count


(no jihun) #1

hi.

is it possible sub aggregate with parent terms aggregation's doc_count result?

I mean....

there are user visit logs in my index.
and I wanna know how sum of visiting count distributed.

consider this rows.
...................
kim
kim
kim
jane
jane
michael
michael
...................

in this case my expected result is
....................
3:1 <--- 1 user visited 3 times
2:2 <--- 2 user visited 2 times

it seems not easy..

thanks in advance :slight_smile:

--
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/6f62f12f-4823-41cc-89f9-3b54c9b4f923%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


#2

I have a similar problem. Do you have any insights so far?


(Mark Harwood) #3

These sorts of person-behaviour questions on event-centric indexes are killers. See the reasons why and the entity-centric index solution here: https://youtu.be/yBf7oeJKH2Y


(system) #4