Sum Bucket Aggregation Usage

Fluent DSL example

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 example

edit

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.

{
  "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 Responses

edit

response.ShouldBeValid();

var projectsPerMonth = response.Aggregations.DateHistogram("projects_started_per_month");
projectsPerMonth.Should().NotBeNull();
projectsPerMonth.Buckets.Should().NotBeNull();
projectsPerMonth.Buckets.Count.Should().BeGreaterThan(0);

var commitsSum = response.Aggregations.SumBucket("sum_of_commits");
commitsSum.Should().NotBeNull();
commitsSum.Value.Should().BeGreaterThan(0);

« Stats Bucket Aggregation Usage Matrix Aggregations »