Stats Bucket Aggregation Usage

edit

Fluent DSL example

edit
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)
        )
    )
)
.StatsBucket("stats_commits_per_month", 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 StatsBucketAggregation("stats_commits_per_month", "projects_started_per_month>commits")

Example json output.

{
  "projects_started_per_month": {
    "date_histogram": {
      "field": "startedOn",
      "interval": "month"
    },
    "aggs": {
      "commits": {
        "sum": {
          "field": "numberOfCommits"
        }
      }
    }
  },
  "stats_commits_per_month": {
    "stats_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 commitsStats = response.Aggregations.StatsBucket("stats_commits_per_month");
commitsStats.Should().NotBeNull();
commitsStats.Average.Should().BeGreaterThan(0);
commitsStats.Max.Should().BeGreaterThan(0);
commitsStats.Min.Should().BeGreaterThan(0);
commitsStats.Count.Should().BeGreaterThan(0);
commitsStats.Sum.Should().BeGreaterThan(0);