Sum aggregation with results from other aggregations?
Is it possible to create an aggregation where I can do a sum on the results of a sub bucket?
I'm working on twitter data. In this data I have a bunch of retweets of different users.
Say that user A has 10 tweets that are retweeted a hundred times in my dataset. I want to find the maximum retweet_count for each individual tweet, and then I want to find the sum of all of those maximums from an individual user.
This is the base query structure I'm working with: