# Metod of Metric Aggregation for Scripted field in Data table visualisation

**URL:** <https://discuss.elastic.co/t/metod-of-metric-aggregation-for-scripted-field-in-data-table-visualisation/78980>\
**Category:** Kibana\
**Created:** [March 17, 2017, 8:13am UTC](https://discuss.elastic.co/t/metod-of-metric-aggregation-for-scripted-field-in-data-table-visualisation/78980 "2017-03-17T08:13:24Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![dkspace](https://avatars.discourse-cdn.com/v4/letter/d/bc79bd/32.png) [@dkspace](https://discuss.elastic.co/u/dkspace)\
**Post date:** [March 17, 2017, 8:13am UTC](https://discuss.elastic.co/t/metod-of-metric-aggregation-for-scripted-field-in-data-table-visualisation/78980/1 "2017-03-17T08:13:24Z")

</div>

Dear colleagues.

Currently we have the aggregation method only level per Field. (average or min max or etc. ).  
In my case it is not correct method because of result of such kind of aggregation (average or min .. max.. etc ) is the mathematical avg values per fields but not **per total values**.  
But in my case each Field is painless formula.  
**I need other method** : for correct calculation I need to summarize per index all the components of the formula in scripted fields i have and than calculate scripted field formula using summ/tatl of each field..

Could you help me with this solution .  
In case it is possible please share how to do it ?

Thank you in advance.

If do you have some questions , please feel free to ask me

---

<div class="post-metadata">

**Author:** ![ppisljar](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/ppisljar/32/11588_2.png) [@ppisljar](https://discuss.elastic.co/u/ppisljar)\
**Post date:** [March 17, 2017, 9:27am UTC](https://discuss.elastic.co/t/metod-of-metric-aggregation-for-scripted-field-in-data-table-visualisation/78980/2 "2017-03-17T09:27:50Z")

</div>

I don't understand well what you are trying to achieve ... could you show your painless scripts and your aggregation config ?

---

<div class="post-metadata">

**Author:** ![dkspace](https://avatars.discourse-cdn.com/v4/letter/d/bc79bd/32.png) [@dkspace](https://discuss.elastic.co/u/dkspace)\
**Post date:** [March 18, 2017, 11:12pm UTC](https://discuss.elastic.co/t/metod-of-metric-aggregation-for-scripted-field-in-data-table-visualisation/78980/3 "2017-03-18T23:12:12Z")

</div>

for example

ULIpThruAvg (Mbps) painless def ULIpThruAvg = 0; if (doc['ULIpThruTime (TTI)'].value == 0) {return 0} else {ULIpThruAvg = (8\*doc['ULIpThruVol (kbytes)'].value/doc['ULIpThruTime (TTI)'].value); return ULIpThruAvg; }

Aggregation is simple = Average.

But it`s logic for not what i realy need. I need :  
ULIpThruAvg = (8\*SUMM(doc['ULIpThruVol (kbytes)'].value) /SUMM ( doc['ULIpThruTime (TTI)'].value)); return ULIpThruAvg;

How to do it ?

**SUMM ()** means for full index (all documents in index) or for selected Time Range (yesterday and etc... )

---

<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:** [April 15, 2017, 11:12pm UTC](https://discuss.elastic.co/t/metod-of-metric-aggregation-for-scripted-field-in-data-table-visualisation/78980/4 "2017-04-15T23:12:33Z")

</div>

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