Sum Bucket Aggregation Usageedit
Fluent DSL Exampleedit
s => s
.Size(0)
.Aggregations(a => a
.DateHistogram("projects_started_per_month", dh => dh
.Field(p => p.StartedOn)
.Interval(DateInterval.Month)
.Aggregations(aa => aa
.Sum("commits", sm => sm
.Field(p => p.NumberOfCommits)
)
)
)
.SumBucket("sum_of_commits", aaa => aaa
.BucketsPath("projects_started_per_month>commits")
)
)Object Initializer Syntax Exampleedit
new SearchRequest<Project>()
{
Size = 0,
Aggregations = new DateHistogramAggregation("projects_started_per_month")
{
Field = "startedOn",
Interval = DateInterval.Month,
Aggregations = new SumAggregation("commits", "numberOfCommits")
}
&& new SumBucketAggregation("sum_of_commits", "projects_started_per_month>commits")
}Example json output.
{
"size": 0,
"aggs": {
"projects_started_per_month": {
"date_histogram": {
"field": "startedOn",
"interval": "month"
},
"aggs": {
"commits": {
"sum": {
"field": "numberOfCommits"
}
}
}
},
"sum_of_commits": {
"sum_bucket": {
"buckets_path": "projects_started_per_month>commits"
}
}
}
}
Handling Responsesedit
response.IsValid.Should().BeTrue();
var projectsPerMonth = response.Aggs.DateHistogram("projects_started_per_month");
projectsPerMonth.Should().NotBeNull();
projectsPerMonth.Buckets.Should().NotBeNull();
projectsPerMonth.Buckets.Count.Should().BeGreaterThan(0);
var commitsSum = response.Aggs.SumBucket("sum_of_commits");
commitsSum.Should().NotBeNull();
commitsSum.Value.Should().BeGreaterThan(0);