# Comparing query aggregation values
**URL:** https://discuss.elastic.co/t/comparing-query-aggregation-values/82313
**Category:** Elasticsearch
**Created:** [April 13, 2017, 2:26pm UTC](https://discuss.elastic.co/t/comparing-query-aggregation-values/82313 "2017-04-13T14:26:53Z")
**Posts on this page:** 6
**Page:** 1
### Author:  [@korsdecaying](https://discuss.elastic.co/u/korsdecaying)
#### Post date: [April 13, 2017, 2:26pm UTC](https://discuss.elastic.co/t/comparing-query-aggregation-values/82313/1 "2017-04-13T14:26:53Z")
Is it possible using elasticsearch to compare the results in the columns of the aggregated query. That is, the aggregation values 5 and 6.
Using the alert compare condition.
Using the alert compare condition. If possible how to form a query !?
```
"aggs": {
"5": {
"sum": {
"field": "bytes_in"
}
},
"6": {
"sum": {
"field": "bytes_out"
}
```
}
At the moment I see solutions to this issue using the Java API, but for this I have to go through a cycle of all 6 aggregations in order to compile a table of dependencies of all 6 aggregators (like a kibana displays this in the table), is there a way to get values for 6 aggregators at once in the form Array of values.
For example how Terms works. getKeyAsString() ,getDocCount()
The first number receives the key. Its second meaning. And here the first number gets the key a of the values for it 5 in the form of aggregations on the first point
Only for 6 aggregations
How to most easily do this
---
### Author:  [@thomasneirynck](https://discuss.elastic.co/u/thomasneirynck)
#### Post date: [April 13, 2017, 4:55pm UTC](https://discuss.elastic.co/t/comparing-query-aggregation-values/82313/2 "2017-04-13T16:55:49Z")
hi @korsdecaying,
what do you mean with compare? e.g. You want to substract these values to get the difference? If so, I think you'll have to do that on the application level.
Also, it seems like you may also want to move this question to the Elasticsearch forum, unless this is related to something Xpack specific.
---
### Author:  [@korsdecaying](https://discuss.elastic.co/u/korsdecaying)
#### Post date: [April 13, 2017, 9:01pm UTC](https://discuss.elastic.co/t/comparing-query-aggregation-values/82313/3 "2017-04-13T21:01:49Z")
Hi,
I need to compare the values of two columns, that is, compare them with each other, whether they are equal or not. And compare them with certain set values. I thought I'd use alerting for this, so I wrote this thread.
---
### Author:  [@korsdecaying](https://discuss.elastic.co/u/korsdecaying)
#### Post date: [April 13, 2017, 9:17pm UTC](https://discuss.elastic.co/t/comparing-query-aggregation-values/82313/4 "2017-04-13T21:17:27Z")
What do you understand by the level of applications !?Unload data for example using the Java API and analyze !?
---
### Author:  [@thomasneirynck](https://discuss.elastic.co/u/thomasneirynck)
#### Post date: [April 18, 2017, 8:11pm UTC](https://discuss.elastic.co/t/comparing-query-aggregation-values/82313/5 "2017-04-18T20:11:51Z")
Hi @korsdecaying,
yes, with "application" I mean doing this in your client that is querying Elasticsearch. If this is a Java-program, you could indeed use the Java API.
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [May 16, 2017, 8:12pm UTC](https://discuss.elastic.co/t/comparing-query-aggregation-values/82313/6 "2017-05-16T20:12:51Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.