# Division between two sum fields
**URL:** https://discuss.elastic.co/t/division-between-two-sum-fields/66373
**Category:** Elasticsearch
**Created:** [November 17, 2016, 11:38am UTC](https://discuss.elastic.co/t/division-between-two-sum-fields/66373 "2016-11-17T11:38:45Z")
**Posts on this page:** 9
**Page:** 1
### Author:  [@emanuele](https://discuss.elastic.co/u/emanuele)
#### Post date: [November 17, 2016, 11:38am UTC](https://discuss.elastic.co/t/division-between-two-sum-fields/66373/1 "2016-11-17T11:38:45Z")
Hi,
I need help to calculate the division between two sum. How can I do?
**something like**
"aggs" : {
"sum\_1" : { "sum" : { "field" : "flag\_barisolve" } },
"sum\_2" : { "sum" : { "field" : "flag\_anagrafe" } }
**"division" : {**
...
**"script" : {**
**"lang": "painless",**
**"inline": "sum\_1 / sum\_2"**
}
}
Thanks
---
### Author:  [@abdon](https://discuss.elastic.co/u/abdon)
#### Post date: [November 17, 2016, 5:19pm UTC](https://discuss.elastic.co/t/division-between-two-sum-fields/66373/2 "2016-11-17T17:19:18Z")
Take a look at [pipeline aggregations](https://www.elastic.co/guide/en/elasticsearch/reference/master/search-aggregations-pipeline.html). These are aggregations that work on the result of other aggregations. In your example, you could use a [bucket\_script](https://www.elastic.co/guide/en/elasticsearch/reference/master/search-aggregations-pipeline-bucket-script-aggregation.html) pipeline aggregation:
```
"aggs": {
"sum_1": {
"sum": {
"field": "flag_barisolve"
}
},
"sum_2": {
"sum": {
"field": "flag_anagrafe"
}
},
"division": {
"bucket_script": {
"buckets_path": {
"my_var1": "sum_1",
"my_var2": "sum_2"
},
"script": "params.my_var1 / params.my_var2"
}
}
}
```
This does not work for root-level aggregations. So, the `sum_1`, `sum_2` and `division` aggregations must be child aggregations inside a multi-bucket aggregation.
---
### Author:  [@emanuele](https://discuss.elastic.co/u/emanuele)
#### Post date: [November 18, 2016, 10:50am UTC](https://discuss.elastic.co/t/division-between-two-sum-fields/66373/3 "2016-11-18T10:50:10Z")
Hi abdon,
thanks a lot for your support.
With the Sense client query is correct.
How to display the result in a visualize of Kibana (ex. data table)?
It's off topic?
Thanks
---
### Author:  [@abdon](https://discuss.elastic.co/u/abdon)
#### Post date: [November 18, 2016, 10:52am UTC](https://discuss.elastic.co/t/division-between-two-sum-fields/66373/4 "2016-11-18T10:52:34Z")
Take a look at [Timelion](https://www.elastic.co/blog/timelion-timeline). It will allow you to do things like this in Kibana visualizations.
---
### Author:  [@emanuele](https://discuss.elastic.co/u/emanuele)
#### Post date: [November 18, 2016, 11:39am UTC](https://discuss.elastic.co/t/division-between-two-sum-fields/66373/5 "2016-11-18T11:39:37Z")
It's possible visulize output, root aggregations and division, with data table or bar chart?
Thanks
---
### Author:  [@abdon](https://discuss.elastic.co/u/abdon)
#### Post date: [November 18, 2016, 12:48pm UTC](https://discuss.elastic.co/t/division-between-two-sum-fields/66373/6 "2016-11-18T12:48:41Z")
All of that should be possible, with the exception of the data table. I don't think Timelion supports data tables.
Take a look at the [built-in tutorial](https://www.elastic.co/guide/en/kibana/current/timelion-createviz.html) to see what it can do. Timelion's syntax is very different from the regular aggregations, so there is a bit of a learning curve.
---
### Author:  [@emanuele](https://discuss.elastic.co/u/emanuele)
#### Post date: [November 18, 2016, 3:33pm UTC](https://discuss.elastic.co/t/division-between-two-sum-fields/66373/7 "2016-11-18T15:33:14Z")
I want use Kibana's visualize like data table, vertical bar chart, pie chart, ecc...
It's possible with the pipeline aggregations like above query?
Thanks
---
### Author:  [@abdon](https://discuss.elastic.co/u/abdon)
#### Post date: [November 18, 2016, 3:53pm UTC](https://discuss.elastic.co/t/division-between-two-sum-fields/66373/8 "2016-11-18T15:53:19Z")
No, that's currently not supported. The only way to do something similar to that is with Timelion.
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [December 16, 2016, 3:53pm UTC](https://discuss.elastic.co/t/division-between-two-sum-fields/66373/9 "2016-12-16T15:53:40Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.