# Média da somatória de field

**URL:** <https://discuss.elastic.co/t/media-da-somatoria-de-field/130555>\
**Category:** Kibana\
**Created:** [May 4, 2018, 4:12am UTC](https://discuss.elastic.co/t/media-da-somatoria-de-field/130555 "2018-05-04T04:12:31Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![edmar.machado](https://avatars.discourse-cdn.com/v4/letter/e/96bed5/32.png) [@edmar.machado](https://discuss.elastic.co/u/edmar.machado)\
**Post date:** [May 4, 2018, 4:12am UTC](https://discuss.elastic.co/t/media-da-somatoria-de-field/130555/1 "2018-05-04T04:12:31Z")

</div>

Alguém poderia compartilhar como aplicar uma divisão acumulada sobre a soma de fields?

Exemplo:

![image](https://us1.discourse-cdn.com/elastic/original/3X/6/1/61addaead7a680f64a8d0383bf6b05dcf346d961.png)

Ou seja, sempre preciso somar para depois dividir.

Grato,  
Edmar

---

<div class="post-metadata">

**Author:** ![christophilus](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/christophilus/32/42991_2.png) [@christophilus](https://discuss.elastic.co/u/christophilus)\
**Post date:** [May 4, 2018, 7:18pm UTC](https://discuss.elastic.co/t/media-da-somatoria-de-field/130555/2 "2018-05-04T19:18:38Z")

</div>

I don't speak Portuguese (sorry)! But maybe you can use Google translate as I did to understand your question?

Basically, you can use a pipeline aggregator:

[https://www.elastic.co/guide/en/elasticsearch/reference/current/search-aggregations-pipeline-bucket-script-aggregation.html](https://www.elastic.co/guide/en/elasticsearch/reference/current/search-aggregations-pipeline-bucket-script-aggregation.html)

They're available in Kibana in the Time Series Visual Builder. Here's an example of how you can do it directly (in the Kibana Dev Tools console, for example):

```
PUT myjobs/docs/1
{
  "field1": 44,
  "field2": 5
}

PUT myjobs/docs/2
{
  "field1": 22,
  "field2": 4
}

GET myjobs/_search
{
  "size": 0,
  "aggs": {
    "inelegant": {
      "terms": {
        "script": "'anything'"
      },
      "aggs": {
        "sum_field1": {
          "sum": {
            "field": "field1"
          }
        },
        "sum_field2": {
          "sum": {
            "field": "field2"
          }
        },
        "div_secs": {
          "bucket_script": {
            "buckets_path": {
              "sum_field1": "sum_field1",
              "sum_field2": "sum_field2"
            },
            "script": "params.sum_field1 / params.sum_field2"
          }
        }
      }
    }
  }
}
```

---

<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:** [June 1, 2018, 7:18pm UTC](https://discuss.elastic.co/t/media-da-somatoria-de-field/130555/3 "2018-06-01T19:18:48Z")

</div>

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