# Is it possible to divide value in one column with value in another column, in Kibana table visualization? **URL:** \ **Category:** Kibana\ **Created:** [April 11, 2017, 11:41am UTC](https://discuss.elastic.co/t/is-it-possible-to-divide-value-in-one-column-with-value-in-another-column-in-kibana-table-visualization/81973 "2017-04-11T11:41:51Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![elasticheart](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/elasticheart/32/65189_2.png) [@elasticheart](https://discuss.elastic.co/u/elasticheart)\ **Post date:** [April 11, 2017, 11:41am UTC](https://discuss.elastic.co/t/is-it-possible-to-divide-value-in-one-column-with-value-in-another-column-in-kibana-table-visualization/81973/1 "2017-04-11T11:41:51Z")
Hi, I am using ELK GA 5.0.0. I have managed to create a table like below; ``` --------------------------------------------- | User_Name | Sum_of_ColA | Sum_of_ColB | -------------+---------------+--------------- | UserA | 20 | 10 | | UserB | 15 | 3 | --------------------------------------------- ``` I have 2 fields in my index ColA and ColB.The 2 columns in my table shows sum of values in those fields. I have splitted rows using User\_Name field. I want to create another column, which is `Sum_of_ColA/Sum_of_ColB` like below; ``` ------------------------------------------------------- | User_Name | Sum_of_ColA | Sum_of_ColB | Ratio | -------------+---------------+--------------+---------- | UserA | 20 | 10 | 2 | | UserB | 15 | 3 | 5 | ------------------------------------------------------- ``` Is this possible? Thanks in advance.. ---
**Author:** ![Prashant\_Agrawal](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/prashant_agrawal/32/74982_2.png) [@Prashant\_Agrawal](https://discuss.elastic.co/u/Prashant_Agrawal)\ **Post date:** [April 11, 2017, 11:47am UTC](https://discuss.elastic.co/t/is-it-possible-to-divide-value-in-one-column-with-value-in-another-column-in-kibana-table-visualization/81973/2 "2017-04-11T11:47:45Z")
You can use scripted fields to do so , this is how you can create the same ratio = doc['Sum\_of\_ColA'].value / doc['Sum\_of\_ColB'].value Moreover you can refer below docs: [https://www.elastic.co/guide/en/kibana/current/scripted-fields.html](https://www.elastic.co/guide/en/kibana/current/scripted-fields.html) ---
**Author:** ![elasticheart](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/elasticheart/32/65189_2.png) [@elasticheart](https://discuss.elastic.co/u/elasticheart)\ **Post date:** [April 11, 2017, 11:55am UTC](https://discuss.elastic.co/t/is-it-possible-to-divide-value-in-one-column-with-value-in-another-column-in-kibana-table-visualization/81973/3 "2017-04-11T11:55:06Z")
@Prashant_Agrawal those 2 columns are calculated (sum) fields. Will scripted field work with that? ---
**Author:** ![Prashant\_Agrawal](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/prashant_agrawal/32/74982_2.png) [@Prashant\_Agrawal](https://discuss.elastic.co/u/Prashant_Agrawal)\ **Post date:** [April 11, 2017, 11:56am UTC](https://discuss.elastic.co/t/is-it-possible-to-divide-value-in-one-column-with-value-in-another-column-in-kibana-table-visualization/81973/4 "2017-04-11T11:56:35Z")
You mean sum is not being stored as data , rather it is calculated as sum (colA) ? ---
**Author:** ![elasticheart](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/elasticheart/32/65189_2.png) [@elasticheart](https://discuss.elastic.co/u/elasticheart)\ **Post date:** [April 11, 2017, 12:05pm UTC](https://discuss.elastic.co/t/is-it-possible-to-divide-value-in-one-column-with-value-in-another-column-in-kibana-table-visualization/81973/5 "2017-04-11T12:05:22Z")
Yes. Its getting calculated for table. ---
**Author:** ![Prashant\_Agrawal](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/prashant_agrawal/32/74982_2.png) [@Prashant\_Agrawal](https://discuss.elastic.co/u/Prashant_Agrawal)\ **Post date:** [April 11, 2017, 12:07pm UTC](https://discuss.elastic.co/t/is-it-possible-to-divide-value-in-one-column-with-value-in-another-column-in-kibana-table-visualization/81973/6 "2017-04-11T12:07:54Z")
I don't think we have any option to do same under data table. Probably you can use timelion for same , where you can write a match function something like sum(A) / sum(B) ---
**Author:** ![weltenwort](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/weltenwort/32/53885_2.png) [@weltenwort](https://discuss.elastic.co/u/weltenwort)\ **Post date:** [April 11, 2017, 12:56pm UTC](https://discuss.elastic.co/t/is-it-possible-to-divide-value-in-one-column-with-value-in-another-column-in-kibana-table-visualization/81973/7 "2017-04-11T12:56:48Z")
Hi @elasticcloud, for a table generated via an aggregation that is not possible right now. The required functionality in aggregations equivalent to the scripted field suggested above would be a [bucket script aggregation](https://www.elastic.co/guide/en/elasticsearch/reference/current/search-aggregations-pipeline-bucket-script-aggregation.html) which is not supported by Kibana yet. ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [May 9, 2017, 1:05pm UTC](https://discuss.elastic.co/t/is-it-possible-to-divide-value-in-one-column-with-value-in-another-column-in-kibana-table-visualization/81973/8 "2017-05-09T13:05:16Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.