# Multiple Document Evaluation

**URL:** <https://discuss.elastic.co/t/multiple-document-evaluation/176545>\
**Category:** Elasticsearch\
**Tags:** painless\
**Created:** [April 12, 2019, 6:37am UTC](https://discuss.elastic.co/t/multiple-document-evaluation/176545 "2019-04-12T06:37:52Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![tanmays](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/tanmays/32/43999_2.png) [@tanmays](https://discuss.elastic.co/u/tanmays)\
**Post date:** [April 12, 2019, 6:37am UTC](https://discuss.elastic.co/t/multiple-document-evaluation/176545/1 "2019-04-12T06:37:53Z")

</div>

I want to get the sum of particular value coming in each document and want to get the overall result. Is this possible using painless? If not, is there any alternative for the same?

---

<div class="post-metadata">

**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\
**Post date:** [April 12, 2019, 6:55am UTC](https://discuss.elastic.co/t/multiple-document-evaluation/176545/2 "2019-04-12T06:55:10Z")

</div>

What about the `sum` aggregation?

---

<div class="post-metadata">

**Author:** ![tanmays](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/tanmays/32/43999_2.png) [@tanmays](https://discuss.elastic.co/u/tanmays)\
**Post date:** [April 12, 2019, 6:59am UTC](https://discuss.elastic.co/t/multiple-document-evaluation/176545/3 "2019-04-12T06:59:48Z")

</div>

I can use that, but in my case, I've to perform addition iff some conditions get satisfied in each document individually.  
I think aggregation on "term" isn't possible in ElasticSearch??

---

<div class="post-metadata">

**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\
**Post date:** [April 12, 2019, 7:27am UTC](https://discuss.elastic.co/t/multiple-document-evaluation/176545/4 "2019-04-12T07:27:36Z")

</div>

I think that a `query` that filters the documents you want plus a `sum` agg should work.  
But did you give it a try?

Could you provide a full recreation script as described in [About the Elasticsearch category](https://discuss.elastic.co/t/about-the-elasticsearch-category/21). It will help to better understand what you are doing. Please, try to keep the example as simple as possible.

A full reproduction script will help readers to understand, reproduce and if needed fix your problem. It will also most likely help to get a faster answer.

---

<div class="post-metadata">

**Author:** ![tanmays](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/tanmays/32/43999_2.png) [@tanmays](https://discuss.elastic.co/u/tanmays)\
**Post date:** [April 12, 2019, 7:56am UTC](https://discuss.elastic.co/t/multiple-document-evaluation/176545/5 "2019-04-12T07:56:33Z")

</div>

I also want to know, can painless perform multiple document evaluation?? Means, extracting a particular value from each document and performing some computation, on that particular values together.

eg:

{{  
"status" : "1",  
"value" : "24"  
},  
{  
"status" : "2",  
"value" : "21"  
},  
{  
"status" : "4",  
"value" : "20"  
}}

Task willing to perform :

def count ==0;  
if(doc['status'] == 1 OR doc['status'] == 4){  
count++;  
}

---

<div class="post-metadata">

**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\
**Post date:** [April 12, 2019, 8:10am UTC](https://discuss.elastic.co/t/multiple-document-evaluation/176545/6 "2019-04-12T08:10:00Z")

</div>

Then it's better to compute such a field at index time IMO

---

<div class="post-metadata">

**Author:** ![tanmays](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/tanmays/32/43999_2.png) [@tanmays](https://discuss.elastic.co/u/tanmays)\
**Post date:** [April 12, 2019, 9:21am UTC](https://discuss.elastic.co/t/multiple-document-evaluation/176545/8 "2019-04-12T09:21:48Z")

</div>

Thank you so much!! 🙂

---

<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:** [May 10, 2019, 9:21am UTC](https://discuss.elastic.co/t/multiple-document-evaluation/176545/9 "2019-05-10T09:21:48Z")

</div>

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