Aggregate Elastic search query for multiple fields

Question

I'm writing an elastic search query the payload looks like

"userData": [ { "subject1":1234, "subject2":678 } ]

I have written a query which works perfectly fine if I want to get the avg of a single field

Query :

{ 
  "aggs": { 
    "student_data": { 
      "date_histogram": { 
        "field":"@timestamp",
        "calendar_interval":"minute"
      },
      "aggs": { 
        "marks_avg": { 
          "avg": { 
            "field":"subject1"
          }
        }
      }
    }
  }
}

What I want is to get the average of subject2 also.

somewhat like :

"avg": { 
    "field":"subject1",
    "field":"subject2"
 }

elixir · Accepted Answer · 2020-01-09 11:49:11Z

1

Query using multiple aggregations should work:

{ 
  "aggs": { 
    "student_data": { 
      "date_histogram": { 
        "field":"@timestamp",
        "calendar_interval":"minute"
      },
      "aggs": { 
        "subject1_avg": { 
          "avg": { 
            "field":"subject1"
          }
        },
        "subject2_avg": { 
          "avg": { 
            "field":"subject2"
          }
        }
      }
    }
  }
}

edited Jan 9, 2020 at 11:49

answered Jan 9, 2020 at 0:04

elixir

7621 gold badge9 silver badges25 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Harmeet Kaur Over a year ago

what if I needed the subject1 array also in the output

Collectives™ on Stack Overflow

Aggregate Elastic search query for multiple fields

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related