# Math operation after aggregation in kibana while using scripted fields

**URL:** <https://discuss.elastic.co/t/math-operation-after-aggregation-in-kibana-while-using-scripted-fields/276602>\
**Category:** Kibana\
**Created:** [June 22, 2021, 4:24am UTC](https://discuss.elastic.co/t/math-operation-after-aggregation-in-kibana-while-using-scripted-fields/276602 "2021-06-22T04:24:31Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![shailendra](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/shailendra/32/90628_2.png) [@shailendra](https://discuss.elastic.co/u/shailendra)\
**Post date:** [June 22, 2021, 4:24am UTC](https://discuss.elastic.co/t/math-operation-after-aggregation-in-kibana-while-using-scripted-fields/276602/1 "2021-06-22T04:24:31Z")

</div>

Hi Everyone,

I have two scripted fields in my kibana index pattern, let's say "scripted field1" and "scripted field2".

Now I wanted to display sum(scripted field1)/sum(scripted field2) in my visualisation.

This kind of arithmetic operations after aggregation are available in tsvb, but as I am using scripted fields, so can't use that.

How can I proceed to get the result.

Thanks in advance

---

<div class="post-metadata">

**Author:** ![flash1293](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/flash1293/32/41227_2.png) [@flash1293](https://discuss.elastic.co/u/flash1293)\
**Post date:** [June 22, 2021, 7:46am UTC](https://discuss.elastic.co/t/math-operation-after-aggregation-in-kibana-while-using-scripted-fields/276602/2 "2021-06-22T07:46:50Z")

</div>

In 7.13 runtime fields got introduced which are the successor of scripted fields. You can use these in TSVB along with the "math" operation.

---

<div class="post-metadata">

**Author:** ![shailendra](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/shailendra/32/90628_2.png) [@shailendra](https://discuss.elastic.co/u/shailendra)\
**Post date:** [June 22, 2021, 1:45pm UTC](https://discuss.elastic.co/t/math-operation-after-aggregation-in-kibana-while-using-scripted-fields/276602/3 "2021-06-22T13:45:28Z")

</div>

Hello Joe,

Thanks for the information.  
But currently we are using 7.8, is there any workaround which we can do.

---

<div class="post-metadata">

**Author:** ![wylie](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/wylie/32/81794_2.png) [@wylie](https://discuss.elastic.co/u/wylie)\
**Post date:** [June 22, 2021, 1:56pm UTC](https://discuss.elastic.co/t/math-operation-after-aggregation-in-kibana-while-using-scripted-fields/276602/4 "2021-06-22T13:56:16Z")

</div>

The only workaround I'm aware of in 7.8 is to use Vega, which is not aware of scripted fields but lets you run full Elasticsearch queries (which can contain scripted fields).

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [July 20, 2021, 1:57pm UTC](https://discuss.elastic.co/t/math-operation-after-aggregation-in-kibana-while-using-scripted-fields/276602/5 "2021-07-20T13:57:09Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.